ODBC connection is extremely slow

odbc

I have an ODBC connection to a providex database. We use the database in software throughout the company, and the ODBC connection is created by a standard installer.

Trying to test the ODBC connection or query it in Crystal Reports.Net, results in the program or ODBC admin locking up for about 10 minutes before finally returning with the query or test result. This problem has only been happening on my pc.

There's an ODBC connection to a different database that works just fine, as well.

Has anyone else run into this problem and/or found a solution?

Best Answer

Can you run Wireshark during this behavior on your machine and see if anything jumps out at you? Try it on the server as well, if you can.

I don't know anything about Providex specfically, perhaps there's some tracing you can turn on at the client to help you figure this out?