Dreamweaver and ODBC

Report · Aug 16, 2006

I am developing a website using PHP and MySQL on my MAC. I have this working via hand typing all code etc, with PHP connecting through the ODBC DSN I have created querying and my MySQL database.

Recently installed Dreamweaver as I want to do some more exciting stuff and want to know how I configure Dreamweaver to connect to my MySQL database through the ODBC DSN (as this is what I require for publishing the pages on my site). I have searched through help and can't find anything.

Also, can you reccomend any good books for MySQL, PHP, dreamweaver development, with Photoshop as well 🙂

Report · Aug 16, 2006

You have to download and install MyOBDC in order to use MySql through OBDC.
You can get it at http://www.mysql.com

--
Nancy Gill
Adobe Community Expert
BLOG: http://www.dmxwishes.com/blog.asp
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"Bikefacts" <webforumsuser@macromedia.com> wrote in message
news:ebuusu$hrb$1@forums.macromedia.com...
>I am developing a website using PHP and MySQL on my MAC. I have this
>working
> via hand typing all code etc, with PHP connecting through the ODBC DSN I
> have
> created querying and my MySQL database.
>
> Recently installed Dreamweaver as I want to do some more exciting stuff
> and
> want to know how I configure Dreamweaver to connect to my MySQL database
> through the ODBC DSN (as this is what I require for publishing the pages
> on my
> site). I have searched through help and can't find anything.
>
> Also, can you reccomend any good books for MySQL, PHP, dreamweaver
> development, with Photoshop as well :-)
>

Report · Aug 16, 2006

I actually have ActualTechnologies ODBC installed, and this works perfectly for me via my php code.

In dreamweaver, when I try to connect to a MySQL database I have no option to select an ODBC DSN. How do I configure Dreamweaver to use the SYSTEM DSN I have created to connect to the database.

Report · Aug 16, 2006

No .. DW doesn't use OBDC for PHP. You can however download PHAkt, the free
ADODB server model addon to DW from Interakt that allows you to connect to
other databases .. and I'm pretty sure OBDC from MySql.

http://www.interaktonline.com

--
Nancy Gill
Adobe Community Expert
BLOG: http://www.dmxwishes.com/blog.asp
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"Bikefacts" <webforumsuser@macromedia.com> wrote in message
news:ebv74b$r0n$1@forums.macromedia.com...
>I actually have ActualTechnologies ODBC installed, and this works perfectly
>for
> me via my php code.
>
> In dreamweaver, when I try to connect to a MySQL database I have no option
> to
> select an ODBC DSN. How do I configure Dreamweaver to use the SYSTEM DSN I
> have
> created to connect to the database.
>