You mentioned earlier that '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.' Have you checked that the data source is working/valid using CF admin?
You could also try to see if it's only that table where the error is occuring or if its other queries run through cf too. - I assume that as it's a check login function it runs before pretty much any other code? Alex > -----Original Message----- > From: Ben Forta [mailto:[EMAIL PROTECTED] > Sent: 13 August 2003 14:48 > To: CF-Talk > Subject: RE: Moving from MySQL to MS SQL Server 2000 > > > Execute sp_tables and see what tables get returned, make sure > "tbllogin" > is listed. > > > > -----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'. > > > On Wed, 13 Aug 2003 09:39:00 -0400, Bryan F. Hogan wrote: > > > Don't know I've never worked with MySQL. It's just good > design. I had > > the same problem when I first started, I would rack my > brain, bang my > > head against the wall, scream, holler, etc. Then someone > finally told > > me it was a reserved word and I kicked my ex boss in the head. :) > > > > -----Original Message----- > > From: Bushy [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, August 13, 2003 9:37 AM > > To: CF-Talk > > Subject: RE: Moving from MySQL to MS SQL Server 2000 > > > > > > OK...It seems MySQL is more forgiving. > > > > > > Thanks > > > > > > On Wed, 13 Aug 2003 14:28:13 +0100, Craig Dudley wrote: > > > > > 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4