Bushy, double check that your datasource is pointing to the correct database.
-----Original Message----- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 9:45 AM To: CF-Talk Subject: RE: Moving from MySQL to MS SQL Server 2000 Hmmm....I just changed all the table names to have "tbl" at the beginning. I ran a test using the SQL Query Analyzer. Just did a simple select * from tbllogin Worked fine until I tried to run the simple query within my .CFM template <cfquery name="checkpass" datasource="databasename"> select * from tbllogin </cfquery> and I get the same error as before? I don't know whats going on. ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'tbllogin'. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
