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
Web Development, Web Project Management, Software Sales
210-490-2415
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
