sql server dts: Folks

I am trying to setup an MS SQL server 2005 DTS package to import data
from an As400 DB2 server.

I have the choice between 3 different (managed ?) providers

IBM DB2 UDB for iSeries IBMDA400 OLE DB Provider
IBM DB2 UDB for iSeries IBMDARLA OLE DB Provider
IBM DB2 UDB for iSeries IBMDASQL OLE DB Provider

No idea which one to choose (not to mention that I have tried all 3
without success - the provider claims that the library I try to access
does not exists).

Any comment / pointer welcome !

Regards

alex

We use DTS to import from iSeries using MSDASQL

[quoted text, click to view]

Using SQL2005 ?

Hmmm....

What version of OS400 / Client Access ?

Thanks

alex

Using SQL 2003 and V5R3, but have used it unchanged since at least
V5R1.

Folks

Well, I am still having problems...

Actually it seems that for some reason I can't access the AS400 DB2
database using OLEDB providers, although "plain old" ODBC is
working fine...

I can connect to the server but none of the relevant databases show up
whereas the very same machine can extract data using ODBC...

Any idea ?

Also, those anyone know what are the differences between the IBMDA400,
IBMDARLA and IBMDASQL drivers ?!

Thanks & regards

--alexT

The difference between the IBMDARLA and the SQL version is that RLA gives
Record Level Access required for OLE/DB and the SQL version does not give
record level access.

Which particular database are you attempting to access? Are the relevant
server programs active?

It is a while since I have had to do any OLEDB setup. Please give some
more detail.


[quoted text, click to view]

Wayne

Many thanks for your message

[quoted text, click to view]

Ok, sounds =E2=80=9Creasonable=E2=80=9D=E2=80=A6 =EF=81=8A

[quoted text, click to view]

Well, I=E2=80=99d like to connect with a DB2/400 server and access some of
the database hosted on the AS400

[quoted text, click to view]

Quite frankly, no idea ! What should I check ?! All I can say is that
ODBC is working just fine. Is there anything else to run / configure to
have similar access with OLEDB ?

[quoted text, click to view]
more detail.

Well, it as as400 v5r3 with supposedly all the PTF. Client access is
also v5r3 (basically a fairly recent machine).

As mentioned earlier ODBC is working just fine. I seem to be able to
connect with the OLEDB connectors but I have only a very limited choice
of library available, and certainly none of the one I=E2=80=99d like to use.
One interesting point is that the afore mentioned list is dependant on
the user / password combination, which tends to point to a (possibly
basic) configuration problem.

All that being said I am pretty new to AS400 DB2 administration and I
might have overlooked something quite easily.

Any idea / suggestion welcome

Best regards


--alexT