hi everyone.....
sorry if this is kid stuff......but i finally decided to make the jump from
access to SQL server on one of the applications i have done.....
I used the import wizard in the SQL enterprise manager...and from the look
of it it imported all the tables and content correctly...
I set up the sql datasource in the cold fusion administrator...
changed my datasource name to point to the new datasource...
and at this stage i thought it was suprisingly easy....
and then i ran my templates and i got errors....
from this query:
<cfquery name="lastupdate" datasource="#datasource#" dbtype="ODBC">
SELECT *
FROM lastupdatetable
</cfquery>
I got this error:
ODBC Error Code = S0002 (Base table not found)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'lastupdate'.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (4:1) to (4:105) in the template file
D:\INETPUB\WWWROOT\CITY\DATABASE\REVIEW.CFM
Is there something else I need to do......
is it obvious what i am doing wrong......
any help is greatly appreciated.......
thanks
chad
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
