[thelist] sql/server connectivity question
David at softv.net
David at softv.net
Thu Sep 20 13:26:15 CDT 2001
Rudy,
I would also suggest using the native OLEDB for SQL Server instead of
ODBC.
Your connection string would be as follows:
strConnString = "Provider=SQLOLEDB; Data Source=servername;
Database=dbname; UID=username; Pwd=password"
cn.Open(strConnString)
Dave
-----Original Message-----
From: rudy [mailto:r937 at interlog.com]
Sent: Thursday, September 20, 2001 1:36 PM
To: thelist at lists.evolt.org
Subject: [thelist] sql/server connectivity question
hoping one of you sql/server gurus can answer this
off the top of your head...
what would you look for to solve this error --
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified
/QuoteResults2.asp, line 255
the line that's causing the problem is
cn.Open("MM_advancewarranty_STRING")
the value of this variable is
"dsn=accs; database=BUYERS_CHOICE; uid=IUSR_ATLAS;"
just before this there is the command
set cn = server.CreateObject("ADODB.Connection")
i know practically nothing about ASP
any ideas?
take the quotes out of the cn.Open command?
maybe some setting in the sql/server configuration is wrong?
rudy
---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !
More information about the thelist
mailing list