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