RPG2SQL Integrator

• -2147467259 Operation must use an updatable query

• 3704 Operation is not allowed when the object is closed

• Access table creation, manipulation or deleting with RPG2SQL

• Can RPG2SQL be used to compact an MS Access database MDB file?

• Cannot insert explicit value for identity column in table when IDENTITY INSERT is set to OFF

• Checking for an Empty Recordset

• Checking for the end-of-file (EOF)

• Configuring and Testing NotesSQL ODBC Driver to Use with RPG2SQL

• Convert SQL Money format to Floating Point

• Creating a Microsoft Excel Spreadsheet Template to use with RPG2SQL

• Creating an index on a Microsoft Access Table via SQL using RPG2SQL

• Date/Time Data Reading Empty Cells from Excel Spreadsheet

• Deleting Records from SQL Server Database using a DateTime field

• Error -2147217887 Optional Feature Not Implemented

• Error -2147217900 with the stored procedure call to Oracle

• 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

• Error 52 File Not Found with RPG2SQL

• Error 91 Object variable or With block variable not set using RPG2SQL

• Formatting Date/Time Criteria for an SQL Select Statement

• GCompiler Sample for using RPG2SQL with an ILE SQL RPG Program

• German Translation Tables for RPG2SQL

• Is RPG2SQL compatible with V6R1 and V7R1?

• Merging Two Columns into a Third Column in Excel

• Microsoft Access Driver - Syntax error in INSERT INTO statement

• Multiple-step OLE DB operation generated errors

• Not Able to Connect to RPG2SQL From Your RPG Program

• ODBC Driver Does Not Work with Microsoft Access 2007

• Padding a Character Parameter When Calling a Program

• Reading an XLS Sheet Name with spaces in RPG2SQL

• Reserving a new GUID in SQL Server

• Sample ILE RPG code to format ISO date/time field

• Sample Program to Read a Fixed Flat PC Text File using RPG2SQL

• Sample SQL User Defined Function (UDF)

• Samples for coding SQL WHERE criteria in ILE RPG program when using RPG2SQL

• Setting XLS colors in RPG2SQL

• Severe -1305 S0002 Error when downloading a file to a Microsoft Excel spreadsheet

• Severe -3010 07001 Error when downloading a file to a Microsoft Excel spreadsheet

• Sorting records with ORDER BY in SQL

• SQL Criteria to Select Data from a DateTime or Date Field in Microsoft SQL Server

• SQL Server Error 18452 Not associated with a trusted SQL server connection

• Syntax error in INSERT INTO statement

• Testing Whether RPG2SQL PC Server Component Is Running

• Timeout expired error occurring during SQL SELECT with RPG2SQL

• Using Excel 2007 XML Format with RPG2SQL

• Using RPG2SQL Source Samples with iSeries System running a CCSID other than 037 (US)

• Using RPG2SQL with MySQL ODBC Driver

• Using Text File Driver (ODBC) with RPG2SQL

• What version of the RPG2SQL library is installed?