Originally posted by: kishorekv

Hi..

I am getting an error when connecting to AS400 database from Database Interface Designer.

Below are the steps I followed to connect..

1. Installed i Series 7.1 in my machine

2. Created a ODBC System DSN using i Series Driver.

3. Using that DSN, Created a Database in Database Interface Designer, With Adapter Type - ODBC and Platform - Microsoft Windows.

I am getting this error -- 

<5092-4944>:    Datasource : 
<5092-4944>:    UserID     : 
<5092-4944>:    Password   : *****
<5092-4944>:    Context: Output Card, Transaction scope: 
<5092-4944>:    On Failure: Commit, On Success: 
<5092-4944>:    No existing connection was found.
<5092-4944>:    Error in SQLConnect

Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

SQL State: IM002
<5092-4944>:    SQLConnect failed.

Originally posted by: kishorekv

The connection is working when I create User DSN instead on System DSN. Not sure why though...
 

Originally posted by: paul.brett

That is odd, and should you require further investigation on that, I recommend you open a Service Request (PMR) with IBM Support.

Thank-you.

Paul

Follow me on Twitter