AS/400 Questionssubmit your own question

With a recent upgrade of our PCs to Windows 10 (64 bit) and using iAccess Client Solutions, 32 bit, (iACS), we lost the ability to run Excel VBA automated sessions on our AS400.

Need to connect to the AS400 database V7R4M0 using ODBC. ODBC connection allows me to enter an SQL statement in the Advanced Option. Need to run a drop table statement and then the create table statement. Assumed the end of statement delimiter would be ";" (semi-colon) but its not.

Re : IBM DB2 for IBMDA400 OLE DB Provider I am trying to make the provider connection READONLY I have added the parameter Read Only Connection=TRUE; to the connection string, but it still allows SQL updates

Hello Everyone, I am trying to create a iSeries Access ODBC Driver connection via TestComplete tool. The connection string used is : "Driver={iSeries Access ODBC Driver}; System=; Uid=UserId; Pwd=Password; MGDSN=0";

I'm trying to connect ODBC database by excel power query, but it's not works. When I try in Windows 7, its works, but in Windows 10, I'm facing problem.

iSeries Access ODBC Driver connection query returns empty recordset if library is not specified. Is there a way in which I can use this string to connect to ISD (As400) and quesry without specifying a library?

Hello All, I am trying to get data from DB2 database using iSeries ODBC Access Driver and I am getting required data and working fine, but I am facing a problem in getting exact double value i.e. For Ex.

I have setup a Word 2013 macro to fill a combobox from an iseries (HTE-sun) data-source, the query works from excel and fills the spreadsheet - macro works fine.

I'm on the AS/400 side of things. External devices use ODBC connection strings to access my files, which have been created using AS/400 DDS. I would like to know if there is any way to detect programmatically on the AS/400 all ODBC enquiries and updates. (Without using trigger files, I should add.)

I am currently working on a project where there is a file which has a field of length 3 (packed decimal). Under the project, we need to increase that length to 5 packed decimal.But this change is caus

Guys, Since ODBC and OLE DB is not advisable, is there a way we can connect to AS/400 using .Net provider? Where can I download such iSeries driver? With appreciation,

I can get the connection to work to our AS400 system. I can pull in any field that is declared as a number. Any field that is delcared a "text" or string field does not come in. We do have one field t

We connected dot net with as400 but it is very very slow when i am trying bring 1 lakh records