Connection String for AS/400 Database

I am trying to connect to an AS/400 Database with VB6 and ADO and OLE DB. I think that all I need to be successful is a good connection string. I am trying to set up a Connection in a Data Environment, and the ConnectionSource property of the DEConnection object seems to be my problem.

My server name is Server1, the Library on the AS/400 is CO88, and the Database is JCLABAS. I can open this database via VISDATA and Lotus Approach, so I know this can be done. I just don't know what connection string to use to get the data in VB6.
Who is Participating?
Éric MoreauConnect With a Mentor Senior .Net ConsultantCommented:
Use the ODBC provider and choose your DSN. I didn't see yet a native OLE DB provider.
bhlangAuthor Commented:
In the Data Link properties of my DEConnection, on the Provider Tab, I have the choice of the following OLE DB providers:

IBM AS400 OLE DB Provider
Microsoft Jet 3.51 OLE DB Provider
Microsoft OLE DB Provider for ODBC Drivers (currently selected)

On the Connection Tab, I have selected the Data Source Name which I defined in ODBC (JCLABAS).

When I do this, I get an error:
[IBM][Client Access ODBC Driver (32-bit)][DB2/400 SQL]SQL0204 - JCLABAS in CO88 type *FILE not found. Anyone know a solution to this error.
bhlangAuthor Commented:
I just realized that the File was in the wrong location, moved it, tried again, and now everything works as it should.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.