Why won't my page load.

Question

I have a net 2.0 ASP page with an HTML form that connects to a MS SQL 2008 database. I thought it was the connection string that was the problem when my page would not load,but with some help from this site and others, I beleive the connection is being made but the form just isn't loading. I am not an experienced ASP or HTML coder and I am learning as I go. I don't seem to get any errors in my Firefox or IE browser, and either I am not looking in the correct log, or the IIS is not giving me any errors either. The page just never loads. Any ideas?

Answer 1

@Aristos - As far as I can tell there are no errors codes, The page just "loads" forever. Can you tell me what logs to look in? Event Log for Application and System show nothing, SQL logs show successful connection but nothing further.

@GôTô - what debugger?

@rdkleine -my system is on a closed network, not connected to the internet, so please let me know what code ( connection string or form?) you are interested in looking at and I will try to retype it here.

I did find an interesting comment on a different web page.. Is the Microsoft.Data.Odbc.dll a must? I am using the 64bit ODBC connector to make my DSN, which seems to work, but I do not have Microsoft.Data.Odbc.dll installed at all.

Thanks so much to you all for offering to help.

Answer 2

Check EventViewer for errors. Run your application in debug mode, with CLR Exceptions enabled (go to Debug->Exceptions, check Common Language Runtime Exceptions in Thrown column) and you will see if application is throwing any exceptions.

Check http://forums.asp.net/t/1046374.aspx, maybe it will provide some help.

Sidenote: why you are not using standard asp.net connectors to sql instead of odbc?

Answer 3

Is your page ASP or ASP.NET? I am confussed since you have tagged both.

If your are triying to connect from ASP.NET to MS SQL Server then the ODBC connector is not recommended. You should be using the .NET Framework Data Provider for SQL Server. Click on it so you can have a better understading of the way to connect to SQL Server.

Answer 4

@Tomas - Thanks for the help. I have my connection working now. One thing it turns out my pages are ASP.NET 2.0 and my web was configured for ASP.NET 4.0. Once I fixed that I was able to connect. Then I got login failures but once I had my password reset correctly, I was able to get in and insert a new record. I am still having issues with having to restart ISS after some web pages try to load, but at least it is progress.

@ Carlos - To tell you the truth I have no idea what the difference is. I am just trying to fix a page that someone else wrote in 2006 and now it needs to be moved to a brand new server (64 bit) and upgraded from SQL 2000 to SQL 2008. I got the job because I am the only tech on site who had any experience with SQL and a little HTML experience.

The connection string that works is "Provider=SQLNCLI10;Server=server/instance;Database=dbname;Integrated Security=SSPI;"

At least now I know my connection and the database work and I can move on to the IIS problem.

@Everyone - Thanks so much for the help.