Posted by ma.giorgi on 01/08/07 14:52

Hi!

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.

do I have to install something on the web server???

• Next in forum: Damn! SQLServer2000 can't add a NOT NULL COLUMN even in one empty existing table!
• Prev in forum: Re: BCP import with Blank lines in text file
• Thread view: Connection from ASP page to SQL Server Express

[Reply to this message]