Thursday, April 1, 2010

MSSQL connection with PHP in DW

Hello,

I know that DW 8 has a built-in connection when using php
with a mysql database.

However, I would like to connect to a remote Microsoft SQL
Server with DW and php.

Is there a way to make this connection ? Probably not
built-in but maybe through any other way ? I have full access to
the SQL Server.



Thanks in advance for your help.



Marion





MSSQL connection with PHP in DW
MarionKi wrote:

%26gt; Hello,

%26gt; I know that DW 8 has a built-in connection when using
php with a mysql

%26gt; database.

%26gt; However, I would like to connect to a remote Microsoft
SQL Server with DW and

%26gt; php.

%26gt; Is there a way to make this connection ? Probably not
built-in but maybe

%26gt; through any other way ? I have full access to the SQL
Server.



All the server behaviors in Dreamweaver are MySQL specific,
so even if

you make a connection, none of the DW code will work.



PHP 5 introduced PDO (PHP Data Objects), which allow
connection to any

database (providing the appropriate drivers are installed on
the

server). However, DW doesn't yet support PDO.



You will need to hand-code everything yourself.



--

David Powers, Adobe Community Expert

Author, ''Foundation PHP for Dreamweaver 8'' (friends of ED)

Author, ''PHP Solutions'' (friends of ED)


http://foundationphp.com/

No comments:

Post a Comment