Forums

This topic is locked

DW MX, connection problem (sql server C#)

Posted 05 Jun 2002 13:22:41
1
has voted
05 Jun 2002 13:22:41 david titi posted:
Does anyone have experience with setting up Dreamweaver MX with SQL Server
2000 and IIS to develop an ASP.NET (C#) application? To my knowledge, SQL
Server is configured correctly, but I have been unable to get Dreamweaver to
establish a working connection with the database under the .NET model. My
current setup works fine if I change the site model to classic ASP
(VBScript). When I try to test the SQL Server Connection, Dreamweaver
simply gives me an unidentified error. Any ideas? Help would be greatly
appreciated. Thanks!

Replies

Replied 06 Jun 2002 02:27:46
06 Jun 2002 02:27:46 Niku Niku replied:
I have the same problem!!! Anyone can help us??? <img src=../images/dmxzone/forum/icon_smile_angry.gif border=0 align=middle>
Replied 12 Jun 2002 21:48:10
12 Jun 2002 21:48:10 david titi replied:
I've found if I remove this ;
ver = CInt(right(svr, len(svr)-ix))
if ver &gt; 4 then
I keep only this line --&gt; Session.CodePage=65001
end if

in MMHTTPDB.asp everything works but why ?


I work with XP PRO and 2000 Pro french version



Replied 13 Jun 2002 01:12:11
13 Jun 2002 01:12:11 Niku Niku replied:
Sorry, but what is the name of the file that i have to modify???
(Sorry for my english, i'm Italian!)
Thx

Edited by - nikuniku on 13 Jun 2002 01:13:19
Replied 13 Jun 2002 08:33:49
13 Jun 2002 08:33:49 david titi replied:
first click on test, you will receive your error 500, then go to your site folder and in _mmServerScripts folder find this file : MMHTTPDB.asp

modify this file and go back to DW MX then open your connexion dialog box and click test, now it works <img src=../images/dwzone/forum/icon_smile_wink.gif border=0 align=middle>
Replied 13 Jun 2002 15:33:27
13 Jun 2002 15:33:27 Niku Niku replied:
Thanks!!! It works for me too!!!

I don't know why, but it works!<img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>
Replied 13 Jun 2002 16:01:28
13 Jun 2002 16:01:28 david titi replied:
I think it's the decimal separator

I'm not sure

Reply to this topic