I recently got this error when I failed to change the default database
during the ODBC setup. If you do the ODBC setup from the control panel,
and within the setup wizard you fail to notice this step, then you're
likely pointing your ODBC datasource at the 'master' database. I
believe the wizard presents a drop-down box that shows all of the
databases on the server.
Jim
-----Original Message-----
From: avex <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Date: Sunday, September 24, 2000 7:48 PM
Subject: access to SQL server woes
>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.
