Web Application accessing SQL on remote server, returning blank web page
I am running the "Creating a Web application using Visual C# or Visual Basic" from the Visual Studio.NET documentation and have run into a problem.
This program access the Pub DB on a SQL server. The web page and SQL are located on seperate servers.
I have compiled the code, C#, without errors. When I run the code, I get a blank page instead of the table I expected. I have disabled Anonymous access in IIS (5.1). I changed the authentication Mode to Windows and identity impersonate to true in the Web.config file.
My connection to the SQL server tested successfully. I CAN preview the data in Visual studio.net. I can also access this data through a Windows application with no problem.
Does anyone have any idea why I get a blank Web page and no errors?