Hi there!

Just moved my site to another ISP, and I get the error code:
HTTP Error Code 500 Internal Server Error<b></b>

This error occurs in Dreamweaver MX when changing the database connection.
I use ASP VBScript, DWMX and Access.

Everything else seems fine with the page, and it works fine when on site. The
recordsets allready created before the move works too. But I cannot create new
recordsets due to this error.


Any clues?

Regards, Christian

I seem to remember getting this error when I first tried to connect to my Access database on the server. I think the problem was that the DSNless connection string I supplied wasn't correct. It should be of the form

MM_sarresconnection_STRING = "Driver={Microsoft Access Driver (*.mdb)};DBQ=e:\sarredir1\sarredir2\sarresacessdb.mdb"

where sarredir1 and sarredir2 correspond to the directory and subdirectory set up for you by your web hosting company

Hope this helps. If not let me know

What I meant to say was that the directory and subdirectory names may be different for your ISP (didn't mean to insult you by implying you didn't know about DSNLess connections. I'm fairly new to this stuff and in no position to insult anyone. Yet : )

Hi Zooropa!

No insult taken <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Thank you for your respond, but I'm afraid I have supplied the right connection-string, so that rules out that one.

My ISP wondered if they had to install some special Dreamweaver-programs on their servers in order to make this work, but I don't think that would be neccesary.

We also have ruled out writeaccess to the folders in wich the database resides.

Let me know if something else comes to mind!

Regards,
Christian

Christian,
if you want, you could try sending me the relevant files and your access database. I could try and get it working on the server I'm hosted on (has ASP extensions). That way it would let you know if the problem lies with your hosting company or not. I don't have broadband so if you could send your stuff in blocks of less than 1MB at a time, that'd be helpful. On the other hand, you might not want to send your files.

Mark

Hi again!

I found a way to move around the problem. By using a connection named the same on uploaded files as locally, the webpage seems to be retrieveing the info and displaying it correctly. In other words I have to make the files locally, then upload for testing.

Still a mystery why DW won't connect though..

But since I've found a way around the problem, I think I will let the case rest for now. Have to use my time on the other parts of the project.

Really appreciate your time, help and understanding Zooropa! <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>


Regards, Christian