Data Direct ODBC configuration
Here is my server configuration:
Windows 2008 Server
SAP BODS 4.2 SP1
SQL Server 2012 (CMS & Rep)
Oracle 11g (Source & target)
We are trying to connect Oracle with Data Direct Drive as Oracle client not installed on server.
1. I have created DSN using Data Direct ODBC on server both User and Server DSN using ODBS admin.
2. I am able to connect using designer & browse table.
3. But when I execute job using job server it failed with following error.
4. Then created a file odbc.ini inside dataservices/bin folder with oracle server details and DataDirect lib path.
5. Still getting same error,
Could you please help me with the issue?