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$]')                

 


Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016