I am using DW MX 2004. I want to establish a connection to a remote server running Linux. I have a Mysql db on that server and am using ASP. I have been unsuccessful adding a custom connection string in DW so I wrote a basic ASP script in notepad and was able to connect and query the db just fine. When I use the same string in DW I get a code 500 internal server error from DW.
Heres my connection string
Driver={mySQL}; Server=localhost; Database=myusername_address; Uid=myusername_user; Pwd=mypassword;

Thanks for any help

i have the same problem. does anyone have the answer.

thanks