Error 3704 while trying to connect to run a query against an XLS file using RPG2SQL

From Support

If you have a question or seek clarification, please call Technical Support.

Problem:

Error 3704 while trying to connect to run a query against an XLS file using RPG2SQL.

** Example **
Connection request id 356 from 125.1.1.53
Received Open Connection: Driver={Microsoft Excel Driver (*.xls)}; DriverID=790; Dbq=c:\program files\rpgsqlsv\keeney.xls; DefaultDir=c:\program files\;Pwd=; from 125.1.1.53(356)
Sending: 100 SQL
101 OK
199 EOF
 to 125.1.1.53
Received SQL Record Select: SELECT * FROM [keeney] from 125.1.1.53(356)
Sending: 100 SQL
101 OK
199 EOF
 to 125.1.1.53
Received Move to First Delim Record: @@END from 125.1.1.53(356)
Sending: 100 SQL
999 ERR   3704 Operation is not allowed when the object is closed. to 125.1.1.53
Received Close Connection: @@END from 125.1.1.53(356)
Sending: 100 SQL
101 OK
199 EOF
 to 125.1.1.53
Connection closed: 125.1.1.53

Solution:

1. Make sure the name of the spreedsheet is correct. 2. Make sure there is a dollar sign after the sheet name. 3. Make sure the sheet name is surrounded by a "[" and a "]"

** Example **

 *                  ** Run Query to Open ADO Recordset                 
 
 C                   Eval      Rtn = SQL_RunSQLSel(SQL_Socket:          
 C                             'SELECT * FROM [Sales$]')