Login is a reserved word. Change the login table name to something else and it will work. Try not to use names for anything that are simple names, such as login, password, name, position, etc.
-----Original Message----- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 9:27 AM To: CF-Talk Subject: RE: Moving from MySQL to MS SQL Server 2000 It's a simple query. <cfquery name="checkpass" datasource="databasename"> select * from login </cfquery> I've added the database via Data Sources (ODBC) under the System DSN tab using the SQL Server driver. I did a test and it passed. On Wed, 13 Aug 2003 09:03:55 -0400, Mark Stewart wrote: > The only thing I had to do was change the double quotes to single quotes. As for the error, could you post the query so we can see what's going on? > > Mark > > -----Original Message----- > From: Bushy [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 13, 2003 7:21 AM > To: CF-Talk > Subject: re: Moving from MySQL to MS SQL Server 2000 > > > Hi, > > I've just migrated my databases over to SQL server. DO I need to change any of my CF code especially my <cfquery> tags? > > I get this error when running my app. > > ODBC Error Code = S0002 (Base table not found) > > [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'login'. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
