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
** 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.