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
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
