Iseries odbc driver download version 12.00.02.00

NET OData. Contact Us. Thanks for the help. Thanks to Charles as well, for all your answers over the last couple days. I'm having the same issue but only have access to a linux server. I'm assuming pyodbc works only on windows systems. Do you know a solution for linux? Jimmy - maybe you will find something useful here. JohnY This definitely helps! Add a comment. The way to find out what port is needed is to look at the service table entries on the IBM i.

Charles Charles Thanks for the quick reply. I'll ask them to double check the ports, but I'm told that no one has modified any of those. If I try instead of , I get something like "execution of the SQL statement failed because of an error in the communication data stream that will affect the successful execution of subsequent commands and SQL statements. I forgot to say that I have all necessary IBM drivers and products installed our company has access to those.

In fact, other software we use that has to talk to the runs on my machine without problems, so I'm positive that I have all necessary software. Also, I've just gotten confirmation that our ports are set up just like the standard ones so and are the two possible ones. Yet, is the one that hangs and never errors or times out, while errors out within two seconds.

Try IBM i or even iSeries. My boss, and the other people who work with the system, all call it an AS, so I figured that was the actual name. Thanks for the clarification on that. Also, I was told on a mailing list to only use , not Hey, at least the attempt isn't hanging anymore! The most important setting for access and the jet engine is the enable lazy close support setting, located under the odbc driver's.

I am running Windows 7 bit and have installed Office The required bit driver, Microsoft Access Driver. PoC PoC 2 2 silver badges 13 13 bronze badges. Note that the iSeries Access for Linux 7.

You will get crashes when using modern unixODBC versions. A workaround is to use the bit driver, but you may need to find an older, bit version of Linux to get that to work. Add a comment. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Sign in. United States English. Ask a question.

Quick access. Search related threads.