Do the machines that are causing the problem have different ODBC drivers from the rest?


>We are accessing an Oracle 9i database using Microsoft's ODBC driver for Oracle. We use SQL-Passthrough to download the data we need from the server. On a couple machines (which are on the same network), one particular SQLEXEC statement is taking an extraordinarily long time to run. This same statement has run reasonably fast before on those machines. The SQLEXEC in question is downloading from a table which has a VARCHAR2(2000) field, which obviously gets converted to a memo field on the local cursor. There is a wide variety of data in this field, from a few characters to 1500 characters. The two machines that have this problem connect to a server that few other people connect to, so it makes it hard to determine if this is a problem with the server or those two clients.
>
>I'm kind of leaning towards a problem with the network that these two machines are on, since we have had other users connect to another server and download a lot more data than what these two users are having a problem with. I'm going to see if they can move one of their machines onto the same network that the server is on to see if the problem still exists. I was curious though if anyone else has seen similar problems in the past and could possibly suggest other things to look at other than network problems.
>
>Thanks,
>Jonathan Cochran