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 !