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).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 cant 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. Ibmda400 Ole Db Provider Drivers Thanks RegardsAny 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 OLEDB 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. Post by AlexT Folks Well, I am still having problems. Ok, sounds reasonable Post by Wayne Moore Which particular database are you attempting to access Well, Id like to connect with a DB2400 server and access some of the database hosted on the AS400 Post by Wayne Moore 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 Post by Wayne Moore It is a while since I have had to do any OLEDB setup. Client access is also v5r3 (basically a fairly recent machine). 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. 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 comment pointer welcome Regards alex Just in case someone might be still following this thread, we had the old OLEDB IBM DB2 drivers, and they brought DB2 CHARACTER type data to SSIS as NVARCHAR(x). The new IBMDASQL, IBMDARLA, and IBMDA400 bring it over as varchar. Any idea if there are settings on the driver that will allow you to change that behavior Otherwise I am going to have to do SSIS Data conversion transformations for over 200 tables, and 1800 columns manually.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |