Josh, I think I owe you one! Indeed the ODBC tracing was turned on.
I have no idea how it got turned on, but that was the problem and
solution. I was considering reformatting my drive and reinstalling
everything.
Thank goodness for you and the UT!!!
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only