RPG2SQL Integrator Troubleshooting

From Support

Suggestions

• Are all required programs installed?
• Is it licensed?

If you need Technical Support

Have the following information on hand before you call Technical Support.

Knowledge Base articles for RPG2SQL Integrator

- -2147220999 method of object failed when using RPG2SQL Integrator -2147467259 - Operation must use an updatable query 3 3704 Operation is not allowed when the object is closed 9 999 ERR-2147217900 Microsoft ODBC Microsoft Access Driver Syntax error in INSERT INTO statement C Cannot Access A Remote System From the iSeries Via the System Name Convert SQL Money format to a Floating Point AS/400 format E ERR 91 Object variable or With block variable not set with RPG2SQL Error -2147217887 Optional Feature Not Implement Error -2147217904 Too few parameters Expected 12 inserting record to .mdb using RPG2SQL Error 3704 while trying to connect to run a query against an XLS file using RPG2SQL

E cont. Error 440 when reading an Access DB Error 52 File Not Found with RPG2SQL Integrator Error not associated with a trusted SQL server connection Error occurs when selecting a derived GUID field from a SQL Server table Error with RPG2SQL Program signature violation M MS KB Q194124 - PRB: Excel Values Returned as NULL Using DAO OpenRecordset Microsoft ODBC SQL Server Driver SQL Server Cannot insert explicit value for identity column in table when IDENTITY INSERT is set to OFF Multiple-step OLE DB operation generated errors O Odd data/time data reading empty cells from Excel Spreadsheet with RPG2SQL Integrator P Padding Single Quotes in SQL Data Before Updating to an ADO Database Problem with the stored procedure call to Oracle

R RPG procedure RS005R in program RJSSPLIT/RS005R at statement 2001 Read XML files using RPG2SQL Integrator Reading XLS Sheet Name with spaces in RPG2SQL Receiver value too small to hold result error occurs from SQLEXTDDS procedure call when used from a COBOL program Run SQL DELETE statement using RPG2SQL Integrator and return a counter indicating how many records were deleted S SQL Selection Criteria to select data from a DateTime or Date field from an SQL Server Severe -1305 S0002 System Error 31: Unable to create ODBC Data Source with Windows 98 T Timeout expired error occurring during SQL SELECT with RPG2SQL U Using RPG2SQL Integrator with MySQL ODBC Driver W When starting RPG2SQL Integrator as a Windows servicet the user cannot connect to the RPG2SQL Integrator from their RPG program