Re: FTP: problem with the syntax
Ok, now we're getting closer:
after the Inet1.Execute , "CLOSE" there is an EXIT SUB
missing.
That's why your code runs into the errorhandler, although there is no error. Thus you get the "Resume without error" message.
Now, "somewhere" there is "some code", that does something that fills the rdoError collection.
That's the place to look for...
But, that has never been posted, has it?
Re: FTP: problem with the syntax
OK, I'm a stupid.
Now, I have the EXIT SUB writed. And the error message is this:
35764 Still executing last request
IM006: [INTERSOLV][ODBC Informix driver]Driver's SQLSetConnectAttr failed. 0
S1C00: [INTERSOLV][ODBC Informix driver]Optional feature not implemented. 0
I don't understand what means "Still executing last request". (I don't speak English)
You say : "somewhere" there is "some code", that does something that fills the rdoError collection.
Yes ! But which code? I have posted the code with the connection string and the code to the Inet control. The others codes aren't connection's codes. For example:
Function LlenarGrilla()
consulta = "SELECT * FROM contratos order by ejercicio"
Set rstTemp = conNumeros.OpenRecordset(consulta, dbOpenDynaset)
While Not rstTemp.EOF
grilla.AddItem rstTemp!ejercicio & Chr(9) & rstTemp!delegacion
rstTemp.MoveNext
Wend
rstTemp.Close
End Function
...where rstTemp is a Recordset and grilla is a Grid control
Re: FTP: problem with the syntax
"Still executing last request" means that ADO (or whatever your database interface is) is still busy executing an SQL request that you issued and is not yet done with it, while you are already trying to do "something" else on the same connection.
The "SQLSetConnectAttr failed" error means that you are trying to set a connect attribute that your driver does not understand.
You might wanna use ODBC tracing mechanisms to figure out what really happens. Depending on your ODBC versÃ*on and operating system OdBCtracing can be enabled via control panel/odbc.
Something you might wanna try:
replace dbOpenDynaset with dbOpenSnapshot
Re: FTP: problem with the syntax
I'm using the Intersolv 3.11 32-bit Informix9 ODBC driver.
So, I have called Informix technical support and they have said me that this driver can't to transfer files between Unix and W95. It can to connect only with the Informix database. I need other driver.
Lothar, thanks for your patience, and thanks for all.
Federica, Argentina