Can you execute the query from Query Analyzer?
At 04:48 PM 1/19/2004, you wrote:
>Howdy,
>
>Using: CF5 on Win XP Pro, SQL Server 2000
>
>I need to connect to a SQL Server 2000 datasource on my local dev box
>but am having problems executing the CF code. In the CF Administrator,
>the datasource verifies correctly and I can view database tables using
>Enterprise Manager.
>
>Here are my datasource config settings:
>
>- Using Windows NT authentication
>- the checkbox to Connect to SQL Server to obtain default settings for
>the additional configuration options is checked (and the LoginID and
>Password boxes grayed out)
>- all other settings are defaults
>
>After setting this up in the ODBC Admin Manager, the connection tests
>ok.
>
>When I try to run a CF page that hits the datasource, I get an error:
>
>"ODBC Error Code = S0002 (Base table not found)
>
>[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
>'Settings'.
>
>SQL = "SELECT * FROM Settings""
>
>All this is supposed to do at this point is read the Settings table
>(in the CFWebstore store application) and return the values. For some
>reason it doesn't appear to be seeing the Settings table.
>
>Any ideas on where to go from here would be greatly appreciated.
>Thanks.
>
>--
>Chris Montgomery
>Airtight Web Services <http://www.airtightweb.com>http://www.airtightweb.com
>Web Development, Web Project Management, Software Sales
>210-490-2415
>
>----------
>[
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
