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:
<cfquery name="getdata" datasource="formsSQL">
select * from cthru
</cfquery>
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:
<cfquery name="getdata"
datasource="formsSQL"
dbtype="ODBC"
debug
dbserver="DEVELOPER">
select * from cthru
</cfquery>
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
