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

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

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

    c007285 pointsBadges:
  • 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

    Mikedavid005 pointsBadges:
  • job QZDASOINIT

    My web application is using ODBC connection to access DB2.Connections are closed properly on each page.But job QZDASOINIT is not ending and remain in TIMW status.This is creating large number of jobs on server.How can i close this job when connection is closed?

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

    RSB5 pointsBadges:
  • odbc question

    what odbc driver you use to go from system-i to sql2005 i sue IBMDA400 but does not handle pack fields very well any suggestions?

    Colo20055 pointsBadges:
  • ODBC and AS/400 trigggers

    Will a AS/400 physical file trigger work when the file is updated by ODBC?

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

    Scp19735 pointsBadges:
  • 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 available due to object locks. We could do a...

    ToddN20006,360 pointsBadges:
  • Using a .csv to create an ODBC connection.

    I am using an ODBC drive to read a .cvs.dsn file and establish to folders where other .csv files are located and converted into .phb file. The software is WFHC Halifax version 1.2. . CSV file.  [ODBC]DRIVER=Microsoft Text Driver (*.txt; *.csv)UID=admin...

    Jefallon5 pointsBadges:
  • AS400 ODBC

    Hi Our company uses AS400 for our financial processing application. The users access the AS400 through an emulator. They also access the application database through ODBC. They extract the data to excel sheets to create certain reports for their own purpose. Recently, one the data base files in...

    Pgsdeb20 pointsBadges:
  • AS400 ODCB table link

    When i link tables with a ODBC driver then some table won't give me any records (I link into microsoft access. But I do see the column headings. I the record fields I get: #Name? Is this an AS400 problem, ODCB or Access ?

    Davidfromnetherlands15 pointsBadges:
  • odbc in i5/OS

    I need to know how i can create an data source name or a odbc connection for a database in i5/OS. Kindly guide me.

    Jacky160 pointsBadges:
  • ODBC Error Message Windows Server 2003

    ODBC error:   "OLE IDispatch exception code 0 from Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.."

    Gina35 pointsBadges:
  • odbc data source

    odbc data source not displaying all dbs when pointing to sql2008. Only shows default db. odbc data source that points to sql2000 shows all dbs user has access to.

    Dowens20 pointsBadges:
  • How do I fetch synonym names with the SQLTables function in ODBC API?

    Can somebody please explain how to fetch synonym names with the SQLTables function in ODBC API. I currently use the DSN created with SQL Native Client 10 and SQL Server 2005. My code is as follows:</p><p>ret = SQLTables(stmt, NULL, 0, NULL, 0, NULL, 0,...

    SQL Server Ask the Experts2,585 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