How to allow ASP.NET 4.0 query Sybase Database on IIS 5.1

Question

How to allow ASP.NET 4.0 query Sybase Database on IIS 5.1?

I've been running my website on Debug mode and all works fine, when I publish the website and I add a virtual directory in the IIS 5.1 with it, the query is not running.

Do I've to put some permission or anything of that kind in my website or in IIS to allow database querying?

Answer 1

I've discover that the Exception was "no DSN found", so I had to define the ODBC Server at System level and not User level:

Control Panel -> Administrative Tools -> ODBC ... -> User vs System