From: Phil Jones (jediwebdudeyahoo.com)
Date: Sat Aug 27 2005 - 00:42:30 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]