AS400 to SQL Server via OLE DB

Posted on 2000-04-10
Last Modified: 2008-02-20
I am using Windows NT 4.0 running Microsoft SQL Server 7.0
I am using IBM AS400

I create a new DTS Package and create connections for Microsoft SQL Server 7.0 and the IBM AS400 using
(1)  Microsoft OLE DB Provider for SQL Server and
(2)  IBM AS400 OLE DB Provider

The OLE DB Provider for SQL Server connection works fine

I have problems with the AS400 connection though.  Even though I am already logged on in "AS/400 connections" and I specify the same password and username that I used there I can not seem to get a connection (plus server name of AS400640)

Can anyone help please?

Thank you,


Question by:gordontm
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

Expert Comment

ID: 2747955
Make sure your string looks like this:

"Provider=sqloledb;SERVER=" _
& sServerName & ";DATABASE=" _
& DBName  ";" & "UID=" & sUserID _
& ";PWD=" & sPwd

Expert Comment

ID: 2772903
I had lots of problems which are now resolved - try these

point browser at

for lots of information.

the IBM AS400 oledb driver is very fussy - all explained at above site.

Also make sure you have the latest Client Access patches. This was my problem.

Connection string looks like -
objADOConnection.Open "Provider=IBMDA400;Data Source=LIVE;", "", ""

hope this helps


Expert Comment

ID: 2788095
Gpollock - Greg of T&B is this you?

Pete of ESS

Accepted Solution

gpollock earned 100 total points
ID: 2796476
read my comment



Author Comment

ID: 2869442
Official response from IBM:

At this time, the Client Access OLE DB provider is not supported with SQL
Server 7.0.  It is test at this time, and may be supported in the future.

                  AS/400 SDK for ActiveX and OLE DB Team

Question submitted via:

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

The conference as a whole was very interesting, although if one has to make a choice between this one and some others, you may want to check out the others.  This conference is aimed mainly at government agencies.  So it addresses the various compli…
Today’s effective marketing is about coming down to the customers’ level and engaging in a whole new way. A text message is one of the most effective and influential ways that you can engage your customers. Here are eight ways that you can utilize t…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
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: …

691 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