 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Services / DTS / July 2008IBMDA400 vs IBMDARLA vs IBMDASQL (as400 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 > We use DTS to import from iSeries using MSDASQL 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. > 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 > Wayne 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=9D=A6 =81 > Which particular database are you attempting to access? Well, Id 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 Id 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 Hi, 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 ? url:http://www.ureader.com/msg/1146956.aspx |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.