Posted by Erland Sommarskog on 01/08/07 22:55

(ma.giorgi@gmail.com) writes:
> I have two servers, the web (with IIS - win2003) and the test data
> server (winXPpro with SQL Express)
> I'm trying to connect to the db but with no success...
> here is the connection string I'm using:
> sConn = "Driver=SQLNCLI;
> Server=marco-server\SQLEXPRESS;
> Database=grimp;
> Uid=grimpuser;
> Pwd=somePassword;"
>
> I get this:
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC Driver Manager] Data source name not found and no
> default driver specified
>
> I've tried also with Driver={SQL Native Client} but I get the same
> error.

Try using "Provider", rather than "Driver".


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]