• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 373
  • Last Modified:

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.
0
bhlang
Asked:
bhlang
  • 2
1 Solution
 
Éric MoreauSenior .Net ConsultantCommented:
Use the ODBC provider and choose your DSN. I didn't see yet a native OLE DB provider.
0
 
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.
0
 
bhlangAuthor Commented:
I just realized that the File was in the wrong location, moved it, tried again, and now everything works as it should.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now