Elsasoft Forums
Elsasoft Forums
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SqlSpec
 Other
 Connecting to DB2 AS400 Error
 New Topic  Reply to Topic
 Printer Friendly
Author  Topic Next Topic  

nizar
Starting Member

1 Posts

Posted - Oct 14 2018 :  9:56:58 PM  Show Profile  Reply with Quote
We are trying to connect to DB2 database using SqlSpec. Our database is DB2 iSeries. We are using the below connection string on SqlSpec GUI:

Provider=MSDASQL;DSN=name_of_DSN_connection;Data Source=server_IP;Product name=name_of_database;Uid=...;Pwd=...

We are getting the below error:

System.Data.Odbc.OdbcException
ERROR [42S02] [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0204 - SERVEROPTIONS in SYSCAT type *FILE not found.

Any ideas how to overcome that?
   Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Elsasoft Forums © Elsasoft LLC Go To Top Of Page
Snitz Forums 2000