AS400 iseries ODBC VBA Excel add-in
$30-100 USD
货到付款
Hi
I created a VBA Excel program to get data from our AS/400
It works on my pc but not my boss's. It says 'connection failed' He has Client Access installed.
What would he be missing?
It seems like from the connection string below that he would need Client Access Driver but isn't that automatically installed if he has Client Access.
Is there an easy way to do this so there isn't a complicated setup for each user?
I need you to troubleshoot and solve this problem
Here is the connection string I use.
'Create query to retrieve individual records..
Set qtDetail = [login to view URL]( _
Connection:="ODBC;DRIVER={Client Access ODBC Driver (32-bit)};UID=" & getUID & ";PWD=" & getPWD & ";SYSTEM=[login to view URL];DBQ=QGPL AXXDTA;DFTPKGLIB=QGPL;LANGUAGEID=ENU;PKG=QGPL/DEFAULT(IBM),2,0,1,0,512;TRANSLATE=1;SIGNON=1;", _
Destination:=[login to view URL]("A4"))
Any help much appreciated
项目ID: #72868
关于项目
有3名威客正在参与此工作的竞标,均价$70/小时
Hi, I am very much interested in this job. I am from Hyderabad, India. Request you to please check ur PM now and get back to me ASAP. Thanks and Regards, Sai Kiran