AS400 iseries ODBC VBA Excel add-in

已取消 已发布的 Jul 10, 2006 货到付款
已取消 货到付款

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

数据处理 Visual Basic

项目ID: #72868

关于项目

3个方案 远程项目 活跃的Nov 17, 2006

有3名威客正在参与此工作的竞标,均价$70/小时

asaikiran

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

$80USD 在1天里
(0条评论)
2.8
enrymco

Hello, I can help you to solve this problem. Please see my PM Regards Enrico

$80 USD 在10天内
(0条评论)
0.0
freak222

I have done this a thousand times. If you already have the program I can create an module that will be inserted in your program this module will automatically link your VBA Excel program when you install it to other PC 更多

$50USD 在1天里
(0条评论)
0.0