Pb12.5.2 directly connected oracle10g

Recently reinstalled windows7 64 bit, and installed oracle 10g64 bit, found pb even oracle frequent errors. After staying up all night, it was finally resolved. Development environment, in addition to database services, but also to install 32-bit oracle client, because pb is 32-bit.

Add a system-level environment variable:

TNS_ADMIN D:\oracle\product\10.2.0\client_1\NETWORK\ADMIN

After installing the client by default, the first one in the path is D:\oracle\product\10.2.0\client_1\bin;

If pb still can't connect, delete the monitor and recreate it, restart the computer and have a look.

There are two ways of direct connection:

First: OLE connection mode

SQLCA.DBMS = "OLE DB"

SQLCA.LogPass = "si"

SQLCA.LogId = "si"

SQLCA.AutoCommit = False

SQLCA.DBParm = "PROVIDER='OraOLEDB.Oracle',DATASOURCE='127.0.0.1:1521/orcl'"

Second: direct connection

// Profile instance

SQLCA.DBMS = "O10 Oracle10g (10.1.0)"

SQLCA.LogPass = "service"

SQLCA.ServerName = "172.10.10.2:1521/orcl"

SQLCA.LogId = "service"

SQLCA.AutoCommit = False

SQLCA.DBParm = "PBCatalogOwner='service'"

After the release of the program, in the user machine without installing oracle client, directly instantclient-basic-win32-10.2.0.5 decompression, the dll file inside copy to the program directory can be directly executed. If you don't copy these dll files, you might get a message saying you can't find the local nls_lang.

Note the difference between development environment and production client.