Re: Moving from MySQL to MS SQL Server 2000
Ben Forta wrote: > Less forgiving perhaps, or it could be that it just does a lot less and > thus has less reserved words. Don't get me wrong, I like MySQL and use > it myself for some projects, but it is nowhere near as feature rich > (yet) as SQL Server (or Oracle or ...). The problem is lack of standard compliance. According to the standard, you can bypass any reserved word issue by enclosing the identifier in identifier quotes. But if you don't use them, or use a database that doesn't support them, you are bound to run into problems. Jochemn ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Moving from MySQL to MS SQL Server 2000
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 > > > HmmmI 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 > > > select * from tbllogin > > > 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. > > > > > > > > > select * from login > > > > > > > > > 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 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
RE: Moving from MySQL to MS SQL Server 2000
Have you granted the user (that cf is using to connect with) permission to see the tables? > HmmmI 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 > > > select * from tbllogin > > > 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. > > > > > > > > > select * from login > > > > > > > > > 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 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 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
RE: Moving from MySQL to MS SQL Server 2000
Less forgiving perhaps, or it could be that it just does a lot less and thus has less reserved words. Don't get me wrong, I like MySQL and use it myself for some projects, but it is nowhere near as feature rich (yet) as SQL Server (or Oracle or ...). --- Ben -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. > > > select * from login > > > 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 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
RE: Moving from MySQL to MS SQL Server 2000
Yes, this is exactly what I do Bushy. If you do that you will never have a problem like you have. Thanks Craig. -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 9:28 AM To: CF-Talk Subject: RE: Moving from MySQL to MS SQL Server 2000 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. ~| 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
RE: Moving from MySQL to MS SQL Server 2000
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. select * from login 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 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
RE: Moving from MySQL to MS SQL Server 2000
I don't think this is related, but worth checking nonetheless - If you set-up a user (in sql server) for this datasource, make sure that user has permissions to select, update, insert, etc. As a side note, I always set-up a user specifically for the datasource and grant permissions accordingly, never use sa for your cf apps. Sorry for the digression there, just thought it was a point worth making. Mark -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 HmmmI 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 select * from tbllogin 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. > > > > > > select * from login > > > > > > 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 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
RE: Moving from MySQL to MS SQL Server 2000
Problem was with SQL username/password at time of installation. Once I fixed that it was fine. Will I run into problems if I name my databases with this syntax? Will the "_" cause me problems in SQL or CF ? interface_prefs ~| 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
RE: Moving from MySQL to MS SQL Server 2000
If I were you I would check the "database" setting in CF Admin. Without it, you connect, but the databse serves up the "default db" for your username. This can result in a successful connection to an unexpected database (usually "master"). -Mark -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 8:45 AM To: CF-Talk Subject: RE: Moving from MySQL to MS SQL Server 2000 HmmmI 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 select * from tbllogin 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. > > > > > > select * from login > > > > > > 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 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 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
RE: Moving from MySQL to MS SQL Server 2000
It's a simple query. select * from login 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 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
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 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
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. > > > select * from login > > > 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 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
RE: Moving from MySQL to MS SQL Server 2000
"Problem was with SQL username/password at time of installation. Once I fixed that it was fine." You still would have run into other problems. It was a good thing that you posted today. Using the underscore character as your db name isn't a problem. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 12:24 PM To: CF-Talk Subject: RE: Moving from MySQL to MS SQL Server 2000 Problem was with SQL username/password at time of installation. Once I fixed that it was fine. Will I run into problems if I name my databases with this syntax? Will the "_" cause me problems in SQL or CF ? interface_prefs ~| 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
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. select * from login 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 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
RE: Moving from MySQL to MS SQL Server 2000
Have you told the datasource (in CFAdmin) to look at the correct database? My initial thoughts are that its looking at the default DB which is probably master. HTH Mikey -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 14:45 To: CF-Talk Subject: RE: Moving from MySQL to MS SQL Server 2000 HmmmI 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 select * from tbllogin 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. > > > > > > select * from login > > > > > > 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 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
RE: Moving from MySQL to MS SQL Server 2000
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. > > > select * from login > > > 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 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
RE: Moving from MySQL to MS SQL Server 2000
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 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 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
RE: Moving from MySQL to MS SQL Server 2000
where did you declare your DSN? in coldfusion administrator or in the System DSN window from your windows => Services? -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: woensdag 13 augustus 2003 15:45 To: CF-Talk Subject: RE: Moving from MySQL to MS SQL Server 2000 HmmmI 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 select * from tbllogin 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. > > > > > > select * from login > > > > > > 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 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
RE: Moving from MySQL to MS SQL Server 2000
HmmmI 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 select * from tbllogin 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. > > > > > > select * from login > > > > > > 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 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
Re: Moving from MySQL to MS SQL Server 2000
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 > HmmmI 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 > > > select * from tbllogin > > > 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. > > > > > > > > > select * from login > > > > > > > > > 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 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
RE: Moving from MySQL to MS SQL Server 2000
Forgive me if I'm wrong , but double and triple check the datasource is actually pointing at the correct database ;-) -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: 13 August 2003 14:45 To: CF-Talk Subject: RE: Moving from MySQL to MS SQL Server 2000 HmmmI 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 select * from tbllogin 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. > > > > > > select * from login > > > > > > 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 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
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 HmmmI 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 select * from tbllogin 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. > > > > > > select * from login > > > > > > 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 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 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
RE: Moving from MySQL to MS SQL Server 2000
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 HmmmI 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 select * from tbllogin 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
