ODBC connection problem

H

Harley Feldman

When I try to link to a 4D database from Access 2003 via System ODBC, I can get all of the tables shown in a list box to connect to one or all. If I select one of the tables to link to, I get the following message: "Invalid arguments.".

If instead I try to do an import to the same database via ODBC, I get the following message:

ODBC--call failed.

[Simba][Simba ODBC Driver][Codebase File Library] (#-10021) [Microsoft][ODBC Driver Manager] Driver's SQLSetConnect Attr failed IM006 0 [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (#0)

The irony is that I use the same ODBC connector to the same database with Excel. I have no trouble retrieving records from the database into Excel.

What is it about Access that makes this connection not work?

Harley
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
sqlite-odbc write conflict 2
ODBC - Connecting MS Access to Oracle 10g 0
ODBC--call failed. 2
Problem connecting Access to Oracle 0
Access2010 redistribuible + runtime e ODBC issue 2
ODBC Connection with Windows 7 2
Oracle ODBC Connection Problem 1

Top