[thelist] sql/server connectivity question

[David at softv.net]

If MM_advancewarranty_STRING is a variable name, it shouldn't be
enclosed in quotes

<%
David Mitchell
Web Developer
david at sofTV.net
sofTV.net
www.sofTV.net
613.729.6400 x268
%>
www.IceRadio.ca
"Canada's Best Music on the Web"


-----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 !