Hello, I have to connect Testcomplete project with Db2/AS400 database using JDBC request. It requires a driver so I copied the jt400 jar in the 'bin' folder of TestComplete. I'm using the following to establish the connection between the TestComplete project and DB2/AS400: var conn = ADO.CreateADOConnection(); conn.ConnectionString = 'Driver =jt400.jar;'+ 'Data Source =ussys;' + 'CurrentSchema=USER;' + 'User ID=XXXXXXX;' + 'Password=XXXXXXX;' conn.LoginPrompt = false; conn.Open(); I see a runtime error: OLE 80040E4D I think it's related to the Connection string, but I'm not able to find out what's wrong. Could someone please help me understand what's missing in the connection string or anything else? Thank you Abhi. Hi Abhi, JDBC and.jar files is Java-related stuff. You need to find regular Windows 32-bit ODBC drivers (or OLE providers) (because TestComplete is 32-bit application) for DB2/AS400 and install them. DB2 Universal JDBC driver version being used The actual driver version is independent of the fix pack version; however, there is a detailed mapping on the Java application development support page that shows which JCC driver version is shipped with each DB2 UDB fixpack. The IBM Data Server Driver for ODBC and CLI product contains the CLI driver. The IBM Data Server Driver for ODBC. DB2 10.5 for Linux, UNIX, and Windows. Solutions: Providing full access to the SQLLIB directory and manually registering the IBM ODBC dll (IBMDADB2.DLL) Steps: Providing full privileges for the SQLLIB directory 1. Connecting to Databases and Data Sources » Creating DSNs for Specific Data Sources » MicroStrategy ODBC Driver for DB2 Z/OS for Windows and UNIX/. Whether or not will these drivers require Java depends on their implementation and I hope that their respective installers will take care about this. Than you will have to create DSN, referencing the database that you are going to use, using ODBC Administrator and use this DSN when specifying connection for.CreateADOConnection(). This is in case ODBC drivers are used. In case of OLE providers, no DSN is required and connection string must be provided for.CreateADOConnection(). This thread () may help you with creation of connection string. Download Db2 Odbc DriverRegards, Alex [Community Expert Group] ____ [Community Expert Group] members are not employed by SmartBear Software but are just volunteers who have some experience with the tools by SmartBear Software and a desire to help others. Postings made by [Community Expert Group] members may differ from the official policies of SmartBear Software and should be treated as the own private opinion of their authors and under no circumstances as an official answer from SmartBear Software. [Community Expert Group] signature is used with permission by SmartBear Software. Regards, Alex [Community Expert Group] ____ [Community Expert Group] members are not employed by SmartBear Software but are just volunteers who have some experience with the tools by SmartBear Software and a desire to help others. Postings made by [Community Expert Group] members may differ from the official policies of SmartBear Software and should be treated as the own private opinion of their authors and under no circumstances as an official answer from SmartBear Software. [Community Expert Group] signature is used with permission by SmartBear Software. Hi Nandini, Important note 1: TestComplete and ODBC driver must be of the same bitness. 64-bit flavor of TestComplete is located in the bin one. Pay attention to this or TestComplete (and ADO subsystem) will not be able to find your DSN and driver. Important note 2: You must use the odbcad32.exe utility to create and configure DSN for the ODBC driver. Like TestComplete, the bitness of odbcad32 must match the bitness of the ODBC driver. odbcad32 must be started from the System32 folder if you are working with 64-bit ODBC driver. If you are working with 32-bit ODBC driver, then start odbcad32 utility from the SysWOW64 folder. Further refers the screenshot you've posted: Use these steps to create a DSN: -- start odbcad32 utility; -- Switch to the User DSN tab if you like to create a DSN that is accessible to your account only. Switch to the System DSN tab if you like to create a DSN that is accessible to any user logged into the given computer. Note, that in the latter case odbcad32 must be started with the elevated privileges (Run As Administrator); -- Click the Add. Button, provide whatever name for the DSN and select the appropriate ODBC driver (DB2/AS400 in your case); -- Select created DSN in the list, click the Configure. Button and provide parameters required by the driver; -- Click Test button to test the connection. Test must succeed. Succeeded connection test means that the DSN exists and is properly configured. Now you must craft the OLE DB connection string that you will provide to the ADO subsystem which is used by TestComplete to access databases. Provides examples of AS400 connection strings. May be used as a possible way to create and verify ADO connection string. Note: If you installed OLE DB provider instead of ODBC driver, there is no need to create and configure DSN then. Only OLE DB connection string must be created in this case. Regards, Alex [Community Expert Group] ____ [Community Expert Group] members are not employed by SmartBear Software but are just volunteers who have some experience with the tools by SmartBear Software and a desire to help others. Postings made by [Community Expert Group] members may differ from the official policies of SmartBear Software and should be treated as the own private opinion of their authors and under no circumstances as an official answer from SmartBear Software. [Community Expert Group] signature is used with permission by SmartBear Software. Hi Alex, Please refer the following steps which I followed: 1. Downloaded and installed v9.5fp10_ntx64_odbc_cli driver 2. Driver Model OS Original Upload Date Last Modification Driver File File Size Compatible Computer Models Availabilty To Instalation Manager Msi Ms 7253 22042.1 For Windows 7 32 bit 5/15/2014 1/3/2017 msi_ms_7253-22042.1.exe 166kb Lenovo 20AQCTO1WW, Advantech UNO-2178A, LG FS-2A35A, Fujitsu D2804-A1, Sony VGN-FJ78SP_W, Medion P6612, NEC VERSAE6300 RNF41137188, Lenovo ThinkPad T430s, NEC RNF91180985, Panasonic CF-50GAKUUKM, Panasonic CF-53JBLBY1M,, and more. Drivers msi k9vgm v ms 7253 drivers. Msi Ms 7253 23482.1 For Windows 10 9/15/2016 msi_ms_7253-23482.1.exe 40kb Lenovo ThinkCentre M72z, HP KJ416AA-AB4 m9298d, Lenovo SS09302455, IBM 2673CXG, Packard Bell EasyNote_GN45, Sony VGN-SR25T_P, Lenovo ThinkStation S10, HP RR455AA-ABF t3727.f, HP HP Compaq 6715b, NEC PC-MY18XAZ7HM95, Packard Bell IMEDIA J4715 AIO, Lenovo 6075Y74, Lenovo SS09254503, Lenovo ThinkCentre M55, Sony PCG-Z505SX, Sony PCG-K14,, and more. Msi Ms 7253 20668 For Windows 7 64 bit 7/22/2014 11/7/2016 msi_ms_7253-20668.exe 44kb HP P6520ch-m, EUROCOM Panther 5D, IBM 26478PU, DTK VistaPro 6250, Fujitsu FMVD7BF010, HP EP187AA-UUZ t3319.ch, Panasonic CF-18KHH59B8, Gateway GT4228m, NEC PC-MY24ABZE4, WIPRO WIV, Toshiba SATELLITE U50-A, HP Presario F500, Sony VPCEB48FJ,, and more. Msi Ms 7253 22246 For Windows 7 2/17/2016 1/23/2017 msi_ms_7253-22246.exe 137kb Fujitsu PRIMERGY TX150, BenQ Joybook S72, Panasonic CF-R3DW1AXS, HP PX679AA-B1U d4040.se, Gateway P-7809u, Toshiba SATELLITE C870D-116, Acer Veriton Z290G, NEC PC-VJ22MAUEHTXV, HP HP Compaq nx6325, IBM 2647LG7, Fujitsu D3161-B1, MiTAC 9008D,, and more. Msi Ms 7253 23792 For Windows 10 64 bit 9/11/2014 1/1/2017 msi_ms_7253-23792.exe 219kb MotherBoard By ZOTAC MotherBoard H61ITX-B-E, Intel SE7505VB2, Gigabyte B85N-WIFI, Toshiba Libretto U100/190DSW, HP HP 2000-425NR, IBM ThinkPad Z60t, Sony VGN-UX71, Sony VGN-AW52JGB, Sony VGN-CS325J, MAXDATA MP2820 01, Packard Bell IMEDIA H5190, IBM 9210M43, HP FK785AA-A2L s3620f, HP CQ2803EDm, Toshiba Libretto U100/190DSW, Sony VPCY119FJ, IBM 621932U,, and more. Testcomplete which I use is 64bit, so to create a DSN, I've navigated to System32 3. Started odbcad32 utility with the elevated privileges (Run As Administrator); 4. Opened System DSN --> Add -->Selected IBM Data Server Driver 5. Entered Datasourcename as 'GIASDTADEV' --> Add--> given the username and password 6. After creating the DSN, clicked on configure and connect. I am seeing the error attached in the screenshot1 8. So, I've edited the confg file manually. Attached even this file for reference. I am not knowing what went wrong that is producing this error. Kindly, provide me a soultion.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |