Hi there,

I'm having problems connecting to any database. No matter what type of connection I use whether it be OLE DB or SQL Server it gives me "HTTP Error Code 500 Internal Server Error". Do I need to install some type of feature on my web server in order for it to work? Also my aspx pages seem to appear just fine in the browser when I press F12 but not my asp pages. Again do I need to install asp on the web server?

Thanks.

.aspx pages are fine - so you have .NET server running locally?

Regards,
Brent

It's not running on my local computer but on a network computer. The .aspx pages display only when there's no database connection. The database connection works for .asp pages but I get an internal server error 500 when trying to display it. I can only get one and not the other. What is going on? Any help would be much appreciated.

If you are using IE, go to Tools > Internet Options > Advanced - then uncheck "Show friendly HTTP error messages". If that doesn't give you more info, check the actually error log and see what is really happening.

Regards,
Brent

This is the error I get:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/TMPlnscydcfub.asp, line 8

Why can't it find the DSN when it verified that the connection was made successfully?

Whatever machine is parsing that script does not have the DSN created on it, or you've mispelled it in your code.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>Why can't it find the DSN when it verified that the connection was made successfully?<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

You are probably testing with a local DSN you created.

Regards,
Brent

Thanks Brent! That fixed it. Now I have another problem. I can't seem to display any data in aspx pages. When I try to display the page that contains a simple dataset, a file download box appears asking if I would like to open or save the file. It gives the file name, file type which is a web form and from what ip address it's coming from. What's that all about?

Server must not be parsing your page - are you sure .NET server is installed and working properly?

Regards,
Brent

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Thanks Brent! That fixed it. Now I have another problem. I can't seem to display any data in aspx pages. When I try to display the page that contains a simple dataset, a file download box appears asking if I would like to open or save the file. It gives the file name, file type which is a web form and from what ip address it's coming from. What's that all about?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
hi all,
i'm having the same problem, whenever i go to open an ASPX page with a database connection (an Access db using Microsoft.Jet.OLEDB.4.0) from my localhost, IE (and IIS 5?) will not display it - instead IE asks me if i want to download the file. im trying to follow the Global Car Rental Dreamweaver tutorial and display info from the global.mdb db. When in DW i can test the db connection and that works fine (when i'm connected online...), however i don't think the "live data view" works properly. Any advice or tips? Please, i've run out of ideas (Currently updating MS Jet)

is it likely that the problem is because i installed Visual Studio.Net (SDK) first and then installed IIS?

does this mean i'll have to reinstall the SDK or is there a work around?

well i reinstalled the .Net SDK 1.1 from the MS website and that seemed to fix the page loading problem, you might want ot try that elephantstar