Skip to main content
Participant
June 27, 2011
Question

Will DW cs5 connect to a database in SQL server?

  • June 27, 2011
  • 1 reply
  • 1431 views

I work for the government that dictates I use Microsoft SQL server as they do not support php or mySQL.

I need a simple form to collect limited info and display that back for the user.

Dreamweaver is able to accomodate what I need, but I have not been able to get the connections right in order to have my database show up in DW.

IT ensures me this is a Dreamweaver issue as they have tested all the connections and know they are working - and since they don't know Dreamweaver, their answer is for me to drop Dreamweaver and develop the form in Visual Studio which I know nothing about.

I've exhausted every resource and have gone through the connection tutorials on line a dozen times or better and still come up with nothing. Could it be that Dreamweaver cannot connect to a SQL server?

I would appreciate any resources to do this if it can be done, or confirmation that I am not an idiot unable to figure this out but that Adobe Dreamweaver simply doesn't play well with Microsoft SQL Server and I need to learn Visual Studio in order to get along.

This topic has been closed for replies.

1 reply

pziecina
Legend
June 27, 2011

Hi

Unfortunately this feature was removed from dreamweaver in version CS4, so to answer you question, no.

Sorry to give you this bad news.

PZ

c_ayersAuthor
Participant
June 27, 2011

PZ,

Thank you for your response.

I read a prior post by David Powers during my research telling of the functionality for ASP.NET, ASP, JavaScript & JSP still being included in CS5 just disabled. So, as suggested, I used Extension Manager to locate the DisabledFeatures folder and installed it, but I'm having trouble with the connections.

Is that what you were referring to, or will that not solve the issue either.

I'm almost wondering if the php is the issue.

Again, any thougths are welcome as I'm now being directed to begin learning Visual Studio which pains me.

Participating Frequently
June 27, 2011

Enabling the disabled features will probably resolve the connection problem, but keep in mind that even if you get it to work, .NET support in DW was never very good and has not been updated in years. If you know .NET, you can still use DW to write the code manually. But what most folks do is use DW for design and VS for back end coding.

>I'm almost wondering if the php is the issue.

I don't know what you are saying here. Can you explain?