Can someone dumb down a question about DW and connecting to SQL Server?

Forum|Forum|4 years ago
June 22, 2021
3 replies
593 views

So I have used DW to build asp and .net stuff for years always working with SQL Server. I got the newest version of DW and it does not even have the server behaviors feature installed. Question 1... Is DW no longer interested in allowing us to build sites that connect to a DB or am I overlooking a new and different way to connect to my SQL server without using the server behavior functions?

I installed the server behavior plug-in and it does give me the option to connect to my DB... I set it up and click test and it accesses my SQL server just fine. Now when I try to create a new recordset the minute I click OK dreamweaver completely crashes and I have to restart.

I spoke with DW support and they simply say they don't support server behavior and that I will need to contact the developer of that plug-in for support.

I do not mean this rhetorical but is there no longer a standard way within the stock version of DW to work with my DB? I mean why would they remove that feature unless there is something I am way overlooking.

Any input is greatly appreciated.

This topic has been closed for replies.

S

strategypAuthor

Participant

Thank you Jon and Nancy. Ha any idea where I can purchase an old version of DW and just kick it old school? It used to work like a charm for me.

BenPleysier

Community Expert

This is one of the reasons why I jumped ship, I now use Wappler

Wappler is the DMXzone-made Dreamweaver replacement and includes the best of their powerful extensions, as well as much more!

S

strategypAuthor

Participant

Ben I am not familiar with this but looking at the site... It can do semi-visual data driven stuff? All I really want is data in and data out. I'll focus on pretty when I can achieve that. I miss the DW features of creating recordsets, update record, add new record, delete record... I'm not looking to build the next TD ameritrade, just a fairly straight forward data driven site. Please advise and thank you for the suggestion.

Nancy OShea

Community Expert

DW has not supported ASP or server behaviors for many years. Most ASP developers use Microsoft products like Visual Studio Code.

You can use DW if you know how to code manually. Or you can buy 3rd party commercial extensions to help you.

https://www.dmxzone.com/go/33136/dmxzone-database-connector-2

Nancy O'Shea— Product User & Community Expert

S

strategypAuthor

Participant

Nancy - have you used this app? The connections and queries look really cool but do you know if it allows you to drag and drop fields from the DB onto your page like the server behavior thing does (or did when it actually worked) ?

Thanks again.

Jon Fritz

Community Expert

Adobe removed the server connection options when CC came out. The scripts were outdated and no longer considered secure and rather than rewriting them, they chose to drop them.They promised to update and reintroduce them years later, but have since shelved the idea, in favor of fixing bugs and making the program run better in modern operating systems.

The old server behaviors are no longer compatible with the last few versions of PHP and should be avoided completely. They simply will not work on a server running anything newer than PHP 5.6.

If you have a budget, there are a couple third party extensions that use more modern coding methods (mySQLi and PDO) from DMXZone and WebAssist. Otherwise the only option would be to learn how to write those connection scripts yourself.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded