İptal Edildi

AS400 iseries ODBC VBA Excel add-in


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 = [url removed, login to view]( _

Connection:="ODBC;DRIVER={Client Access ODBC Driver (32-bit)};UID=" & getUID & ";PWD=" & getPWD & ";SYSTEM=[url removed, login to view];DBQ=QGPL AXXDTA;DFTPKGLIB=QGPL;LANGUAGEID=ENU;PKG=QGPL/DEFAULT(IBM),2,0,1,0,512;TRANSLATE=1;SIGNON=1;", _

Destination:=[url removed, login to view]("A4"))

Any help much appreciated

Beceriler: Veri İşleme, Visual Basic

Daha fazlasını görün: vba as400, as400 odbc, iseries excel add, iseries odbc port, iseries excel vba, iseries vba, vba excel as400, as400 vba, vba excel odbc connection as400, excel vba odbc connection as400, excel vba as400, excel odbc as400, vba odbc iseries, client access odbc driver, excel odbc vba, as400 odbc excel, as400 excel, vba as400 connection excel, odbc languageid, as400 excel add, as400 add, as400 odbc vba, as400 odbc port, vba odbc as400, iseries odbc

İşveren Hakkında:
( 17 değerlendirme ) Hampstead Heath, United Kingdom

Proje NO: #72868

4 freelancers are bidding on average $75 for this job


Connecting through your firewall to the iSeries is really quite simple. The following ports must be opened for regular TCP/IP connection: 23, 449, and 8470 through 8476. However, if you are using an SSL connection, you Daha fazlası

1 gün içinde 89.95$ USD
(18 Değerlendirme)

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

1 gün içinde 80$ USD
(0 Değerlendirme)

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

in 10 gün içinde80$ USD
(0 Değerlendirme)

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 Daha fazlası

1 gün içinde 50$ USD
(0 Değerlendirme)