There are a couple of test functions in the ODBC driver directory for the Intersolv drivers, one which tests that the driver manager is correctly installed (your error message suggests that it is), the other that a particular driver can be loaded. There's also an extra step where you have to rebuild for Oracle (again, there are readme files and all necessary tools for doing this).
That's all dredged from ancient memory, but you should be able to track it down on your system. I suspect it's running the rebuild script for the Oracle driver that you need to do.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
datastage validation problem
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There are actually two files that need to be correct in order for your ODBC connection to work. These two files are listed below -
(depending on your version of DS)
.odbc.ini in Ascential/DataStage/DSEngine
and
uvodbc.config in Ascential/DataStage/DSEngine
or
uvodbc.config in each of the project directories.
The difference between the two uvodbc.config files is that the file under each project directory overrides the uvodbc.config in the engine. (this makes it so that you could have a different connection in each project)
The layout of the odbc.ini should be -
[ORACLE] ;* THIS IS THE "DSN"
Driver=/datastage/Ascential/DataStage/DSEngine/../branded_odbc/lib/VMor818.so
Description=DataDirect Oracle
ServerName={your server name}
Your uvodbc.config should look like -
<ORACLE> ;* SAME NAME AS WHAT IS IDENTIFIED IN YOUR .odbc.ini file
DBMSTYPE = ODBC ;* NOTE THE SPACES BEFORE AND AFTER THE "="
That's it.
Let me know if this works.
Regards,
Michael Hester
(depending on your version of DS)
.odbc.ini in Ascential/DataStage/DSEngine
and
uvodbc.config in Ascential/DataStage/DSEngine
or
uvodbc.config in each of the project directories.
The difference between the two uvodbc.config files is that the file under each project directory overrides the uvodbc.config in the engine. (this makes it so that you could have a different connection in each project)
The layout of the odbc.ini should be -
[ORACLE] ;* THIS IS THE "DSN"
Driver=/datastage/Ascential/DataStage/DSEngine/../branded_odbc/lib/VMor818.so
Description=DataDirect Oracle
ServerName={your server name}
Your uvodbc.config should look like -
<ORACLE> ;* SAME NAME AS WHAT IS IDENTIFIED IN YOUR .odbc.ini file
DBMSTYPE = ODBC ;* NOTE THE SPACES BEFORE AND AFTER THE "="
That's it.
Let me know if this works.
Regards,
Michael Hester
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: