Solved

AS400 to VB6 via ADO

Posted on 2000-05-03
2
471 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Access Remote iSeries IFS 6 338
Fill Field in Displayfile with variable name 7 114
adodb sql multi tables 1 1,239
IBM i Break Messages 1 25
Although a lot of people devote their energy toward marketing for specific industries, there are some basic principles that can be applied to any sector imaginable. We’ll look at four steps to take and examine how those steps were put into action fo…
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

749 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