Solved

AS400 to SQL Server via OLE DB

Posted on 2000-04-10
5
558 Views
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,

gordontm

0
Comment
Question by:gordontm
5 Comments
 
LVL 7

Expert Comment

by:twol
Comment Utility
Make sure your string looks like this:


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

Expert Comment

by:gpollock
Comment Utility
I had lots of problems which are now resolved - try these

point browser at http://www.as400.ibm.com/clientaccess/oledb/

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

0
 
LVL 3

Expert Comment

by:P_S_Price
Comment Utility
Gpollock - Greg of T&B is this you?

Pete of ESS
0
 

Accepted Solution

by:
gpollock earned 100 total points
Comment Utility
read my comment

cheers

greg
0
 
LVL 2

Author Comment

by:gordontm
Comment Utility
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.
Thanks,

                  AS/400 SDK for ActiveX and OLE DB Team

Question submitted via:

http://www.as400.ibm.com/clientaccess/oledb/comment.htm
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

HOW TO: Upload an ISO image to a VMware datastore for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere Host Client, and checking its MD5 checksum signature is correct.  It's a good idea to compare checksums, because many installat…
Veeam Backup & Replication has added a new integration – Veeam Backup for Microsoft Office 365.  In this blog, we will discuss how you can benefit from Office 365 email backup with the Veeam’s new product and try to shed some light on the needs and …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now