Skip to main content
A
Anonymous
March 19, 2009
Question

Inserting a MS SQL Server dataset with PHP

  • March 19, 2009
  • 1 reply
  • 978 views
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.
This topic has been closed for replies.

1 reply

N
Newsgroup_User
Inspiring
March 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
A
Anonymous
March 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
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices