Document Type | Technical Information
Category | Interface/Integration
Applicable Product Versions | 6FS01, 6FS02, 6FS03, 6FS04, 6FS05, 6FS06, 6FS07, 6FS07PS, 7FS01, 7FS02, 7FS02PS
Document Number | TIITI010
Overview
There is a difference in the OLE DB integration method because the availability of tbprov and msdtb files in the Tibero client varies between versions before and after Tibero7.
This document guides the appropriate OLE DB integration method according to the Tibero version.
Method
Tibero6 and below
1. Register ODBC Driver
tbodbc_driver_installer_6_32.exe -i <driver path>
2. ODBC Connection
DRIVER={Tibero 6 ODBC Driver};SERVER=localhost;PORT=8629;DB=tibero;UID=TIBERO;pwd=tibero;3. Verify DSN Connection
4. Register Tibero OLE Provider
4.1. regsvr32 tbprov.dll
4.2. regsvr32 msdtb.dll
4.3. Create tibero.udl file
4.4. Execute Provider=tbprov.Tbprov.6:Data Source=t6;User ID=tibero;Password=tmax;Updatable Cursor=True;
Tibero7 and above
1. Verify that ODBC connects properly (same as Tibero 6 version)
2. Change provider to MSDASQL OLE provider and verify connection
If the application and integration program were using the existing Tibero OLE provider, modify the provider name.
"[Provider=MSDASQL;] { DSN=name | FileDSN=filename } ; [DATABASE=database;] UID=user; PWD=<password>"