Configure InterBase ODBC Access

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 next section.

1. 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.
2. When you see the screen below, select the Client only option.
   Error creating thumbnail: /bin/bash: /usr/bin/convert: No such file or directory Error code: 127
3. Click through remaining screens.

Install InterBase ODBC driver

1. 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.
2. 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.

1. 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: C:\Windows\SysWow64\odbcad32.exe

   To configure a 64-bit InterBase ODBC driver: Press Windows+R and type: C:\Windows\System32\odbcad32.exe

2. Click the System DSN tab and you will see this screen:
   Error creating thumbnail: /bin/bash: /usr/bin/convert: No such file or directory Error code: 127
3. Click the Add button and scroll down to InterBase ODBC driver and select it:
   Error creating thumbnail: /bin/bash: /usr/bin/convert: No such file or directory Error code: 127
4. Click the Finish button and you will see this screen:
   Error creating thumbnail: /bin/bash: /usr/bin/convert: No such file or directory Error code: 127
5. 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
   Error creating thumbnail: /bin/bash: /usr/bin/convert: No such file or directory Error code: 127

6. Click the Test connection button, you should see this:
   Error creating thumbnail: /bin/bash: /usr/bin/convert: No such file or directory Error code: 127
7. 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)

1. Start the program
2. Select ODBC in the DB Kind dropdown list.
3. Click the Add button.
4. In the box just under the Usr/Pwd boxes, you should see:

   DriverID=ODBC

   Datasource=

5. Add the DSN name after the Datasource=:

   Datasource=Keystone

6. Click in the query box which should say SELECT * FROM.
7. Enter this query:

   SELECT * FROM ARTCUST
   Error creating thumbnail: /bin/bash: /usr/bin/convert: No such file or directory Error code: 127

8. Click the Go button. You will be asked to Enter your credentials (User name/Password):
   Error creating thumbnail: /bin/bash: /usr/bin/convert: No such file or directory Error code: 127
9. Enter the user name/password you setup in the ODBC administrator and click OK.
10. You should see the query results.
    Error creating thumbnail: /bin/bash: /usr/bin/convert: No such file or directory Error code: 127