odbc dsn in pervasive sql
Moderators: chulett, rschirm, roy
odbc dsn in pervasive sql
Please give us information on how to create odbc dsn for pervasive sql in Datastage.
fgg
Re: odbc dsn in pervasive sql
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
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