Inserting a MS SQL Server dataset with PHP

Report · Mar 19, 2009

I have a Dreamweaver PHP site, but we use our corporate MS SQL Server 2005 servers for our data. How do I insert a dataset pointing to our MS SQL Server? The default dialog keeps requesting my MySQL server, which of course, I do not have.

Report · Mar 19, 2009

Terry3 wrote:
> I have a Dreamweaver PHP site, but we use our corporate MS SQL Server 2005
> servers for our data. How do I insert a dataset pointing to our MS SQL Server?

The PHP server behaviors in Dreamweaver are compatible with MySQL only.
To connect to any other database system, you need to hand code
everything yourself. The reason for this lies in PHP's original decision
to create separate functions to interact with each type of database,
rather than adopting a database-neutral approach.

PHP 5 implements a database-neutral approach with PDO, but this is not
supported by Dreamweaver. If you want to see Dreamweaver adopt a
database-neutral approach, submit a feature request through the official
form at http://www.adobe.com/cfusion/mmform/index.cfm?name=wishform.

--
David Powers
Adobe Community Expert, Dreamweaver
http://foundationphp.com

Report · Mar 19, 2009

David,

How do I go about doing this manually? I am severely disappointed in DW's shortcomings in this area. Even if I set up a legitimate php connection file that properly calls the mssql functions, DW won't work with it. And if I create a PHP page and try to include a dataset on it, it won't even show the .asp connection it created earlier. This is draconian.

So, it looks like I'm stuck doing this manually. May just move over to YUI and forget about DW for this.

I tried your link for the wishform, but it came up "Page Does Not Exist." Oh well.

Terry

Report · Mar 19, 2009

Terry3 wrote:
> How do I go about doing this manually?

Details of all PHP database functions can be found in the PHP online
documentation at http://docs.php.net/manual/en/refs.database.php.

> I am severely disappointed in DW's
> shortcomings in this area. Even if I set up a legitimate php connection file
> that properly calls the mssql functions, DW won't work with it.

No, of course it won't. The original way that PHP was designed was to
use completely separate functions for each database type. Dreamweaver
chose MySQL, which is the database most commonly used in conjunction
with PHP.

> I tried your link for the wishform, but it came up "Page Does Not Exist." Oh
> well.

I have just tested the link directly from my previous post. It works
just fine now.

--
David Powers
Adobe Community Expert, Dreamweaver
http://foundationphp.com

Report · Mar 19, 2009

Thanks again for your quick replies!

>Terry3 wrote:
>> How do I go about doing this manually?

> Details of all PHP database functions can be found in the PHP online
> documentation at [L=http://docs.php.net/manual/en/refs.database.php.
> http://docs.php.net/manual/en/refs.database.php.

I meant the setting up of a dataset and attaching it to a "connection".

>> I am severely disappointed in DW's
>> shortcomings in this area. Even if I set up a legitimate php connection file
>> that properly calls the mssql functions, DW won't work with it.

> No, of course it won't.

I'm afraid I wasn't clear. I wrote a "connection_mssql_php.php" connection file that is similar to the DW created one for MySql, but mine uses the proper mssql calls. I do database php work with mssql all the time. The new part for me is trying to use DW to set up a Spry table instead of the hard coding table grids I do normally.

>> I tried your link for the wishform, but it came up "Page Does Not Exist." Oh
>> well.

> I have just tested the link directly from my previous post. It works
> just fine now.

I found the problem. The link in your reply includes the period ending the sentence. When I delete that, it works fine. I must have missed that the first time.

Terry