A fair amount of people simply start table names with 'tbl', which would solve your problems.
-----Original Message----- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: 13 August 2003 14:28 To: CF-Talk Subject: RE: Moving from MySQL to MS SQL Server 2000 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
