Communication link failure. A time-out occurred trying to connect to the iSeries Setup
I have a Linux ODBC that pushes data to the AS/400. When I am trying to connect my ODBC Linux connection, it fails and logs the following error message: [rduser@ebsdbprod ~]$ isql -v misysdb erp0101 [08S01][unixODBC][IBM][iSeries Access ODBC Driver]Communication link failure. comm rc=10060 – CWBCO1048 – A time-out occurred trying to connect to the iSeries [...]
Answer Question
| March 12, 2013 8:59 AM
AS/400, Linux, ODBC
I have a Linux ODBC that pushes data to the AS/400. When I am trying to connect my ODBC Linux connection, it fails and logs the following error message: [rduser@ebsdbprod ~]$ isql -v misysdb erp0101 [08S01][unixODBC][IBM][iSeries Access ODBC Driver]Communication link failure. comm rc=10060 – CWBCO1048 – A time-out occurred trying to connect to the iSeries [...]
Answer Question
| March 12, 2013 8:59 AM
AS/400, Linux, ODBC
How to limit exact file name for data access on AS/400 through ODBC
How to limit exact file name…we need the restrict exact file name (not at all) when our user use data access on AS/400 through ODBC.
Answer Question
| January 28, 2013 7:17 AM
AS/400, ODBC
How to limit exact file name…we need the restrict exact file name (not at all) when our user use data access on AS/400 through ODBC.
Answer Question
| January 28, 2013 7:17 AM
AS/400, ODBC
IBMDA400 Date Issues
The IBMDA400 provider seems to convert dates to character values even when using keyword “Convert Date Time To Char=FALSE”. This does not happen with the ODBC driver or IBMDASQL provider. I’d be okay with IBMDASQL except IBM states it only works the SQL statements. I’d be okay with ODBC driver except records can be doubled [...]
Answer Question
| December 18, 2012 4:33 PM
AS/400, iSeries, ODBC
The IBMDA400 provider seems to convert dates to character values even when using keyword “Convert Date Time To Char=FALSE”. This does not happen with the ODBC driver or IBMDASQL provider. I’d be okay with IBMDASQL except IBM states it only works the SQL statements. I’d be okay with ODBC driver except records can be doubled [...]
Answer Question
| December 18, 2012 4:33 PM
AS/400, iSeries, ODBC
AS/400 Profile getting disabled by MS Access
We continue to have an issue where an AS/400 profile gets disabled by MS Access. This only happens sporadically (i.e not with the daily or hourly run of the scheduled tasks/jobs on the windows server). We are using ODBC linked tables to pull data from a couple of AS/400′s in to MS Access. The other [...]
Answer Question
| June 8, 2012 2:15 PM
iSeries, Microsoft Access, ODBC
We continue to have an issue where an AS/400 profile gets disabled by MS Access. This only happens sporadically (i.e not with the daily or hourly run of the scheduled tasks/jobs on the windows server). We are using ODBC linked tables to pull data from a couple of AS/400′s in to MS Access. The other [...]
Answer Question
| June 8, 2012 2:15 PM
iSeries, Microsoft Access, ODBC
Creating New Data Source to SQL Server…
I am going into, Control Panel, Admin Tools, Data Sources (ODBC), under the, User DSN tab I’m choosing “Add…”, then choosing SQL Server. Then under server the one I need..well there are two with the same name, how can this be? A follow up question, not all accounts have access to this, but some do, [...]
Answer Question
| May 5, 2012 5:04 PM
Administrative tools, Data Sources, ODBC, SQL Server
I am going into, Control Panel, Admin Tools, Data Sources (ODBC), under the, User DSN tab I’m choosing “Add…”, then choosing SQL Server. Then under server the one I need..well there are two with the same name, how can this be? A follow up question, not all accounts have access to this, but some do, [...]
Answer Question
| May 5, 2012 5:04 PM
Administrative tools, Data Sources, ODBC, SQL Server
ODBC problem Changing Structure Table
I have a client program conncected via odbc to AS400, I defined a structure table (DDS) in the AS400 that the client program use, then I had to change the length of numeric field (3 to 8) but the client program not recognized. What I have to do?
Answer Question
| March 31, 2012 5:18 PM
DDS, ODBC, V5R3
I have a client program conncected via odbc to AS400, I defined a structure table (DDS) in the AS400 that the client program use, then I had to change the length of numeric field (3 to 8) but the client program not recognized. What I have to do?
Answer Question
| March 31, 2012 5:18 PM
DDS, ODBC, V5R3
use Data connection wizard / Microsoft query to get data from as400 to excel 2007
Hi, I know the way to download data from as400 to excel 2007. It can be done by using Data connection wizard or Microsoft query. However, when using (1) Data connection wizard, i don’t know which kind of database i should choose. ODBC DSN or Other / advanced ? after choosing the kind of database, [...]
Answer Question
| May 12, 2011 6:33 AM
AS/400, Data connection wizard, Excel 2007, Microsoft Query, ODBC
Hi, I know the way to download data from as400 to excel 2007. It can be done by using Data connection wizard or Microsoft query. However, when using (1) Data connection wizard, i don’t know which kind of database i should choose. ODBC DSN or Other / advanced ? after choosing the kind of database, [...]
Answer Question
| May 12, 2011 6:33 AM
AS/400, Data connection wizard, Excel 2007, Microsoft Query, ODBC
ODBC connection to the SQL server from the iSeries
Is there a way on the iSeries to establish an ODBC connection to the SQL server?
Answer Question
| May 5, 2011 6:14 PM
iSeries Access, ODBC, ODBC Permissions, SQL Server, SQL Server connectivity
Is there a way on the iSeries to establish an ODBC connection to the SQL server?
Answer Question
| May 5, 2011 6:14 PM
iSeries Access, ODBC, ODBC Permissions, SQL Server, SQL Server connectivity
Link SQL Server 2008 to AS400
How to set up a ODBC for SQL 2008 to the AS400
Answer Question
| August 10, 2011 11:49 PM
AS/400 SQL, ODBC, SQL 2008, SQL Server 2008
How to set up a ODBC for SQL 2008 to the AS400
Answer Question
| August 10, 2011 11:49 PM
AS/400 SQL, ODBC, SQL 2008, SQL Server 2008
ODBC connection and IP address
Is there a way to get the IP address of a client/server job attached to QZDASOINIT? I can see message CPIAD02 in the QZDASOINIT job log which lists the user and IP address and I need to get this information into a CL program which runs each time the user connects to the QZDASOINIT process. [...]
Answer Question
| March 8, 2011 11:42 AM
AS/400, CL Program, IP address, ODBC
Is there a way to get the IP address of a client/server job attached to QZDASOINIT? I can see message CPIAD02 in the QZDASOINIT job log which lists the user and IP address and I need to get this information into a CL program which runs each time the user connects to the QZDASOINIT process. [...]
Answer Question
| March 8, 2011 11:42 AM
AS/400, CL Program, IP address, ODBC
AS/400 EXIT POINT
Hi , Has anyone worked on exit point PGM . I trying to write one small PGM for allowing ODBC connectivty to my Box from specific Ip address and Userid . When i do WRKREGINF i can see lot of exit point dont know which is used for ODBC connectivity . . Any inputs are [...]
Answer Question
| December 24, 2010 6:29 AM
AS/400 Exit Points, ODBC, WRKREGINF
Hi , Has anyone worked on exit point PGM . I trying to write one small PGM for allowing ODBC connectivty to my Box from specific Ip address and Userid . When i do WRKREGINF i can see lot of exit point dont know which is used for ODBC connectivity . . Any inputs are [...]
Answer Question
| December 24, 2010 6:29 AM
AS/400 Exit Points, ODBC, WRKREGINF
Calling FTP RMTSYS from ODBC in PHP?
Hello everyone. This is an interesting problem. I have this code and I want to call FTP RMTSYS(”) command through ODBC from PHP. Nothing happens. When I issue the command in DBVisualizer: CALL QSYS.QCMDEXC(‘FTP RMTSYS(iSeries_SERVER)’, 0000000020.00000); I get this error: Program contains commands only valid when run interactively. Application error. CPD0772 unmonitored by QSNDEVQ [...]
Answer Question
| December 28, 2010 11:35 AM
iSeries, ODBC, PHP, QCMDEXC, RMTSYS
Hello everyone. This is an interesting problem. I have this code and I want to call FTP RMTSYS(”) command through ODBC from PHP. Nothing happens. When I issue the command in DBVisualizer: CALL QSYS.QCMDEXC(‘FTP RMTSYS(iSeries_SERVER)’, 0000000020.00000); I get this error: Program contains commands only valid when run interactively. Application error. CPD0772 unmonitored by QSNDEVQ [...]
Answer Question
| December 28, 2010 11:35 AM
iSeries, ODBC, PHP, QCMDEXC, RMTSYS
Why aren’t the Crystal Reports indexes showing since loading V6R1?
I use Crystal reports via ODBC to the iSeries and have for years. After loading V6R1 when I go in to create a report, the files aren’t showing any indexes like they used to. The used to show indexes based on the file definitions but now there are no indexes showing. I have even pointed [...]
Answer Question
| November 8, 2010 6:45 PM
Crystal Reports, iSeries, ODBC, OS/400, V6R1
I use Crystal reports via ODBC to the iSeries and have for years. After loading V6R1 when I go in to create a report, the files aren’t showing any indexes like they used to. The used to show indexes based on the file definitions but now there are no indexes showing. I have even pointed [...]
Answer Question
| November 8, 2010 6:45 PM
Crystal Reports, iSeries, ODBC, OS/400, V6R1
SQL Server error 7125: Updated driver to get around?
I have used Microsoft ODBC SQL Server Driver to create a link to an SQL table using Microsoft Access. The table stores Word documents. However Access will not save records once large pictures are added to the Word document (thus increasing the size of the document). The following error occurs: #7125: The text, ntext, or [...]
Answer Question
| November 2, 2010 5:32 AM
Access, ODBC, SQL Server, SQL Server error messages, SQL Server errors, SQLSRV32
I have used Microsoft ODBC SQL Server Driver to create a link to an SQL table using Microsoft Access. The table stores Word documents. However Access will not save records once large pictures are added to the Word document (thus increasing the size of the document). The following error occurs: #7125: The text, ntext, or [...]
Answer Question
| November 2, 2010 5:32 AM
Access, ODBC, SQL Server, SQL Server error messages, SQL Server errors, SQLSRV32
Using Excel 2010 to pull data from SQL Server?
How can I use excel 2010 to pull data from my sql server? I have an odbc connection set up and need data from a specific table in a specific database. I want excel to do some projections and calculations.
Answer Question
| November 1, 2010 9:05 PM
Excel 2010, Excel Database, ODBC, SQL Server, SQL Server database
How can I use excel 2010 to pull data from my sql server? I have an odbc connection set up and need data from a specific table in a specific database. I want excel to do some projections and calculations.
Answer Question
| November 1, 2010 9:05 PM
Excel 2010, Excel Database, ODBC, SQL Server, SQL Server database
ODBC to AS400 test connection failed
Hi, Im trying to connect to as400 by simply using [B style=”font-style: italic;”>Microsoft OLE DB provider for ODBC drivers. In the specify source data i placed the IP address or my as400 then the user ID and password, but when i tried Test Connection the error is general security error.
Answer Question
| October 26, 2010 1:54 PM
AS/400, AS/400 testing, ODBC, OLE DB
Hi, Im trying to connect to as400 by simply using [B style=”font-style: italic;”>Microsoft OLE DB provider for ODBC drivers. In the specify source data i placed the IP address or my as400 then the user ID and password, but when i tried Test Connection the error is general security error.
Answer Question
| October 26, 2010 1:54 PM
AS/400, AS/400 testing, ODBC, OLE DB
Getting prompted for userid/password when viewing Crystal Reports
Connections are ODBC Oracle. You can see a pic of what I am talking about here: This happens for every report on the server. Everyone uses the same login and password so I wish there was a way this wouldn’t bug the user.s
Answer Question
| October 14, 2010 6:13 PM
Crystal Reports, Crystal Reports User Settings, ODBC, Oracle Crystal Reports, Oracle Reports
Connections are ODBC Oracle. You can see a pic of what I am talking about here: This happens for every report on the server. Everyone uses the same login and password so I wish there was a way this wouldn’t bug the user.s
Answer Question
| October 14, 2010 6:13 PM
Crystal Reports, Crystal Reports User Settings, ODBC, Oracle Crystal Reports, Oracle Reports
how to limit data access on AS400 through ODBC, client access or Sequel viewpoint product
[strong]User profiles are assigned a group on our iSeries, and the group has object authority to the data files. What data they can actually see and update is controlled by the application, limited by menu travel and other security parameters built into the system. My issue is with Client Access, ODBC or 3rd party SEQUEL [...]
Answer Question
| September 1, 2010 2:03 PM
AS/400, Data access, iSeries Access, ODBC, SEQUEL ViewPoint
[strong]User profiles are assigned a group on our iSeries, and the group has object authority to the data files. What data they can actually see and update is controlled by the application, limited by menu travel and other security parameters built into the system. My issue is with Client Access, ODBC or 3rd party SEQUEL [...]
Answer Question
| September 1, 2010 2:03 PM
AS/400, Data access, iSeries Access, ODBC, SEQUEL ViewPoint
Disappearing Tables when in Terminal Server
After installing Crystal Report in Windows Server 2003 Terminal Server, I can stand in front of the server (as administrator) AND/OR Terminal into the machine as administrator and create reports. Once I log off my TS session, I can stand in front of the server (as administrator) and create reports BUT NOT Terminal into the [...]
Answer Question
| July 16, 2010 6:15 PM
Crystal Reports, ODBC, Terminal Server, Terminal Server Error Messages, Terminal Services, Windows Server 2003 administration
After installing Crystal Report in Windows Server 2003 Terminal Server, I can stand in front of the server (as administrator) AND/OR Terminal into the machine as administrator and create reports. Once I log off my TS session, I can stand in front of the server (as administrator) and create reports BUT NOT Terminal into the [...]
Answer Question
| July 16, 2010 6:15 PM
Crystal Reports, ODBC, Terminal Server, Terminal Server Error Messages, Terminal Services, Windows Server 2003 administration
DB2 / ODBC file availability
We have a new web app that we want to be able to run 24/7. My question from our web staff is “when the data is available? “. There are 2 situations I can think of that will pose an issue. 1. when we are running file back ups, it most likely will not be [...]
Answer Question
| July 2, 2010 2:50 PM
AS/400 High Availability, DB2, iSeries, ODBC
We have a new web app that we want to be able to run 24/7. My question from our web staff is “when the data is available? “. There are 2 situations I can think of that will pose an issue. 1. when we are running file back ups, it most likely will not be [...]
Answer Question
| July 2, 2010 2:50 PM
AS/400 High Availability, DB2, iSeries, ODBC
