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

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