I wonder if anyone knows a workaround for creating a connection to a MySQL database using ASP.net which is compatible with the Dreamweaver standard server behaviours. I have been looking everywhere, but I have not seen a solution anywhere yet.
I can get a connection (with MySQL ODBC) and it retrieves the tables from the database in the DMX dataset dialog box, but when using any server behaviour it gives error messages that an OLE DB was not specified. I guess because by design Dreamweaver uses the default OLE DB connection script when using ASP.net (unless you are using MS SQL of course).

If there is no workaround (maybe because of DreamweaverCtrls.dll), I wonder if Macromedia is planning on adding support for ASP.net and MySQL. Quite a powerfull combination I think, but maybe my knowledge is not reaching that far to see the obstacles.

Got it! Found a workaround... This topic can be closed... <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Got it! Found a workaround... This topic can be closed... <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

I'm having the same problem as you had. Can you tell me what the work around was?

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Got it! Found a workaround... This topic can be closed... <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Please don't keep this workaround a secret! I also need to use ASP.NET and MySQL within Dreamweaver! How'd you do it!?

Hehe.. It's been quite a long time since I've been here, but here's the solution:

- Make sure you have the correct drivers installed.
- Use this as the connection string:

Provider=MSDataShape.1;Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=myDatabase;User Id=myUserName;Password=MyPassword

I have no idea why it only works with MS Datashaping, but it works for me <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

By the way... Check out Microsoft SQL Server Express. It's free, and more and more hosting providers offer this database as a cheap alternative to the full package.

Good luck!

Hi Guys,

why would you want to use MySQL (nice dbms by the way) if you can get SQL Server 2005 for free?

----------------------------------------------
The client is allways right even if he is not.

Thanks Q Qwerty!
I looked for a long time to figure this one out.