Duh! Nevermind...
I checked the ODBC datasource setup and had put the correct Data Source Name 'rchnetwork-mainoffice' in the 'Data Source Name' field, but in the 'Database Name' field, I didn't change it from 'test'. Duh! I say, duh! (Not a good way to start off the new year!) Rick -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 4:27 PM To: CF-Talk Subject: Error saying "test.passwords" table not found...That's because there's not one! Hi, all...Happy New Year... I've been working with CF (4.5.2) and MySQL (4.0.7 gamma) for a few weeks on my development box (Win 2000 Pro) and have just setup MySQL and MyODBC on my Win 2000 Server. Everything seemed fine until I tried to login on an app that I built to run on that server. I get the error that [MySQL][ODBC 3.51 Driver][mysqld-4.0.7-gamma-nt] Table 'test.passwords' doesn't exist That's true, there is no table called 'passwords' in the test db (the test db was something installed by PremiumSoft's Navicat or perhaps by MySQL itself). The fact that there is not 'passwords' table in the test db shouldn't matter, because that't not even the datasource that I'm querying with CF..I'm querying 'rchnetwork-mainoffice' db and 'passwords' table is in there. Why would it be trying to look in to the 'test' datasource for the 'passwords' table and not in the 'rchnetwork-mainoffice' datasource during the query? The query has been running fine on my development box... <CFQUERY Name="CheckPassword" Datasource="#DSN#"> Select UserID from Passwords P where P.Password='#Form.Password#' </CFQUERY> Clues? Thanks, Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
