Connection error to SQL Server

[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

[Shankara Narayanan]

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

[Javier Camacho]

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" <js*****@yahoo.co.in> escribió en el mensaje
news:uY**************@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 todatabase 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 andwho should we do to resolve them.

Regards,
Javier

--
With best Regards
Shankara Narayanan

[Kevin Spencer]

> 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.
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" <j.*******@eurodivisas.com> wrote in message
news:#n**************@TK2MSFTNGP12.phx.gbl... 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" <js*****@yahoo.co.in> escribió en el mensaje
news:uY**************@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),

theASP.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 andwho should we do to resolve them.

Regards,
Javier

--
With best Regards
Shankara Narayanan