community.borland.com

Article #25271: How to set up an ODBC alias with the Visigenic InterBase ODBC driver

Problem:
I dont know to set up an ODBC alias

Solution:
01)  Open Control Panel | ODBC Manager 32
02)  Click Add
03)  Select InterBase 4.x driver by Visigenic
04)  Determine if 'local' or 'remote' access is needed

(local)
L1)  Enter 'Data Source Name'
L2)  Enter 'Description'
L3)  Make sure 'Network Protocol' is set to 'local' the default
L4)  Provide the [drivepathdatabase] in the 'Database' field

          (eg.  d:interbaseexamplesemployee.gdb)

L5)  Enter the 'User Name'
L6)  Click OK
L7)  Highlight the newly created alias and click on 'Setup'
L8)  Enter 'Password' and press 'Test', it will prompt you that it will save it
L9)  Connect Successfully

(remote)
R1)  Enter 'Data Source Name'
R2)  Enter 'Description'
R3)  Make sure 'Network Protocol' is set to the protocol you want to use (ie. TCP)
R4)  Provide the [drivepathdatabase] in the 'Database' field

          (eg.  d:interbaseexamplesemployee.gdb)

R5)  Enter the server_name in the 'Server' field.
R5)  Enter the 'User Name'
R6)  Click OK
R7)  Highlight the newly created alias and click on 'Setup'
R8)  Enter 'Password' and press 'Test', it will prompt you that it will save it
R9)  Connect Successfully


Last Modified: 02-OCT-00