Hi,
I have an application program that used native drivers to
connect to MSSQL 6.5 database. We are switching the
program to ODBC because we want to upgrade to MSSQL7.0 and
the connection performance awful and we haven't found a
fix.
In switching to ODBC I have an application program that
uses cursors. When I run that program that displays a
report from my workstation, it seems to lockup all other
users request until I exit the application. Their
requests seem wait even if the information they are going
after is in another database on the server.
Does anyone have any ideas on what might be wrong?
Any suggestion appreciated.. Thanks in advance.