WikiAdmin: 1 revision imported

2023-07-14T12:58:48Z

1 revision imported

← Older revision

Revision as of 12:58, 14 July 2023

Chanson: /* Configure InterBase ODBC driver */

2021-03-08T16:35:59Z

Configure InterBase ODBC driver

New page

These instructions are for InterBase 2017. There are variations among the different InterBase versions on some of the steps below.
These instructions assume that the PC where you are configuring the ODBC driver is running a 64-bit version of Windows.

==Install InterBase client==

If you are configuring ODBC access on the same server as the Keystone database server, you can skip ahead to the [[#Install InterBase ODBC driver|next section.]]

#Run the 64-bit InterBase installer on the PC that needs ODBC access to the Keystone database. Be sure to use the same InterBase version that is installed on the Keystone database server.
#When you see the screen below, select the Client only option. [[File:IB client install.PNG|400px]]
#Click through remaining screens.

==Install InterBase ODBC driver==

#Run the ODBC IB installer on the PC that needs ODBC access to the Keystone database. Be sure to use the ODBC installer from the same InterBase version that is installed on the Keystone database server.
#Click through the screens.

==Configure InterBase ODBC driver==

Before proceeding, you need to know whether you need ODBC 32-bit or 64-bit access to Keystone. This information will have to be obtained from the customer's IT group.

# Start the appropriate Windows ODBC Administrator program (32 or 64 bits) 
#:In older versions of Windows it is difficult to select distinguish which version. You can explicitly start the correct version:
#::To configure a 32-bit InterBase ODBC driver: Press Windows+R and type: <code>C:\Windows\SysWow64\odbcad32.exe</code>
#::To configure a 64-bit InterBase ODBC driver: Press Windows+R and type: <code>C:\Windows\System32\odbcad32.exe</code>
#Click the System DSN tab and you will see this screen: [[File:ODBC Setup 1.PNG|400px]]
#Click the Add button and scroll down to InterBase ODBC driver and select it: [[File:ODBC Setup 2.PNG|400px]]
#Click the Finish button and you will see this screen: [[File:ODBC Setup 3.PNG|400px]]
#Fill in as follows:
#:Data Source Name (DSN): Keystone (or use the actual company name for the specific database)
#:Description: Keystone Database Access
#:Database: 192.168.x.x:D:\CCGH\DATA\CCW001.IB (use Keystone Database Server IP address, modify database path/name as appropriate)
#:Client:
#::C:\Program Files\Embarcadero\InterBase\bin\gds32.dll (for 32-bit ODBC connection)
#::-or-
#:: C:\Program Files\Embarcadero\InterBase\bin\ibclient64.dll (for 64-bit ODBC connection)
#:Database Account: CCWVIEW
#:Password: ccwview
#:Under Options-Transaction CHECK the read (default write) checkbox [[File:ODBC Setup 4.PNG|400px]]
#Click the Test connection button, you should see this: [[File:ODBC Setup 5.PNG|200px]]
#Click the OK button, three times to close the ODBC Administrator.

==Testing the ODBC connection to Keystone==

QueryGen can be used to test ODBC connections to Keystone. There are two versions on the Software drive under Keystone Software\QueryGen:
:QG32.EXE (32-bit version)
:QG64.EXE (64-bit version)

#Start the program
#Select ODBC in the DB Kind dropdown list.
#Click the Add button.
#In the box just under the Usr/Pwd boxes, you should see:
#:DriverID=ODBC
#:Datasource=
#Add the DSN name after the Datasource=:
#:Datasource=Keystone
#Click in the query box which should say SELECT * FROM.
#Enter this query:
#:SELECT * FROM ARTCUST [[File:QG Test 1.PNG|600px]]
#Click the Go button. You will be asked to Enter your credentials (User name/Password): [[File:QG Test 2.PNG|200px]]
#Enter the user name/password you setup in the ODBC administrator and click OK.
#You should see the query results. [[File:QG Test 3.PNG|600px]]

Configure InterBase ODBC Access - Revision history

WikiAdmin: 1 revision imported

Chanson: /* Configure InterBase ODBC driver */