Hi!

I have a database in which i write & read out, using RemoteData control & ODBC. I ran up into a problem.
How can i trap ODBC errors? For istance if there is a syntax error in sql statement, the ODBC pops up a dialog box, saying that. Is there a way to avoid this dialog box? I tried with On Error goto address, but that happens after ODBC reports the error. I read the help, no luck there, tho it does explain something about trapping errors, but there is no example included.

Also, why wouldn't this work or any similar example using dim variable as rdo***** (copied directly from vb help)

Dim er as rdoError
On Error GoTo CnEh
.
.
.

CnEh:
Dim er As rdoError
Debug.Print Err, Error
For Each er In rdoErrors
Debug.Print er.Description, er.Number
Next er
Resume Next



The compiler stops at Dim er As rdoError line, saying no user defined type not definided.


If anyone has any ideas at all. Please let me know!


Alesh