hi
ive installed 5.1 on a solaris box ,set up my .profile,dsenv,.odbc.ini,uvodbc.config and yet when trying to import table definitions i get this error DSR.MetaGeta(GET.TABLES)(SQLConnect('MedClearODBC','dsadm')): BCI Error:
SQLSTATE=IM002,CODE=0,[DataStage][SQL Client][ODBC][MERANT][ODBC lib] Data source name not found and no default driver specified
what could be the problem
unix connection error
Moderators: chulett, rschirm, roy
If you have not defined ODBC connections in the uvodbc.config and .odbc.ini files then you should search this forum for either of those two words and you will find your answer.
Regards,
Michael Hester
Regards,
Michael Hester
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com
there was a previous installation that worked but was later deleted i restored the backups of the .odbc.ini ,n other files n they are exactly the same only diff is that we using solaris 2.9 (does DS 5.2 work on solaris 2.9)
,and where would i be able to get a 32 driver for informix the current 1 in using is VMinf18.so
,and where would i be able to get a 32 driver for informix the current 1 in using is VMinf18.so
-
- Participant
- Posts: 24
- Joined: Wed Apr 02, 2003 7:09 am
- Location: United Kingdom
On Solaris platform there is a master uvodbc.config file in the datastage home directory and there are also project level copies in each project directory.
Make sure the correct uvodbc.config is gettign picked up.
Also double check that the dirver specified really does exist and is readable.
Paul Preston
Make sure the correct uvodbc.config is gettign picked up.
Also double check that the dirver specified really does exist and is readable.
Paul Preston
The uvodbc.config file in the home directory is the master. If you have values in the project level uvodbc.config files then these will override what is in the home dir. This allows you to make project level DSN's available.Make sure the correct uvodbc.config is gettign picked up.
Regards,
Michael Hester
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com
Straight from the Ascential website.does DS 5.2 work on solaris 2.9
DataStage XE for Solaris
Release OS Release
7.0 Solaris 2.7 & 2.8 & 2.9
6.0.1 Solaris 2.7 & 2.8
6.0r3 Solaris 2.7 & 2.8
6.0r1 Solaris 2.7 & 2.8
6.0 Solaris 2.7 & 2.8
5.2.2r1 Solaris 2.7 & 2.8
5.2.2 Solaris 2.7 & 2.8
5.2.1 Solaris 2.7 & 2.8
5.2r7 Solaris 2.7 & 2.8
5.2r2 Solaris 2.7 & 2.8
5.2r1 Solaris 2.7 & 2.8
4.2.1r8 Solaris 2.6 & 2.7
Hope this helps
Michael Hester
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com