pb12.5.2 Direct Connect oracle10g

Recently re-installed Windows7 64-bit, and installed the oracle10g64 bit, found that PB even Oracle frequent error. The last night was settled. The development environment, in addition to the database service, installs 32-bit Oracle clients, because PB is 32-bit.

Add a system-level environment variable:

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

The client is installed by default, and the first one in path is D:\oracle\product\10.2.0\client_1\bin;

If PB is still unable to connect, delete the monitor re-create, restart the computer to see.

There are 2 ways to connect directly:

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 one: Direct Connect

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, on the user's machine without the installation of Oracle client, directly to the instantclient-basic-win32-10.2.0.5 decompression, the inside of the DLL files copied to the program directory can be directly executed. If you do not copy these DLL files in the past, you may see a hint that the local nls_lang could not be found.

Note the difference between the development environment and the production client.

pb12.5.2 Direct Connect oracle10g