?
Solved

AS400 to SQL Server via OLE DB

Posted on 2000-04-10
5
Medium Priority
?
568 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
[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
5 Comments
 
LVL 7

Expert Comment

by:twol
ID: 2747955
Make sure your string looks like this:


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

Expert Comment

by:gpollock
ID: 2772903
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
ID: 2788095
Gpollock - Greg of T&B is this you?

Pete of ESS
0
 

Accepted Solution

by:
gpollock earned 400 total points
ID: 2796476
read my comment

cheers

greg
0
 
LVL 2

Author Comment

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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Introducing Priority Question, our latest feature.
The Summer 2017 Scholarship Winners have been announced!
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses

752 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