ODBC and Mac OS X

This TechNote might help explain things:

Using Dreamweaver with server-side technologies on a Macintosh
http://www.adobe.com/go/16487

David Alcala
Adobe Product Support

Well, sorta... But probably not how you'd think you'd do it.

To get to SQL Server from a Mac using DW, there are a couple of options.
But, if you're programming with the Microsoft technologies (ASP or ASP.NET),
you'll need to have a Windows computer/server handy.

When developing on a Windows workstation, you have the option to use local
database drivers or database drivers on your remote testing server to
connect to the database. When developing on a Mac, you only have the option
to use database drivers on your testing server. In a nutshell, that means
you have to have a Windows machine available to make the connection on your
Mac's behalf.

It works like this... When you make a database connection using DW (using
the remote drivers option in either Windows or Mac versions), DW uploads a
series of scripts to the testing server, executes them and connects to the
database using database drivers on the testing server (a Windows machine of
some sort), and the script returns the data back to DW to use in your
bindings panels, etc.

So if you're going to be developing for the MS technologies on your Mac,
that's what you'll need to have available to you. If you want to connect to
MS SQL Server using PHP, you should be able to use the free PHakt server
model available from http://www.interaktonline.com/ which uses an ADODB
database abstraction layer to connect to a plethora of databases, of which
SQL Server is one. I don't have a lot of experience with this product using
SQL Server, but it should be pretty easy to set up.

HTH :-)

Best regards,
Chris