Http 500 error code - Internal server error

[Guest]

Hi,

Before I start, I have googled this problem for 2 weeks now, have tried lots of suggestions on previous forums al lwith no luck. You guys are my last hope!

Using Dreamweaver 8, SQL server (express edition) win XP pro with IIS , .Net 2.0 framework, MDAC2.7

Heres the problem, I have the database setup all correctly, can access it through the browser etc no problems there.

In dreamweaver 8, I create a new dynamic ASP VB Script page connect to the same database - Bingo! everything works like a charm.

I then change the site to use ASP.NET VB as a model (as this is what I would like to develpop my app in), create an ASP.NET VB page, go to the application panel click the + sign etc > choose OLEDB then SQL server provider.

I select my server name, choose windows authentication as the login method and then can see the dabase in the catalog box and select it. (these are exactly the same settings as the ASP page that I tested and worked).

I click the test button, "Test successfull" Fantastic I think,
Press ok
Next window shows the connection string, I add a name for the connection click the test and get the error message 'Http Error code 500 - Internal server error'.

If I click ok, and then try and expand my database tables = none.
________________________________
I have tried the following:
I don't think its a Database problem, a I have tried with access, MySQL and SQL server all with the same result.
ASP works fine - ASP.NET fails. I have read on other forums that ASP.NET 'remotely' connects to the testing server and this is where the problem may lie.
I have copied MMScript directory to the root of my c:\inetpub\www\root\ directory as this was also a suggestion.
I have added ALL accounts full access to this directory (originally after just trying IIuser and the normal ones).

My testing server is local, in c:\inetpub\wwwroot\pbuyer\
//localhost/pbuyer (not infront of my dw at the mo but can confirm it is setup correctly).

I can only think it is a permissions problem but as a last resort I have given permissions to every account in all folders in order to try and resolve the problem. Other posters have reported the Macromedia could not replicate this and therefore could not provide a solution, and from all posts on the internet there isn't a fix.
Would reinstalling IIS be a goof idea?

Would really aprecciate someone posting a reply as I have hit a brick wall!

[DLoe]

Try looking at a page through the browser to see the specific error.

BUT FIRST, load a web.config file to the root of the site so the specific error codes come up. (I don't have a lot of experience with this, but I've this much.)

The following text should be in the web.config file for the site to disply detailed errors which might help you troubleshoot.

<!-- Web.Config Configuration File -->

<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>

</configuration>

[Guest]

Hi thanks for the reply, very much appreciated. When I get the error 500 message, it isn't actually in a browser, it is a popup box within the setting up a database connection wizard. I can preview forms / any asp.net page absolutely fine in a browser, but not oviously dynamic data as I can't get a connection to the database.

I have located the file you mentioned but looks different!

<configuration>
<appSettings>
<add key="MM_CONNECTION_HANDLER_woo" value="default_oledb.htm" />
<add key="MM_CONNECTION_STRING_woo" value="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=pbuyer;Data Source=office\sqlexpress" />
<add key="MM_CONNECTION_DATABASETYPE_woo" value="OleDb" />
<add key="MM_CONNECTION_SCHEMA_woo" value="" />
<add key="MM_CONNECTION_CATALOG_woo" value="" />
</appSettings>
</configuration>

I have used the OLE DB > BUILD > Provider = 'Microsoft OLE DB Provider for SQL server' approach (not sure if this is correct) because the template for the SQL Server connection is:

Persist Security Info=False;
Data Source=[serverName];
Initial Catalog=[databaseName];
User ID=[username];
Password=[password];

And i wouldn't know what to put in usernme and password as there isn't one as it is set to windows authentication.

Thanks in advance!

[DLoe]

I don't think I can help much with this. I was thinking if you add the right custom erros text to the web.config, it might show you more specific reasons for the failure...either in a browser or through DW.

Add this to the web.config file and see if you get specific error info.

<system.web>
<customErrors mode="Off"/>
</system.web>

[Guest]

Thanks for your help Dloe but that didn't change the error. I have since setup and installed all software on my Windows XP home - laptop although it doesn't have IIS I installed apache and tried using that.... again can't setup an asp.net application.

It has to be a permissions issue.

Is there anyone who can help on this?? do I have to just give up with Macromedia and instead use VS Studio or similar? as this is crazy.

[Guest · Accepted solution]

Ok - I have fixed it.

For all those who have the same problem (and I know because there are literally thousands of this exact topic all over the place with no resolution) you do the following:

Go to services check that all ASP.NET services as running, for me:

ASP.NET State service was set to manual - I clicked start and Bingo !!!! I can at last access my database.

[Guest]

Hi,

I face the same problem (HTTP Error Code 500 Internal Server Error) if i click the Test Button while creating connection from a DataSet. As per the answer, I also started the ASP.Net Service! Still I'm unlucky... Can anyone help me in accessing the database?