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 !
Using SQL2005 ?
What version of OS400 / Client Access ?
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
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
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
"AlexT" <goo...@atc.ch> wrote in message
Many thanks for your message
> 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.
Ok, sounds “reasonable”…
> Which particular database are you attempting to access?
Well, I’d like to connect with a DB2/400 server and access some of
the database hosted on the AS400
> Are the relevant server programs active?
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 ?
> It is a while since I have had to do any OLEDB setup. Please give some 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’d 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
Is this problem resolved now ? could you please let me know the solution.
I am new to SSIS in SQL 2005; and want to write from SQL to AS400. I am able
to do the task in SQL 2000 but not through 2005 SSIS.
Any suggestions please ?