Process Number: 90

Revision Date: 11/5/2001 2:43:00 PM
Revision #: 2
Back | Access Password:
 

ODBC & DSN Setup for Datatel Connection

Office Responsible: DCS - District - Computing Services Process Type: internal
Position Title: Enterprise Network Spec Author: LMascarenhas
Cross Trained Staff: TCollins Manager: DHarris Vice Pres.:

Timeline (Deadlines or Time-Constraints) :
As Needed Only
What must be done before this process is started:
Which processes are waiting for this process:
Source documents or communication with information needed for this process:
What is the end-result of this process, or the hand-off
What steps must be taken independent of the computer system (Manual Process)
Which steps must be taken on a computer (Electronic Process):
ODBC & DSN Setup for Datatel Connection

1. Run the setup.exe programs in each of the three folders found on Alderaan\Source on Alderaan\Ardent.

Network ODBC\setup.exe
ODBC\setup.exe
Visual Schema Generator\setup.exe

2. Fill in the SQLEDIT32 screen so that is looks exactly like the one below.

Start
Programs
UniDesktop Utilities
SQLEDIT32
Fill in Information
Press (Add Services)
Press (Ping), you should get a message indicating a successful ping.

3. Create a System DSN.

Start
Settings
Control Panel
Administrative Tools
Data Sources ODBC
Drivers – If you successfully completed step 1 you should see a driver named “UniDesktop/ODBC 32-bit Driver”. If not repeat step 1, if so go to System DSN tab.
System DSN – Choose Add and fill in with info below. Enter your Unix User name.
Related Documents to Process (e.g. Datatel documentation, Government code books, etc.)
Notes (Cautions, suggestions for improvement, etc.)

Process Number: 90

Revision Date: 11/5/2001 2:43:00 PM
Revision #: 2
Back | Access Password:

 
© 2013 San Bernardino Community College District - All Rights Reserved