Troubleshooting
Problem
Data source name not found and no default driver specified
Diagnosing The Problem
Try logging on to the SQL Server database from the server machine.
For Unix/Linux platforms, it is possible to access the SQL Server database from the server, however SQL Server database is a Windows application and must be running on a Windows machine.
Resolving The Problem
If you can access the SQL Server database, perform the following:
- Add the DSN to the [ODBC] section in the .odbc.ini file
- Try using the ipaddress of the machine for the Address in the .odbc.ini file,
e.g., Address=ipaddress,port
[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"8.5;8.1;8.0.1;7.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21395254