Connect with ODBC ( Power Query Excel)
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.
Details: "ODBC: ERROR [HY000] [IBM][System i Access ODBC Driver]Key value in connection string too long.
ERROR [HY000] [IBM][System i Access ODBC Driver]Key value in connection string too long."
iSeries Access ODBC Driver connection query returns empty recordset
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?0 votes0 answersMahlatse Dauon May 11, 2018
iSeries ODBC Access Driver - Get exact Double value as it is
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.0 votes0 answersShanmugavel Chinnagounderon Mar 03, 2017
Query returns no records (does in excel)
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.0 votes0 answersWendell Clarkon Sep 14, 2015
Programmatic ODBC Detection on The AS/400
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.)0 votes1 answerPeter Saulton Apr 29, 2014
How to reduce Impact of increasing a field length of AS400 file
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 caus0 votes0 answerssanket ghotekaron Jan 03, 2014
AS400 Connection String using .Net Provider/Libraries
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,0 votes1 answerPranzis Pranzison Nov 27, 2013
Data is not coming in
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 t0 votes0 answersChris Dahlkeon Jun 05, 2012
AS/400 - DotNet - Low performance - Any suggestions
We connected dot net with as400 but it is very very slow when i am trying bring 1 lakh records0 votes1 answervangli rjanon Jul 26, 2010
- Load more posts