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