• Firewall preventing NET USE drive mapping PC to iSeries.

    Does anybody know what ports are used when I run net use * \\servername\share PWD /User:USER ? The firewall is stopping it somewhere although ports 137, 139, 445, and 8471-8477 are open on the firewall. It eventually times out with "System error 53 has occurred - The Network Path was not Found"...

    stropley10 pointsBadges:
  • Transfer data from DB2 file to SQL Server file

    I want to transfer a data from a DB2 file to a SQL Server file. I do not want to buy a software that do it. I want to do it by myself (perhaps using ODBC) Thanks all for help. Abdou

    HABDOU5 pointsBadges:
  • Difference between ODBC and JDBC?

    I'm writing a Java application. In short, this application needs to connect to DB2 on an AS/400 for some SQL data. I cannot find a straightforward comparison of ODBC and JDBC. Do any of you know where I can find one? Or, have any of you done java programming with the intent to connect to AS/400 SQL...

    Schmidtw11,330 pointsBadges:
  • 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 -...

    EBSERP30 pointsBadges:
  • 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.

    ODBC35 pointsBadges:
  • 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...

    Craig Hatmaker1,830 pointsBadges:
  • 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...

    Kdh05045 pointsBadges:
  • 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...

    ITTinker5 pointsBadges:
  • Failed Link to External Data

    I was able to link to all external data in ODBC Oracle database but one table that has more than 32 indexes. How can I link to this table? Please advise. Thanks

    Pcy5 pointsBadges:
  • How to setup, configure, then connect to Oracle 10g on Windows Server 2003 without using ODBC?

    What (and how) is the bare minimum installation to connect from a non Oracle app to Oracle 10g on a Windows 2003 server. The non Oracle app cannot use ODBC but need to connect to an Oracle connection driver.

    SpamMusubi5 pointsBadges:
  • 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?

    pmalopez5 pointsBadges:
  • How do I save the security settings created in operations navigator?

    In operations navigator V6R1 I use Application Administrator to give users access to FTP, ODBC, File Uploads and Downloads etc... I would like to save these settings on a weekly basis. What do I need to save? Also, I have a backup system that I am replicating to. How can I replicate these security...

    KaMci5 pointsBadges:
  • Link SQL Server 2008 to AS400

    How to set up a ODBC for SQL 2008 to the AS400

    Jaymz69765 pointsBadges:
  • VB6.0 Connectivity to Oracle

    How to connect oracle 9i to vb6.0 using active X data objects? please mention the code.. Thnx ...  Saurabh

    981500799910 pointsBadges:
  • 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,...

    Clarksonneo15 pointsBadges:
  • 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. ...

    BISHT321245 pointsBadges:
  • Linked Server Query Returns Incomplete Results

    I have set up a linked server using Microsoft OLE DB Provider for ODBC Driver to an Oracle DB ODBC DSN. The Oracle table I'm querying has 865 rows but when I try to fetch all the rows I only get back 766 rows. Why am I not getting the complete results? Here is the query I'm using: select * from...

    Apickel350 pointsBadges:
  • 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...

    Avrelivs80 pointsBadges:
  • 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 welcome  . Thanks ,...

    BISHT321245 pointsBadges:
  • 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 the ODBC...

    DHardy5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following