I am writing a C++ app that opens two connections to SQL server; there is
never more than one active statement on either connection. The connections
are used from two different threads. Both connections are adding rows to
the same table but taking input from different sources.
The problem is that either connection works fine by itself, but when I try
to use both simultaneously then the program cracks up. Sometimes the
de* shows that my threads are hung waiting on a critical section
(deadlock), sometimes it is an access violation somewhere inside ODBC.
I am using Visual C++ 5.0 Enterprise Edition, WinNT 4.0 SP3, SQL Server 6.5
SP2, SQL Server ODBC driver 2.65.0240.
If somebody suggests getting newer files, could you please also give me the
URL to the Microsoft site? I have a really hard time finding stuff there.