mthakershi
Programmer
Hi Guys & Gals,
I am again here looking for some help.
Here is the configuration of my web site.
I am using IIS 5.0 and CR 7.0 on my web server. My report is ODBC based. I have created system DSN on web server that is of SQL server and client configuration is TCP/IP.
My web server IP is 191.11.11.99 and database is on 191.11.11.25. The SQL server has TCP/IP set as default network libraries too. Now the problem is when I access report.asp file for the first time from some machine, on the first hit it gives me following error.
cpeaut32 error '800a5077'
Cannot open SQL server.
/Reports/Report.asp, line 29
Line number 29 is LogonServer method. Then I press refresh or go back and come again, the report displays fine with appropriate data.
So if any one has faced similar problem or have any idea about reason, please tell me.
Keep Smiling,
Malay M. Thakershi
mthakershi@yahoo.co.in
I am again here looking for some help.
Here is the configuration of my web site.
I am using IIS 5.0 and CR 7.0 on my web server. My report is ODBC based. I have created system DSN on web server that is of SQL server and client configuration is TCP/IP.
My web server IP is 191.11.11.99 and database is on 191.11.11.25. The SQL server has TCP/IP set as default network libraries too. Now the problem is when I access report.asp file for the first time from some machine, on the first hit it gives me following error.
cpeaut32 error '800a5077'
Cannot open SQL server.
/Reports/Report.asp, line 29
Line number 29 is LogonServer method. Then I press refresh or go back and come again, the report displays fine with appropriate data.
So if any one has faced similar problem or have any idea about reason, please tell me.
Keep Smiling,
Malay M. Thakershi
mthakershi@yahoo.co.in