If you set up a ODBC datasource in Control Panel, make sure that the default database is the one you are connecting to and not the master.
Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm ----- Original Message ----- From: "Bushy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 13, 2003 9:45 AM 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 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