I've set up an ODBC driver on a SQL server and I've managed to access data from the ingres database. However, it is taking 9 minutes to bring back data from a simple query.
I've also set up an ODBC driver on my PC and it takes 8 seconds doing the same query through a connection string in VB. However the same query in access brings back the data instantaneously, which suggests there is something wrong maybe with the way the SQL server talks to the Ingres server.
I've also set up an ODBC driver on my PC and it takes 8 seconds doing the same query through a connection string in VB. However the same query in access brings back the data instantaneously, which suggests there is something wrong maybe with the way the SQL server talks to the Ingres server.
