Solved

AS400 to VB6 via ADO

Posted on 2000-05-03
2
475 Views
Last Modified: 2012-06-27
I use Visual Basic 6 and Client Acess Express V4R4.
When I try to create the Connection String for the ADO and I use the build button I choose the
IBM AS400 OLD DB Provider, and a Data Source then I click on the test connection button and its work.
But, when I click on the OK button
and return to the property page, the text box of the Connection String is
empty.
How should I write the Connection String
to use this provider?

Thank you.
Hezi
0
Comment
Question by:Hezi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 

Accepted Solution

by:
ulfie earned 100 total points
ID: 2789238
Public cnYourAS400 As New ADODB.Connection
Public ixYourAS400 As New AD400.Connection

cnYourAS400.Open "Provider=IBMDA400;Data Source=YourAS400;", "", ""
ixYourAS400.Open "BVRAS01", "", ""

This will make the connection to the AS/400.

If you want more information go to http://www.as400.ibm.com/clientaccess/oledb/.

This method works in either VB 5 or 6.

0
 

Expert Comment

by:ulfie
ID: 2789252
Note: Change BVRAS01 to your AS/400 name.
0

Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
Resolving an irritating Remote Desktop connection that stops your saved credentials from being used.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question