Thread: ODBC driver on NT client

ODBC driver on NT client

From
"Jim O'Rourke"
Date:
Hi all

Hope someone can assist.  I'm currently running ODBC driver v6.5 against a
v7.0 backend on Aix 4.2.1.
Everythings been running great on Win 95/98 clients for a couple years (Win
2000 for a couple weeks), and I was hoping to begin using on NT40 clients as
well.

My problem is that 2 minute queries using 95/98/2k clients are taking over
30 minutes on bigger/better NT workstation platforms.  I've set and reset
driver options to no avail.  Seems to my untrained NT eye that the driver is
chowing memory, and starts heavy paging early in the query.

Any info would be appreciated . . .
Thanks

Jim



RE: ODBC driver on NT client

From
Craig Orsinger
Date:
On 02-Aug-00 Jim O'Rourke wrote:
> 
> Hope someone can assist.  I'm currently running ODBC driver v6.5 against a
> v7.0 backend on Aix 4.2.1.
> 
>  Everythings been running great on Win 95/98 clients for a couple years (Win
> 2000 for a couple weeks), and I was hoping to begin using on NT40 clients as
> well.
> 
> My problem is that 2 minute queries using 95/98/2k clients are taking over
> 30 minutes on bigger/better NT workstation platforms.  I've set and reset
> driver options to no avail.  Seems to my untrained NT eye that the driver is
> chowing memory, and starts heavy paging early in the query.
       I've been using a similar connection to a PostgreSQL database
on a Linux box, and haven't seen degraded performance. In some cases,
it actually seems to perform better than an Access database on the NT
client. In any event, as long as you're using the April 2 version of
the PostgreSQL ODBC drivers, things should be OK. I haven't done
anything special to make this work better (given my cluelessness
about NT internals, I couldn't if I wanted to), but just followed the
instructions on the Pgsql ODBC driver website.
       One possible explanation is that there is something wrong or
different about your NT boxe's network setup. You might try doing
FTP transfers or some other network test that uses lots of TCP
connections and transfers lots of data. Sometimes hardware manufac-
turers don't support NT as well as they support Win95/98, so it's
possible your network card's drivers are suboptimal.

----------------------------------
Date: 03-Aug-00  Time: 16:40:29

Craig Orsinger                  (email: <orsingerc@epg-gw1.lewis.army.mil>)
Logicon Advanced Technology
Bldg. 8B28                      "Just another megalomaniac with ideas above his
6th & F Streets                 station. The Universe is full of them."
Ft. Lewis, WA   98433                   - The Doctor
----------------------------------