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:
- Make sure the name of the spreedsheet is correct.
- Make sure there is a dollar sign after the sheet name.
- 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$]')
Last Modified On:
No, open a new Support Case