ASP.NET app not able to connect to Timberline Data ODBC

Question

Hi,

 

I have set up the ASP.NET app on IIS on the server and that uses the "Timberline Data" ODBC driver to access the timberline data. But, somehow the application is not able to connect to data stored in timberline database and it is giving the following error:

 

System.Data.Odbc.OdbcException: ERROR [42S02] [Sage][SQLEngine] (31740) Table or view not found

 

The 32 Bit Timberline data driver is installed on the server. Also, the application set up in IIS is configured to run a 32-bit application. 

 

I had a sample console application developed having the same code to connect to Timberline data and if I run that on the server then it works and can read the data from Timberline data.

 

The application is running under the same user using which the console application works!

 

Can anyone help in resolving this issue? Thanks in advance!