odbc--call failed

A farming just contact programming, just apply for the blog park, only for the record.

Just contact VB, in the introductory to proficient see an instance Open Show ODBC call failed, at a loss always dragged

Until today finally solved.

When you open an instance

This afternoon to check the problem and the example 2 finished, found that it is not my installed access problem, but the Access data source drive is 32-bit, 64-bit does not support, as long as the 32-bit version of the ODBC Management tool is open, the following are my problems and solutions:

64-bit Windows7 operating system ODBC cannot add a modification configuration, only SQL Server is optional when adding a data source. As

The workaround is to:

The 32-bit version of the ODBC management tool can be resolved by C:/windows/syswow64/odbcad32.exe, with the following effects:

Click Add Data Source Name: for example ODBCDB_KFGL

The database selects the path where the data table resides. Ok

Through this matter, I know, do nothing to push back, to timely resolve, if you go backwards, after a while you may forget, you have to try to solve, so later encounter such problems will be good to solve. will also be impressed.

Mutual encouragement of

odbc--call failed