VENDORERRORCODE 208 in CFMX 7

[ryoh]

Hi all,

I recently migrated an application from CF5 to CFMX7 and a few pages in the
application are giving me a SQL error. The error message says:


================================================== ==============================

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server
Driver][SQL Server]Invalid object name 'ProgramCodes'.

The error occurred in
D:\PPM_Website\pirs\shopp\admin\edit_pgm_advisor_l ist.cfm: line 5

3 : UPDATE ProgramCodes
4 : SET Advisor='#rtrim(ucase(Advisor))#',
Assistant='#rtrim(ucase(Assistant))#'
5 : WHERE (ProgramCodes.ProgCode='#FORM.ProgCode#')
6 : </cfquery>
7 :




--------------------------------------------------------------------------------

SQL UPDATE ProgramCodes SET Advisor='DJF', Assistant='LTN' WHERE
(ProgramCodes.ProgCode='201.010')
DATASOURCE tenyrshopp
VENDORERRORCODE 208
SQLSTATE 42S02

================================================== =============================

The SQL statement looks fine. I really don't know what the problem is. Has
anyone encountered simiilar database problem when migrating from CF5 to CFMX7?

Thank you very much in advance.

Roger

[ryoh]

Nevermind. I got it to work by using MS SQL driver instead of using ODBC Socket.