Connection error to SQL Server

  • Thread starter Thread starter Javier Camacho
  • Start date Start date
J

Javier Camacho

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
 
Did you try using SQLConnection instead of OleDbConnection?

Shankar

Javier said:
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
Click to expand...
 
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 said:
Did you try using SQLConnection instead of OleDbConnection?

Shankar

Javier said:
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
Click to expand...
Click to expand...
 
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.
Click to expand...

You can certainly eliminate that as a possibility. .Net and COM are totally
separate technologies and do not interoperate with each other, unless you
deliberately make them do so in your app, using COM interop, which I see no
evidence of.

It sounds more like a network error, although using the VS.Net debugger to
peek at the exception details would help to pin it down better. Try using
the IP address of the machine instead of the machine name. And if you can
debug the exception, it would help too.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

Javier Camacho said:
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 said:
Did you try using SQLConnection instead of OleDbConnection?

Shankar
Click to expand...
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top