Solved

AS400 to SQL Server via OLE DB

Posted on 2000-04-10
5
561 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
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 100 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
AS/400 Printout WTR status 2 475
AS/400 Backup to Disk 7 414
iSeries Bath SFTP CL Program Problem 6 452
AS400 Logging Print device 2 78
This article outlines the process to identify and resolve account lockout in an Active Directory environment.
As a business owner, there are many things that keep you up at night. Profit margins, employee retention, human resource protocols, whether your product or service will remain competitive. When you own or manage a technology company that operates la…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

777 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