Forum Discussion

jongee's avatar
jongee
Frequent Visitor
10 years ago

ODBC: ERROR [42S22] [Sybase][ODBC Driver][SQL Anywhere]Column 'object_id' not found

Hi

 

When I try and create a connection to my datasource I get the following error

 

ODBC: ERROR [42S22] [Sybase][ODBC Driver][SQL Anywhere]Column 'object_id' not found

 

 

What is strange is if I enter the SQL Query when creating the connection all works fine. Am I doing something wrong?

Need Help

1 Reply

  • arify's avatar
    arify
    Microsoft Employee
    10 years ago

    Hi,

     

    Does the column 'object_id' exist in the table you're accessing to? Or, is it a foreign key?

     

    Can you please send us a frown attaching trace files? (Options > Diagnostics > Enable tracing)

     

    Thanks!