Originally posted by u2zoo:
<STRONG>I'm guessing the dsn-less (non-odbc) connection string you would use on a windoze box is not the same as that in macintosh-land. How does one go about making a connection to a MSSQL database using dreamweaver ultradev?
in pc land is this:
"Provider=MSDASQL;Driver={SQL Server};Server=name or ip;Database=name;UID=username;PWD=password;"
I imagine the hang up on the mac would be the driver line? Thoughts anyone?</STRONG>
There is no native provider for MSSQL on the Mac. Interesting, though - what application server are you planning on using? There are almost no possibilities on OS9. Maybe Java (JDBC). In OSX you might be able to use a Java driver in PHP or JSP.
Btw - the driver you provided is using the ODBC driver. DSN-less and ODBC have nothing to do with each other (well, except for the fact that if you use DSN, you HAVE to use ODBC). What you're probably thinking of is the OLEDB driver which is faster and recommended by MSFT. It also reduces 1 layer that needs to be traversed. Always use the driver recommended by the mfr. In this case, use the SQLOLEDB driver (if runnign on MSFT platform).
Top
