Just a shot in the dark. You don't have ODBC Tracing turned on do you? You can check it in the ODBC control panel applet.

>I have a valid ODBC connection to Oracle 8. However, when
>I try to select all 22 (that's right 22 records) from a very
>small table it is taking 45 seconds!
>
>I have tried both the Oracle and M$ versions of the ODBC
>drivers to no avail. Another developer tried to run the
>same code and it ran as expected - about 1 second.
>
>I must admit that when the DBA installed the Oracle software
>on my PC it was not a smooth operation. This could be
>a registry problem or some such thing. The Oracle supplied
>SQL worksheet runs the query very fast also leading me to
>believe it has something to do with the Oracle install or
>the ODBC driver. Anyone else experience this or have a
>suggestion on how to make this thing work the way it should?
>
>This is the code I am running:
>
>xx=sqlconnect('lexnet-ms') && M$ version of ODBC
>?xx && yes I have a valid connection
>sqlexec(xx,'select * from sites','sites') && 22 records in 45 seconds