• Import and Export data from AS/400 using ODBC

    I imported data from AS/400 database file into an Excel sheet, using ODBC. I selected Microsoft query in order to retrieve data. How can I export data into AS/400 database file?

    Geek51180 pointsBadges:
  • ODBC connection

    Is there is anyway I can know the remote IP that connecting to my server (AS/400 server) via ODBC? The AS/400 log dose not show any details about the IP it only tell me that the connection happen but without any details. Also some time the connection failed without report any info. Please, I need...

    osamah205 pointsBadges:
  • Using ODBC to update AS/400 file

    I have an application that was written in MSAccess that updates data on the AS/400. The AS/400 table is a Physical file with Journaling turned on. However the programmer that created the file used the # character in a field name. Access does not like queries with the #, so I created a logical file...

    choirboy10 pointsBadges:
  • ODBC connectivity to Oracle 10g database from an Oracle 6i client

    Talking through VB Code from a Oracle 6i Client to a 10G database using ODBC.

    Ronneyrajapathirana5 pointsBadges:
  • Getting data from a SQL Server through Cobol – AS/400 application

    I've seen a lot of questions and answers about accessing data from SQL database but I am still not sure of how to handle what I need to do.  I have a Cobol application on our AS/400 that needs to get data from a SQL server. I have an ODBC connection already configured, but not sure how to...

    CWELLSEATON30 pointsBadges:
  • How to prevent users from PC to use ODBC

    Hello, how can we stop a user say from a windows to use ODBC to connect to the AS/400 server? I am looking more for setting up a block on the AS/400 machine rather than on the PC itself. Thanks!

    Chc22515 pointsBadges:
  • ODBC and AS/400 trigggers

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

    Jjjlake40 pointsBadges:
  • AS/400 ODBC

    Hi Our company uses AS/400 for our financial processing application. The users access the AS/400 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:
  • Connecting Visual Basic and SQL Server

    After creating ODBC, what code will connect the front-end Visual Basic and the back-end SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • odbc as/400 connect to mysql

    I am trying to figure out how to get data from the as/400 into mysql

    Sunnyday25 pointsBadges:
  • Setting up a ODBC connection in Lotus Notes

    I've been trying to connect and send/receive information from a Microsoft SQL Server, in my Lotus Notes application using @formula in real-time, but I'm having trouble with the configuration. I've read that I have to set up ODBC driver. Where can I find that? And do I install it on the server or...

    ITKE364,115 pointsBadges:
  • Calling MS Server from iSeries Stored Procedure

    Hi, I have an ODBC linked server connecting MS SQL Server to my iSeries. What products (other than Java), if any, would I need to be able to call a MS SQL Server Stored Procedure from an iSeries Stored Procedure?

    JeffreyStark5 pointsBadges:
  • “Inventory Log Message” OILM error (ODBC-2035)

    we often encounter ' this entry already exists in the following tables " Inventory Log Message" 'OILM' (ODBC-2035) Message 131-183

    lorielynpechardo775 pointsBadges:
  • Issue with Notes SQL ODBC driver

    Installing on W7 either x64 or x32, always get the error "unable to find nssqlc32.dll" even if set in PATH variable or all files copied to win system folder

    Trevorb30 pointsBadges:
  • Easy and faster way to pull data from a server using ODBC (VBA)

    I am looking for couple of options to pull data from AS/400-ODBC connection and manage data in Excel.

    xxsinghxx20 pointsBadges:
  • AS/400: ODBC call continues to hang

    My Uncle is using C# .NET ODBC connection to try to retrieve data from an iSeries (AS/400) database. From what he tells me, if the files and procedures are not promoted properly on the iSeries side, ODBC should call a level check error. Unfortunately, it appears the handshake between the ODBC...

    ITKE364,115 pointsBadges:
  • How to export data from AS/400 in Excel

    Hi everyone, I would like to know how to in a step by step process export date from AS/400 iSeries into an Excel workbook. The purpose is to gather the data from AS/400, export it to Excel, then filter the data for specific info, then import that to another Excel workbook. A basic inventory report...

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

    a1maida150 pointsBadges:
  • ODBC Library list

    Dear users, If we are using Excel to get External data from iSeries, can we add a library temporary to a predefined Data source such as we can do during File transfer Properties?

    chalenger535 pointsBadges:
  • Retrieving data from AS/400 tables with PHP?

    I think I will die! Does anyone know how to get data from a table on AS/400 displayed with PHP through ODBC? I'm starting to go mad. I tried ODBC drivers (iSeries Access client, Client Access). Nothing helps. I have Apache server as localhost on my machine and PHP installed and that works fine. The...

    Avrelivs80 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