Re: Connection error to SQL Server
From: Kevin Spencer (kspencer_at_takempis.com)
Date: 06/17/04
- Next message: Kevin Spencer: "Re: Acessing property"
- Previous message: bredal Jensen: "Re: Booking puzzle...."
- In reply to: Javier Camacho: "Re: Connection error to SQL Server"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 17 Jun 2004 09:21:05 -0400
> 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.camacho@eurodivisas.com> wrote in message news:#nJ37lEVEHA.3428@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" <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 > > > > >
- Next message: Kevin Spencer: "Re: Acessing property"
- Previous message: bredal Jensen: "Re: Booking puzzle...."
- In reply to: Javier Camacho: "Re: Connection error to SQL Server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
