I need some urgent help here. For the past week I have been struggling with an asp.net application. Here are it's ingredients:

1)Asp.NET app running on windows 2003 server
2)ODBC Connection which enables communication with CA-IDMS ODBC Driver

3)IDMS Database

My test code is really simple. I create an odbc connection, perform conn.open, execute an sql statement to the CA-IDMS ODBC and some records are returned. Then I attempt to close the connection. Sounds easy, eh

Here is what happens: If I run this code on my server in a winforms app, everything is working okay!

If I run it in an asp.net app, the app freezes on con.open , ISS freezes and no events whatsoever are fired... all that works is to restart the IIS...

Why are there any difference between opening odbc from asp.net and winforms? The code (except presentation layer) is 100 % the same!! All that is different is how the apps are executing... But Im not qualified enough to answer why winforms works and asp.net doesn't.

Here is what differs and stay the same:

Same:

ODBC (system dsn)
CA-Driver
win2003 server
business logic, data logic code

differs:
winforms vs asp.net


Please, Im really desperate! Is there any setting in the framework, IIS or windows server that differs??? What can I do??

kind regards!
Henrik