Linked table (SQL View)

[kashifzafar01]

Dear All

I am unable to run queries with SQL linked table, as soon as I convert it to Local table, everything works.

Error, I got is "ODBC call failed"

Any ideas?

 

[theDBguy]

Hi. Welcome to AWF!

Are you trying to create a pass-through query?

 

[Ranman256]

do You have the odbc,connection working?

 

[sonic8]

Error, I got is "ODBC call failed"

Check the DBEngine.Errors collection. It migh contain an additional, more meaningful error message.

 

[Ranman256]

Fix the odbc connection, then it should work.

 

[Pat Hartman]

Can you open the linked table and view it directly?