Having trouble with simultaneous refreshes on the same ODBC

[jhinkle]

Hi, I’m using HM 6.10 running as a service. I have two ODBC connections going to different tables in the same database. Both work fine unless they are refreshed at the same time. When the fire off at the same time, the stored procedures execute on the SQL Server 2k end flawlessly, however, one of the HM test (the same one every time) gets an error while the other works fine:

“Error: Access violation at address 1F9E0083 in module 'SQLSERV32.dll'. Write of address 02E00190”

One other note. The test that is reporting this error only does it when there is a value in the %Reply% field (not an unknown). Also, it doesn’t seem to matter what kind of result is in the other test in this folder, just as long as they refresh at the same time. (IE: The refresh button for the folder is pressed.)

Any ideas?

-JP

[jhinkle]

Update: I’ve tried using separate ODBC data sources for each of two HM tests. Same result. I also moved all the tables from one of my tests to another database (and obviously created a new ODBC data source for it). Same result.

It seems like HM doesn’t like to execute more than one ODBC connection at a time. Any ideas? Thanks in advance.


-JP

[KS-Soft Europe]

Could you check the MS SQL log out? What exact error do you see?

Regards,
Max