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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement