This is quite odd. I have five .asp pages all using
the exact same connection code. For some reason, one
of the pages is getting a "No Database Selected"
error, yet the other four are not, which leads me to
believe my DSN config works fine. Below are the
details.
**** Getting the following error: ****
Microsoft OLE DB Provider for ODBC Drivers error
'80004005'
No Database Selected
line 64
**** Here is line 64: ****
Set rs = conn.execute(sql)
**** Here are env details: ****
MySQL ODBC Driver: 3.51.11.1
Lang: ASP
O/S: Win Server 2003
Webserver: IIS
**** Here is entire connection code: ****
set conn = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.Recordset")
conn.open "DRIVER={MySQL ODBC 3.51
Driver};SERVER=localhost;
UID=b-----r;PWD=d-----r;DSN=b-----c;"
sql = "select state_idx, state_abbr from state where
active_ind = 'A' "
Set rs = conn.execute(sql)
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
