Works on local iis server but Not on Public iis

[ShawnDuPlessis]

I developed a crystal report web application in version 9. The report is using *.ttx file for field defenitions and SQL via ASP to execute the query. On my local Web server the application works but when i try to implement it on our IIS intranet server it gives 3 different responses.

1: It hangs and gives no result. ( Does not even open ActiveX Viewer)
2: It opens the ActiveX Viewer but gives a "Unable to access data source" error.
3: Give a "Invalid TVL record" error.

Can anyone please help me.
Thanx shawn

 

[butkus]

Does your local iis server use ODBC to access the data? If so, does your public iis server have the ODBC drivers loaded?

 

[adisankar]

check the connection string on your local machine and implement the same on the public server. then check whether the public machine is able to connect to the data source using odbc manager or udl file.