Skip to main content
Participant
October 16, 2008
Question

Can dw cs3 connect directly to sql server database without a testing server?

  • October 16, 2008
  • 5 replies
  • 797 views
I'm new to dreamweaver but have used script tools that link directly to my sql server database.
Not in dw, so far. As of this early stage, I don't have or want to use a web server, and it's blocking me
without one. I just want to prototype without a testing server, directly to my database. And while I'll try php
later, I didn't want to have to get into it or cold fusion, etc. right away.

Can dw connect directly to sql server database without a testing server?

I'm running XP sp 3 at this point, and don't see IIS. There's probably some security issues
I'll have to tangle with. The goal is for my website to end up on the company intRAnet, not the www.

fwiw, I can Build in Data Link Properties and get a successful test to my sql server database via
Microsoft Data Link, but once I go back and try the test in OLE DB Connection it balks on the testing server,
as I don't have one locally or otherwise. Isn't there a way to link to db without a testing server?

Thanks for any insights.
This topic has been closed for replies.

5 replies

Inspiring
October 17, 2008
Art wrote:
> You can connect to SQL server using ODBC in windows.

Yes, you can. However, Dreamweaver's PHP server behaviors work only with
MySQL. To connect to any other database, you need to hand code
everything yourself.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
Inspiring
October 17, 2008
You can connect to SQL server using ODBC in windows.


Inspiring
October 16, 2008
jakmon wrote:
> Would you recommend IIS for your basic Windows users?

I use Apache, but IIS is perfectly OK as a web server.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
jakmonAuthor
Participant
October 16, 2008
Thanks for your reply, David. You saved my wall more holes.

I'll hunt around a for a test server.

Would you recommend IIS for your basic Windows users?
Inspiring
October 16, 2008
jakmon wrote:
> Isn't there a way to link to db
> without a testing server?

Not through Dreamweaver, no. You should also be aware that the
Dreamweaver implementation of PHP supports MySQL, not MS SQL Server.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/