odbc dsn in pervasive sql
Posted: Tue Aug 29, 2006 12:31 pm
Please give us information on how to create odbc dsn for pervasive sql in Datastage.
Hi,
If you want to access an ODBC database from DataStage follow the steps below,
1. install ODBC drivers for the ODBC data source on the DataStage server (MUST).Note: Do not use trial versions of ODBC drivers.
2. Add the path of the directory containing the driver DLL to the Path
system environment variable.
3. Configure the ODBC data source as a System Data Source, not a
User Data Source.
Otherwise DataStage cannot connect ODBC data source.
Good Luck !
-NB