Re: Connection error to SQL Server

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Javier Camacho (j.camacho_at_eurodivisas.com)
Date: 06/17/04 

Date: Thu, 17 Jun 2004 10:58:51 +0200

Yes, we've try with SQLConnection and doesn't work, in addition the
conecction works in the winform application, only ASP.NET webform doesn't
work. We've try with OLEDB connection, ODBC using DSN, etc... any connect
ways works in the ASP.NET application.

This is a type connection that we're using:

Dim conexion As OleDbConnection
Dim comando As OleDbCommand
Dim StrConexion, StrComando As String
Dim Lector As OleDbDataReader
StrConexion = "Provider=SQLOLEDB;Server=CENTRAL;Initial
Catalog=Aplicacion;Uid=admvent; Pwd=5g3Gr;"
conexion = New OleDbConnection(StrConexion) '
conexion.Open()

I think that de ADO components includes in the Delphi 7 currupts some part
of the .NET Framework ADO.NET components, but I'm not sure.

Any guess ?

Thanks

"Shankara Narayanan" <jshanki@yahoo.co.in> escribió en el mensaje
news:uYL2yPEVEHA.2988@TK2MSFTNGP10.phx.gbl...
> Did you try using SQLConnection instead of OleDbConnection?
>
> Shankar
>
> Javier Camacho wrote:
>
> >Hi,
> >
> >We've a computer ( in our develepment group) that has installed Visual
> >Studio.NET 2003 and Delphi 5 and Delphi 7 . When the user try to connect
to
> >database in the SQL Server (installed on the remote database server), the
> >ASP.NET applicatión gives this error message :
> >
> >System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionOpen (Connect()).]
> >
> >We've check that de user/password and the servername is correct.
> >
> >I understand that the error is because Delphi must be incompatible with
de
> >..NET Framework. We've try many ways in order to identify the problem,
i.e:
> >reinstall .NET Framework, MDAC, IIS, etc... but the problem persist.
> >
> >If anyone has have the same problem, please tell us wich is the problem
and
> >who should we do to resolve them.
> >
> >Regards,
> >Javier
> >
> >
> >
> >
> >
>
> --
> With best Regards
> Shankara Narayanan
>

Relevant Pages

  • Re: Speichern von Messwerten in einer Access Datenbank
    ... ByVal DCol As String) ... Dim my_Con As OleDbConnection = Nothing ... Dim cmd As OleDbCommand, s As String, res As Int16 ... Werte Parameterobjekt verwendest. ...
    (microsoft.public.de.german.entwickler.dotnet.vb)
  • Re: sql call not working but should!
    ... > I have this login routine that I can't seem to get the Sub loginpartner to work. ... If I replace it with the Sub loginnasba sql statement, modifying the fields that get populated from the form accordingly, then login works! ... > 'create/open connection and objects> Dim SqlConnect2 as SqlConnection ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Update Access 2000 aus VB 2005
    ... Dim connection As OleDbConnection = New OleDbConnection(_ ... Dim artikelAdapter As OleDbDataAdapter = New OleDbDataAdapter(_ ... Dim selectCommand As OleDbCommand = New OleDbCommand(_ ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • Re: sql call not working but should!
    ... If I replace it with the Sub ... Dim SqlConnect2 as SqlConnection ... > 'Now update company last login information ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Global ASAX
    ... > and in your code inside the HTML, ... > want to store the connection string in the Application variable and create ... > new instances of OleDbConnection as needed...having instances of objects ... >> Dim objConnection As OleDbConnection ...
    (microsoft.public.dotnet.framework.aspnet)