Re: Connection String in SQL Server 2005 giving errors

Jason

What is the Connection String that you are using?

Mark Moss

"Jason Fischer" <jason_fischer_aus@xxxxxxxxxxxxxx> wrote in message
news:44233900@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I am using SQLOLEDB and can connect to a SQL 2005 DB?


"Viatcheslav V. Vassiliev" <support@xxxxxxxxxxxxxxx> wrote in message
news:4422f5c1$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Do you use new provider name for MS SQL Server 2005? It is SQLNCLI, not
SQLOLEDB as for MS SQL Server 2000.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Mark Moss" <markmoss@xxxxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ:
news:4422a6e5@xxxxxxxxxxxxxxxxxxxxxxxxx
HELP


I moved a database and application created in MS SQL Server 2000
to
MS SQL 2005 Express. And when I run the applications I am getting
'SQL
Server does not exists or Access Denied' error.

I can find nothing wrong with the connection string that I am
using,
so I tried an old trick to create a new one on the MS SQL 2005 Express
machine

Create a blank file in notepas and name it something.udl
Double click on something.udl
It will open the UDL creator asking for Server etc.
I could not get this to find the SQL Server either using (local)
or
Drop down or SQLExpress

HELP

How can I find out what is wrong with my connection string?

Mark Moss








.

Relevant Pages