"VBA Study" ORA-06413: Connection not open error

Iamlaosong

I do Excel tools, connect Oracle database query data, usually can run very well, both XP and Win7 can. Later encountered a Win7 (64-bit) system, found unable to connect to the database, reported " connection is not open" error .

error Description: Sqlplus can be connected with Oracle's tool, but the macro in Excel is "ORA-06413: Connection not open" Error . such as:

Click Debug, the Error statement is:

Cnn. Open "Provider=msdaora;data source=dl580; User ID=EMSSXJK; PASSWORD=EMSSXJK; "

obviously not a statement problem, on-line check, the judge may be the directory in which the program is located in parentheses, the inspection found that the installation directory of Office software is indeed under Programs file (x86), unloading load, found still installed in that directory, although the selection of the path is not ( x86). The path (x86) is removed directly, and the system automatically re-installs a band (x86) at runtime .

I think is not the 32-bit software installed after the addition of a (x86), the experiment found not so, as long as the installation directory is not program file, enter what directory is what directory. Uninstall Office again, reinstall without the program file directory, change to office directory, problem resolution.

"VBA Study" ORA-06413: Connection not open error