Dreamweaver MX2004 - SQL Server

[Brett24]

Hi, I am trying to start developing ASP.NET pages in MX2004. I have MSDE 2000
installed and my OS is Windows XP Professional SP1. I have created the site
and now I am trying to create a connection to my SQL server. Each time I test
the connection I have created I receive the error 'HTTP Error Code 500 Internet
Server Error'. I am getting so stressed because I cannot find anything helpful
information anywhere. I have updated MX2004 to the latest version. Can anyone
help? Thanks Brett

[Brett24]

Hi, I am trying to start developing ASP.NET pages in MX2004. I have MSDE 2000
installed and my OS is Windows XP Professional SP1. I have created the site
and now I am trying to create a connection to my SQL server. Each time I test
the connection I have created I receive the error 'HTTP Error Code 500 Internal
Server Error'. I am getting so stressed because I cannot find anything helpful
information anywhere. I have updated MX2004 to the latest version. Can anyone
help? Thanks Brett

[CMBergin]

You'll get better solutions if you get a better error message.
Tools->Internet Options->[Advanced]
Uncheck "Show Friendly HTTP Error Messages"

Next time your connection fails, there will be a specific error message
along with an error code. That will help you (and us) solve the problem.

"Brett24" <webforumsuser@macromedia.com> wrote in message
news:d0nepl$a65$1@forums.macromedia.com...

> Hi, I am trying to start developing ASP.NET pages in MX2004. I have MSDE

2000

> installed and my OS is Windows XP Professional SP1. I have created the

site

> and now I am trying to create a connection to my SQL server. Each time I

test

> the connection I have created I receive the error 'HTTP Error Code 500

Internet

> Server Error'. I am getting so stressed because I cannot find anything

helpful

> information anywhere. I have updated MX2004 to the latest version. Can

anyone

> help? Thanks Brett
>

[Brett24]

Hi, I am not sure what you mean by getting a better error message? I cannot
create a connection to my SQL database. If I create an VB.NET page and try and
display it I received the following error in my browser:- Server Error in '/'
Application.
--------------------------------------------------------------------------------
Parser Error Description: An error occurred during the parsing of a resource
required to service this request. Please review the following specific parse
error details and modify your source file appropriately. Parser Error
Message: File or assembly name DreamweaverCtrls, or one of its dependencies,
was not found. Source Error: Line 1: <%@ Page Language='VB'
ContentType='text/html' ResponseEncoding='iso-8859-1' %> Line 2: <%@ Register
TagPrefix='MM' Namespace='DreamweaverCtrls'
Assembly='DreamweaverCtrls,version=1.0.0.0,publicK eyToken=836f606ede05d46a,cultu
re=neutral' %> Line 3: <MM:DataSet Line 4: id='DataSet1' Source File:
c:\inetpub\wwwroot\contacts\new.aspx Line: 2 Assembly Load Trace: The
following information can be helpful to determine why the assembly
'DreamweaverCtrls' could not be loaded. === Pre-bind state information ===
LOG: DisplayName = DreamweaverCtrls, Version=1.0.0.0, Culture=neutral,
PublicKeyToken=836f606ede05d46a (Fully-specified) LOG: Appbase =
file:///c:/inetpub/wwwroot LOG: Initial PrivatePath = bin Calling assembly :
(Unknown). === LOG: Publisher policy file is not found. LOG: No redirect found
in host configuration file
(C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspn et.config). LOG: Using
machine configuration file from
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\confi g\machine.config. LOG:
Post-policy reference: DreamweaverCtrls, Version=1.0.0.0, Culture=neutral,
PublicKeyToken=836f606ede05d46a LOG: Attempting download of new URL
file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET
Files/root/2135a508/8d69a834/DreamweaverCtrls.DLL. LOG: Attempting download of
new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET
Files/root/2135a508/8d69a834/DreamweaverCtrls/DreamweaverCtrls.DLL. LOG:
Attempting download of new URL
file:///c:/inetpub/wwwroot/bin/DreamweaverCtrls.DLL. LOG: Attempting download
of new URL
file:///c:/inetpub/wwwroot/bin/DreamweaverCtrls/DreamweaverCtrls.DLL. LOG:
Attempting download of new URL
file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET
Files/root/2135a508/8d69a834/DreamweaverCtrls.EXE. LOG: Attempting download of
new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET
Files/root/2135a508/8d69a834/DreamweaverCtrls/DreamweaverCtrls.EXE. LOG:
Attempting download of new URL
file:///c:/inetpub/wwwroot/bin/DreamweaverCtrls.EXE. LOG: Attempting download
of new URL
file:///c:/inetpub/wwwroot/bin/DreamweaverCtrls/DreamweaverCtrls.EXE. Does
this help at all? Thanks Brett

[Brett24]

Hi, I have fixed the error I mentioned below 'Parser Error Message: File or
assembly name DreamweaverCtrls, or one of its dependencies, was not found'.
The error was fixed by selecting Deploy Supporting Files from the site menu.
This copied the DreamweaverCTRLS.dll to C:\Inetpub\wwwroot\bin. I still cannot
connect to my SQL server on my local PC. I just want to point out that I see
the 'HTTP Error Code 500 Internet Server Error'. in Dreamweaver and NOT in a
web page. The error occurs when I click the TEST button to test my database
connection. If I click ok without testing I can see my connection but not
tables are present. Any help would be great. Thanks Brett

[Brett24]

Problem Fixed I have managed to resolve this problem. I noticed in the Event
Viewer (System) two errors were created each time I clicked test. There event
ID's were 10001 (DCOM) and 36 (W3SVC). To fix this problem I needed to add the
NT AUTHORITY\INTERACTIVE to the local users group. The permissions on
c:\windows\system32\dllhost.exe were also set to deny for the IWAM account, I
changed this to read. I restarted IIS, tested the connection and everything is
working. More information can be found at
[url]http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q309051&amp;[/url]