07-11-2007 06:14 AM
Solved! Go to Solution.
07-11-2007 10:22 PM
First, you'll first need to setup an IMAGE/SQL DBE; then you can use ODBC to access it.
In the ITRC Technical Knowledge base, there is a good document for that. The document ID is KBRC00006588 (Setting up an IMAGE/SQL DBE and installing ODBCLINK on MPE/iX 6.0 or Higher).
Here's an integral copy of the document:
How to set up an IMAGE/SQL DBE and access it from a PC.
1. Set up ODBCLINK server
Do a :SHOWJOB and confirm that your job limit is set so that at least
one more job can log on. Change the limit if necessary.
The ODBCLink job needs to run in the CQ. Do a :JOBPRI to check if the
MAXIMUM JOB PRI = CS. If not, type:
If necessary, do a JOBPRI DS or ES.
Use :SHOWJOB to confirm the job ODBCLNSE,MANAGER.SYS is running.
You may want to put the jobpri & stream steps into a UDC/command file, your backup jobs and your SYSSTART file.
2. Create an IMAGE/SQL DBE
This section assumes that this is a new installation of an IMAGE/SQL database connection. You may already have performed some or all of these steps.
The purpose of these steps is to create an Allbase DBE and attach a TurboImage database to it. Your ODBC applications will 'talk' to the Allbase DBE, which will translate the SQL commands into Image Intrinsics.
Log on as the creator of your TurboImage database and perform the following steps, where 'imagedb' is the name of your Turboimage database, and 'newdbe' is the name of the Allbase DBE you wish to create:
>> set turbodb imagedb
>> set sqldbe newdbe
DBE does not exist, do you want to create one? [Y/N} : Y
Creating DBE now ...
>> update user user.account to mode = 1 << this is your current logon
<< not required if the DBE is
<< is to be READ ONLY
DBEnvironment Name: newdbe
AutoStart mode (on/off) (opt):
User Mode (single/multi) (opt):
DDL Enabled (y/n) (opt):
No. of Runtime Control Block Pages (opt):
No. of Data Buffer Pages (opt):
Data Buffer Pages Memory Resident (y/n) (opt):
No. of Log Buffer Pages (opt):
Max. Transactions (opt): 50
Maximum Timeout (opt): 300
Default Timeout (opt): 300
Authorize Once per Session (on/off) (opt):
Alter DBEnvironment Startup Parameters (y/n)? y
DBEnvironment startup parameters altered.
3. Set up client - TCP/IP
Your network software must be able to connect to the HP3000. Test this by 'pinging' your HP3000 server using it's IP address.
C:\> ping 12.345.678.900
You may need to exit windows to run PING. If PING tells you it cannot find the IP address, contact your site network administrator for advice.
If you do not know the IP address of your HP3000, use the MPE command 'NETCONTROL' as below to find it.
4. Set up client - ODBCLINK/SE
Create a new directory called ODBCLINK. At the DOS prompt:
C:\> MKDIR ODBCLINK
C:\> CD ODBCLINK
Download the file ODBCCL32.ODBCSE.SYS from your HP3000 server into this directory as ODBCCL32.ZIP. The method for doing this depends on your networking software. The file must be transferred in binary format.
Use WINZIP to unzip ODBCCL32 and install the ODBCLINK client.
To set up your data sources, select Data Sources (ODBC) from your Control Panel. At the 'ODBC Data Source Administrator' window select Add. At the 'Create New Data Source' window choose ODBCLink/SE-32 Driver (or
ODBCLink/SE-32 ODBC3 for level 3 compliant ODBC) & click Finish. At the 'ODBCLink/SE Setup' window enter data as follows:
Data Source Name: The name you will be calling your database
Description: A description of your choice
DataBase Name: The fully qualified filename of the DBE on the server
Server Name: The IP address of your HP3000
Click on the MPE/iX radio button & Continue
Enter your logon details in the next screen & Continue.
In the 'Setup Options' screen, click OK
In the 'Select Translator' screen, click OK
Back at the 'Data Sources' screen, click Close, and then OK to exit
You should now be able to connect to your Image/SQL database.