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

    ITKE346,365 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...

    ITKE346,365 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?

    chalenger480 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:
  • 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,720 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:

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