Re: Help with first connection to ODBC SQL datasource
On Sunday 20 Jul 2003 03:05 am, Terry Troxel wrote: > datasource="formsSQL" > dbtype="ODBC" > debug > dbserver="DEVELOPER"> > select * from cthru > > > which returned the following error: > ODBC Error Code = S0002 (Base table not found) > [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'cthru'. > > I know I am doing something stupid, but sure would appreciate some > pointers. That table doesn't exist. -- Tom C "Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms" ~| 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: Help with first connection to ODBC SQL datasource
I just tried this and I got a different error. Had to drop the dbserver name, then all worked well. Also, you do not need the dbtype attribute since you are not doing a QofQ. Presuming that the DSN you created is pointing to the correct server, and there is a table named cthru, this should work: select * from cthru Bruce Sorge From: "Terry Troxel" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: Help with first connection to ODBC SQL datasource Date: Sat, 19 Jul 2003 19:05:06 -0700 I just migrated/imports my first Access database to my new SQL2000 server named DEVELOPER. I added a datasource in CF Administrator called formsSQL. Checked off used trusted connection and the administrator said OK to the Verify. I went in and tried to do a simple cfquery which works in the Access original database: select * from cthru which returned the following error: ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'cthru'. I know I am doing something stupid, but sure would appreciate some pointers. Terry Troxel ~| 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
Help with first connection to ODBC SQL datasource
I just migrated/imports my first Access database to my new SQL2000 server named DEVELOPER. I added a datasource in CF Administrator called formsSQL. Checked off used trusted connection and the administrator said OK to the Verify. I went in and tried to do a simple cfquery which works in the Access original database: select * from cthru which returned the following error: ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'cthru'. I know I am doing something stupid, but sure would appreciate some pointers. Terry Troxel ~| 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
