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
2
Replies
AdChoices