Re: ODBC Error Code = S0002 (Base table not found)
take off all references of dbo. - Original Message - From: Martin S [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 5:14 PM Subject: ODBC Error Code = S0002 (Base table not found) Hello all, I have been using coldFusion now for almost a year, including interacting with DB (before just MS.Access). Now I am a sole developer on a project requiring interfacing with Ms.SQl Server. This new adventure is seeing my we problems I have never seen before. Before I go in to the problem, to my knowledge I have the DB source set up corretly (in both CFAMINISTRATOR and WIN NT). I have created a query in ColdFusion successfully using the Query Builder. Within the query buildr I can exeute the query with no problems. However, when I drag and drop the Query in to my page, and run the page the following error occurs (however, as I said this error didn't occur in the ColdFusion Query Builder) : Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:1) to (10:26). Date/Time: 10/30/00 10:55:36 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT) Remote Address: 203.43.104.222 Template: C:\Inetpub\wwwroot\TGV-Admin\MerchantFindAction.cfm -- -- On the side I am using ColdFusion 4.0 currently. Work hasn't upgraded :-( Thanks for your help..please CC your reply to [EMAIL PROTECTED] - I check this email much more regulary - several times daily. Thanks in advance. Adios. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
It will likely be advised that you consider changing your "Select *" to the actual field/columns you need. Select myDB.dbo.Billers.Merchant_Name, myDB.dbo.Billers.Merchant_Address1, myDB.dbo.Billers.Merchant_ZipCode, myDB.dbo.Billers.Merchant_Shoe_Size, etc. many around here consider Select* to be bad form. tho thats not likely causing your error. you may need the database.owner.tablename syntax : Merchant_Name FROM database_name.dbo.Billers WHERE (Merchant_Name or even: Merchant_Name FROM sql_server_name.database_name.dbo.Billers WHERE .. --- Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
Or that :-) depends take off all references of dbo. - Original Message - From: Martin S [EMAIL PROTECTED] Hello all, I have been using coldFusion now for almost a year, including interacting with DB (before just MS.Access). Now I am a sole developer on a project requiring interfacing with Ms.SQl Server. This new adventure is seeing my we problems I have never seen before. Before I go in to the problem, to my knowledge I have the DB source set up corretly (in both CFAMINISTRATOR and WIN NT). I have created a query in ColdFusion successfully using the Query Builder. Within the query buildr I can exeute the query with no problems. However, when I drag and drop the Query in to my page, and run the page the following error occurs (however, as I said this error didn't occur in the ColdFusion Query Builder) : Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:1) to (10:26). Date/Time: 10/30/00 10:55:36 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT) Remote Address: 203.43.104.222 Template: C:\Inetpub\wwwroot\TGV-Admin\MerchantFindAction.cfm -- -- On the side I am using ColdFusion 4.0 currently. Work hasn't upgraded :-( Thanks for your help..please CC your reply to [EMAIL PROTECTED] - I check this email much more regulary - several times daily. Thanks in advance. Adios. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
I have tried removing the .dbo before and no that didn't seem to work. I have also tried to add the name of the datasource (db) to the beginning (ie.db.dbo.blahblah). This was just in a rage of brain storming and that didn't work. Is that what you were talking about by saying myDB.db.blahblah or something else, if so can you elaberate a little further. I know about th * being bad form..just a temp test DB page :-) Thanks anyway. Thanks again all. From: "Stephen M. Aylor" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 16:34:35 -0800 It will likely be advised that you consider changing your "Select *" to the actual field/columns you need. Select myDB.dbo.Billers.Merchant_Name, myDB.dbo.Billers.Merchant_Address1, myDB.dbo.Billers.Merchant_ZipCode, myDB.dbo.Billers.Merchant_Shoe_Size, etc. many around here consider Select* to be bad form. tho thats not likely causing your error. you may need the database.owner.tablename syntax : Merchant_Name FROM database_name.dbo.Billers WHERE (Merchant_Name or even: Merchant_Name FROM sql_server_name.database_name.dbo.Billers WHERE .. --- Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
When you created the ODBC datasource, you have to point to the database you want to connect. By default its the master dB. Go in Control Panel\ODBC and edit the datasource. This should fix the problem Marius Milosav www.scorpiosoft.com Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 8:22 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) I have tried removing the .dbo before and no that didn't seem to work. I have also tried to add the name of the datasource (db) to the beginning (ie.db.dbo.blahblah). This was just in a rage of brain storming and that didn't work. Is that what you were talking about by saying myDB.db.blahblah or something else, if so can you elaberate a little further. I know about th * being bad form..just a temp test DB page :-) Thanks anyway. Thanks again all. From: "Stephen M. Aylor" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 16:34:35 -0800 It will likely be advised that you consider changing your "Select *" to the actual field/columns you need. Select myDB.dbo.Billers.Merchant_Name, myDB.dbo.Billers.Merchant_Address1, myDB.dbo.Billers.Merchant_ZipCode, myDB.dbo.Billers.Merchant_Shoe_Size, etc. many around here consider Select* to be bad form. tho thats not likely causing your error. you may need the database.owner.tablename syntax : Merchant_Name FROM database_name.dbo.Billers WHERE (Merchant_Name or even: Merchant_Name FROM sql_server_name.database_name.dbo.Billers WHERE .. --- Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" --- - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
Hey... to make it simple go through Cold Fusion ODBC. do this by pointing
your browser to something like
http://yourserver.com/cfide/Administrator/index.cfm
Create the ODBC that way...
- Original Message -
From: Marius Milosav [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, October 29, 2000 7:15 PM
Subject: Re: ODBC Error Code = S0002 (Base table not found)
If the database name is correct, check that you authenticate using SQL
server authentication and you provide the same login information in
ColdFusion Administrator.
Also, I hope that you created the ODBC datasource as System DSN
Marius Milosav
www.scorpiosoft.com
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm
- Original Message -
From: "Martin S" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Sunday, October 29, 2000 8:57 PM
Subject: Re: ODBC Error Code = S0002 (Base table not found)
Marius and all,
Sorry about this. I am new to accessing DBs other than Access in
COldFusion..so excuse my ignorance when it comes to this.
I belive I have done what you say, but please verify this with me, as I
am
after all new to this frontier.
I just went to confirm this from the ontrol Panel, ODBC DS, System DSN,
and
it was all there..I checked it etc..
and at the end it came up with this test successfull result :
Microsoft SQL Server ODBC Driver Version 03.70.0623
Data Source Name: BP
Data Source Description: Internet Billpay Staging box
Server: ###.
Database: TGV
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Integrated Security: No
Use Regional Settings: Yes
Prepared Statements Option: Drop temporary procedures on disconnect
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Whwere does this leave me?
From: "Marius Milosav" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: ODBC Error Code = S0002 (Base table not found)
Date: Sun, 29 Oct 2000 20:55:00 -0500
When you created the ODBC datasource, you have to point to the database
you
want to connect. By default its the master dB.
Go in Control Panel\ODBC and edit the datasource. This should fix the
problem
Marius Milosav
www.scorpiosoft.com
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm
- Original Message -
From: "Martin S" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Sunday, October 29, 2000 8:22 PM
Subject: Re: ODBC Error Code = S0002 (Base table not found)
I have tried removing the .dbo before and no that didn't seem to
work.
I have also tried to add the name of the datasource (db) to the
beginning
(ie.db.dbo.blahblah). This was just in a rage of brain storming and
that
didn't work. Is that what you were talking about by saying
myDB.db.blahblah
or something else, if so can you elaberate a little further.
I know about th * being bad form..just a temp test DB page :-)
Thanks
anyway.
Thanks again all.
From: "Stephen M. Aylor" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: ODBC Error Code = S0002 (Base table not found)
Date: Sun, 29 Oct 2000 16:34:35 -0800
It will likely be advised that you consider changing your "Select
*"
to
the
actual field/columns you need.
Select myDB.dbo.Billers.Merchant_Name,
myDB.dbo.Billers.Merchant_Address1,
myDB.dbo.Billers.Merchant_ZipCode,
myDB.dbo.Billers.Merchant_Shoe_Size, etc.
many around here consider Select* to be bad form. tho thats not
likely
causing your error.
you may need the database.owner.tablename syntax :
Merchant_Name FROM database_name.dbo.Billers WHERE
(Merchant_Name
or even:
Merchant_Name FROM sql_server_name.database_name.dbo.Billers
WHERE
..
---
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = S0002 (Base table not found)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object
name
'dbo.Billers'.
SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE
(Merchant_Name
LIKE
'43')"
---
-
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
or
send
a
message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
__
Re: ODBC Error Code = S0002 (Base table not found)
Marius et al. Yes, that is all correct as far as I can tell thus can't be causing the error. the dot notion in the query..hould I do datasourcename.db.fieldname or something else? Cos someone was touching on that before..but I couldn't understand their post. Thanks, Martin. From: "Marius Milosav" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 21:15:15 -0500 If the database name is correct, check that you authenticate using SQL server authentication and you provide the same login information in ColdFusion Administrator. Also, I hope that you created the ODBC datasource as System DSN Marius Milosav www.scorpiosoft.com Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 8:57 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) Marius and all, Sorry about this. I am new to accessing DBs other than Access in COldFusion..so excuse my ignorance when it comes to this. I belive I have done what you say, but please verify this with me, as I am after all new to this frontier. I just went to confirm this from the ontrol Panel, ODBC DS, System DSN, and it was all there..I checked it etc.. and at the end it came up with this test successfull result : Microsoft SQL Server ODBC Driver Version 03.70.0623 Data Source Name: BP Data Source Description: Internet Billpay Staging box Server: ###. Database: TGV Language: (Default) Translate Character Data: Yes Log Long Running Queries: No Log Driver Statistics: No Use Integrated Security: No Use Regional Settings: Yes Prepared Statements Option: Drop temporary procedures on disconnect Use Failover Server: No Use ANSI Quoted Identifiers: Yes Use ANSI Null, Paddings and Warnings: Yes Whwere does this leave me? From: "Marius Milosav" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 20:55:00 -0500 When you created the ODBC datasource, you have to point to the database you want to connect. By default its the master dB. Go in Control Panel\ODBC and edit the datasource. This should fix the problem Marius Milosav www.scorpiosoft.com Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 8:22 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) I have tried removing the .dbo before and no that didn't seem to work. I have also tried to add the name of the datasource (db) to the beginning (ie.db.dbo.blahblah). This was just in a rage of brain storming and that didn't work. Is that what you were talking about by saying myDB.db.blahblah or something else, if so can you elaberate a little further. I know about th * being bad form..just a temp test DB page :-) Thanks anyway. Thanks again all. From: "Stephen M. Aylor" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ODBC Error Code = S0002 (Base table not found) Date: Sun, 29 Oct 2000 16:34:35 -0800 It will likely be advised that you consider changing your "Select *" to the actual field/columns you need. Select myDB.dbo.Billers.Merchant_Name, myDB.dbo.Billers.Merchant_Address1, myDB.dbo.Billers.Merchant_ZipCode, myDB.dbo.Billers.Merchant_Shoe_Size, etc. many around here consider Select* to be bad form. tho thats not likely causing your error. you may need the database.owner.tablename syntax : Merchant_Name FROM database_name.dbo.Billers WHERE (Merchant_Name or even: Merchant_Name FROM sql_server_name.database_name.dbo.Billers WHERE .. --- Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Billers'. SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name LIKE '43')" --- - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sideb
Re: ODBC Error Code = S0002 (Base table not found)
I have..
The thing is I am doing the Cold Fusion remotely on a different computer on
the network.
I have set up the remote computer (where the Code and DB is stored)
datasource settings in Both NT and ColdFusion Admin..as well a the local
computer (my pc) datasource settings in both NT and ColdFusion Admin. I am
not sure if this is over-kill or required but as I said I am new to using a
DB other than Acss (which I haven't had many problems with before) and
working remotely, so to speak.
Thanks,
Martin.
From: [EMAIL PROTECTED] (Brian bouldernet)
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: ODBC Error Code = S0002 (Base table not found)
Date: Sun, 29 Oct 2000 20:25:14 -0700
Hey... to make it simple go through Cold Fusion ODBC. do this by pointing
your browser to something like
http://yourserver.com/cfide/Administrator/index.cfm
Create the ODBC that way...
- Original Message -
From: Marius Milosav [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, October 29, 2000 7:15 PM
Subject: Re: ODBC Error Code = S0002 (Base table not found)
If the database name is correct, check that you authenticate using SQL
server authentication and you provide the same login information in
ColdFusion Administrator.
Also, I hope that you created the ODBC datasource as System DSN
Marius Milosav
www.scorpiosoft.com
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm
- Original Message -
From: "Martin S" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Sunday, October 29, 2000 8:57 PM
Subject: Re: ODBC Error Code = S0002 (Base table not found)
Marius and all,
Sorry about this. I am new to accessing DBs other than Access in
COldFusion..so excuse my ignorance when it comes to this.
I belive I have done what you say, but please verify this with me, as
I
am
after all new to this frontier.
I just went to confirm this from the ontrol Panel, ODBC DS, System
DSN,
and
it was all there..I checked it etc..
and at the end it came up with this test successfull result :
Microsoft SQL Server ODBC Driver Version 03.70.0623
Data Source Name: BP
Data Source Description: Internet Billpay Staging box
Server: ###.
Database: TGV
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Integrated Security: No
Use Regional Settings: Yes
Prepared Statements Option: Drop temporary procedures on disconnect
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Whwere does this leave me?
From: "Marius Milosav" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: ODBC Error Code = S0002 (Base table not found)
Date: Sun, 29 Oct 2000 20:55:00 -0500
When you created the ODBC datasource, you have to point to the
database
you
want to connect. By default its the master dB.
Go in Control Panel\ODBC and edit the datasource. This should fix the
problem
Marius Milosav
www.scorpiosoft.com
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm
- Original Message -
From: "Martin S" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Sunday, October 29, 2000 8:22 PM
Subject: Re: ODBC Error Code = S0002 (Base table not found)
I have tried removing the .dbo before and no that didn't seem to
work.
I have also tried to add the name of the datasource (db) to the
beginning
(ie.db.dbo.blahblah). This was just in a rage of brain storming
and
that
didn't work. Is that what you were talking about by saying
myDB.db.blahblah
or something else, if so can you elaberate a little further.
I know about th * being bad form..just a temp test DB page :-)
Thanks
anyway.
Thanks again all.
From: "Stephen M. Aylor" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: ODBC Error Code = S0002 (Base table not found)
Date: Sun, 29 Oct 2000 16:34:35 -0800
It will likely be advised that you consider changing your "Select
*"
to
the
actual field/columns you need.
Select myDB.dbo.Billers.Merchant_Name,
myDB.dbo.Billers.Merchant_Address1,
myDB.dbo.Billers.Merchant_ZipCode,
myDB.dbo.Billers.Merchant_Shoe_Size, etc.
many around here consider Select* to be bad form. tho thats not
likely
causing your error.
you may need the database.owner.tablename syntax :
Merchant_Name FROM database_name.dbo.Billers WHERE
(Merchant_Name
or even:
...
Re: ODBC Error Code = S0002 (Base table not found)
cfquery datasource="BP" username="yourusername" password="Your_pwd" Select * from TGV.dbo.tablename.column_name WHERE some_column_name = '43' /cfquery Are you absolutely positive that the table "name" your using in your query statement actually exists in the database ? Steve - Original Message - From: "Martin S" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 6:50 PM Subject: Re: ODBC Error Code = S0002 (Base table not found) Marius et al. Yes, that is all correct as far as I can tell thus can't be causing the error. the dot notion in the query..hould I do datasourcename.db.fieldname or something else? Cos someone was touching on that before..but I couldn't understand their post. and at the end it came up with this test successfull result : Microsoft SQL Server ODBC Driver Version 03.70.0623 Data Source Name: BP Data Source Description: Internet Billpay Staging box Server: ###. Database: TGV Language: (Default) Translate Character Data: Yes Log Long Running Queries: No Log Driver Statistics: No Use Integrated Security: No Use Regional Settings: Yes Prepared Statements Option: Drop temporary procedures on disconnect Use Failover Server: No Use ANSI Quoted Identifiers: Yes Use ANSI Null, Paddings and Warnings: Yes Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ODBC Error Code = S0002 (Base table not found)
Post your query.. - Original Message - Marius et al. Yes, that is all correct as far as I can tell thus can't be causing the error. the dot notion in the query..hould I do datasourcename.db.fieldname or something else? Cos someone was touching on that before..but I couldn't understand their post. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: ODBC Error Code=S0002(Base Table Not found)
This is a multi-part message in MIME format.
--=_NextPart_000_0158_01C01416.6FC80770
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
ODBC Error Code=S0002(Base Table Not found)If the "sort order" of the
database has been set to binary, or something other than "case-insensitive
dictionary sort", you will have to refer to the tables in the exact case as
specified in the SQL Server database. This looks like a case-sensitivity
problem.
DC
-Original Message-
From: John Crawford [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 01:06
To: [EMAIL PROTECTED]
Subject: ODBC Error Code=S0002(Base Table Not found)
Newbie Question.
NT 4.0 sp6 Running SQL 6.5 sp5
I have a datasource=cresthollow with one table=contacts
I get the following error
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = S0002 (Base table not found)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'Contacts'.
The error occurred while processing an element with a general identifier
of
(CFQUERY), occupying document position (7:1) to (7:49).
Here is the code, I have not implemented much error trapping yet. but this
does work on my local machine using access 2k. Thanks in advance for you
help.
HTML
HEAD
TITLEThanks/TITLE
/HEAD
BODY BGCOLOR="#ff" BACKGROUND="Graphics/background.jpg"
cfquery NAME="Contacts" DATASOURCE="cresthollow"
INSERT INTO contacts (firstname, lastname, address, city, state,
postalcode,
email,phone,
fax, notes, functions, othertext)
VALUES ('#Form.firstname#', '#Form.lastname#', '#Form.address#',
'#Form.city#',
'#Form.state#', '#Form.postalcode#', '#Form.email#', '#Form.phone#',
'#Form.fax#', '#Form.notes#', '#Form.functions#', '#Form.othertext#' )
/CFQUERY
cfmail FROM="#Form.email#"
TO="[EMAIL PROTECTED]"
SUBJECT="Automated Contact Form Submission"
Hi,
My name is #Form.firstname# #Form.Lastname# and I used your online contact
form to send you the following comments:
I would like information on the following:
#Form.functions#
cfif Form.notes is not ""
I have encluded the following comments:
#Form.notes#
/cfif
I can be reached at:
Address:BR
#Form.address#BR
#Form.City#, #Form.State# #Form.postalcode#
Phone: #Form.phone#
Fax: #Form.Fax#
Email: #Form.email#
/cfmail
Thanks
cfoutput
#Form.Firstname#
/cfoutput
HR
Your form has been successfully submitted. Someone will be in contact with
you shortly.
/BODY
/HTML
John R. Crawford
Dolphin NewMedia, Inc
[EMAIL PROTECTED]
Phone 717-728-5554
Fax 717-728-5566
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--=_NextPart_000_0158_01C01416.6FC80770
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEADTITLEODBC Error Code=3DS0002(Base Table Not found)/TITLE
META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type
META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR/HEAD
BODY
DIVFONT color=3D#ff face=3DArial size=3D2SPAN =
class=3D745361213-01092000If the=20
"sort order" of the database has been set to binary, or something other =
than=20
"case-insensitive dictionary sort", you will have to refer to the tables =
in the=20
exact case as specified in the SQL Server database.nbsp; This looks =
like a=20
case-sensitivity problem./SPAN/FONT/DIV
DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20
class=3D745361213-01092000/SPAN/FONTnbsp;/DIV
DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20
class=3D745361213-01092000DC/SPAN/FONT/DIV
BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px"
DIV align=3Dleft class=3DOutlookMessageHeader dir=3DltrFONT =
face=3DTahoma=20
size=3D2-Original Message-BRBFrom:/B John Crawford=20
[mailto:[EMAIL PROTECTED]]BRBSent:/B Friday, =
September 01,=20
2000 01:06BRBTo:/B [EMAIL PROTECTED]BRBSubject:/B =
ODBC=20
Error Code=3DS0002(Base Table Not found)BRBR/DIV/FONT
PFONT size=3D2Newbie Question./FONT BRFONT size=3D2NT 4.0 =
sp6 Running=20
SQL 6.5 sp5/FONT /P
PFONT size=3D2I have a datasource=3Dcresthollow with one =
table=3Dcontacts/FONT=20
BRFONT size=3D2I get the following error/FONT /P
PFONT size=3D2Error Occurred While Processing Request/FONT =
BRFONT=20
size=3D2Error Diagnostic Information/FONT BRFONT size=3D2ODBC =
Error Code =3D=20
S0002 (Base table not found)/FONT BRFONT =
size=3D2[Microsoft][ODBC SQL=20
Server Driver][SQL Server]Invalid object name/FONT BRFONT=20
size=3D2'Contacts'./FONT BRFONT size=3D2The error occurred =
while processing=20
an element with a
RE: ODBC Error Code=S0002(Base Table Not found)
I have a datasource=cresthollow with one table=contacts I get the following error Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Contacts'. Make sure you specified the name of the database (not just the name of the database server) in your ODBC settings in CF Administrator. If you leave the database field blank, it'll use the default database (usually the master database) which won't have your tables in it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: ODBC Error Code=S0002(Base Table Not found)
Thanks Dave, That did it. JC From: "Dave Watts" [EMAIL PROTECTED] Subject: RE: ODBC Error Code=S0002(Base Table Not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Contacts'. Make sure you specified the name of the database (not just the name of the database server) in your ODBC settings in CF Administrator. If you leave the database field blank, it'll use the default database (usually the master database) which won't have your tables in it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
