• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1487
  • Last Modified:

Cannot connect to SQL database

Hi Experts

I trying to connect to an SQL database.

I have downloaded MS SQL Server Express 2005 and create a database called 'AgentsAndAuthors'.

I am trying to connect to this database from Dreamweaver CS3.

Could someone give me explicit instructions on how to do this?

There seems to be no definitive instructions out there.


Martin Cotterill
Martin Cotterill
1 Solution
Jason C. LevineNo oneCommented:

Which scripting language are you using?
Martin CotterillDabblerAuthor Commented:
Hi J

I'm trying out using ASP.Net.


If you are trying to use ASP.NET with Dreamweaver, you will find it to be lacking in the features that .NET provides.  You will be better off using Microsoft's Visual Web Developer.

Anyways, to answer your question, you will need to setup an ODBC connection.  You can create one of these through DW if you want to.  All you have to do is click on the Databases tab of the Application pane and click Data Source Name.  If the SQL server is on the same machine as your DW, then this will be easy.  Choose "Using local DSN" and then click on the Define button.  This will bring up the ODBC admin window.  Under the User DSN tab, click Add, choose SQL Server and fill out all the info.  Once you are done and back in DW, click on Test and if successful you are good to go!

Now, connecting to a remote DSN is a little bit trickier because you have to setup your server to allow for remote connections and you will need to create a system DSN to allow DW to connect.

Keep in mind that you can skip all of this and use a DSN-less connection, but I find the method outlined above to be much easier.
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Jason C. LevineNo oneCommented:
Thanks fuzz.  I was hoping he would say PHP :)
Fuzzboxer is correct, no version of DW will support ASP.NET.  You need to scrap DW if you are developing for .NET and get Microsoft's free Visual Web Developer software.  There are loads of nice video tutorials on how to get started with it.  Here are two that directly relate to what you need.

Martin CotterillDabblerAuthor Commented:
Hello all

Sorry about taking so long to get back to you. Domesticity called.

I recently did a course on ASP.Net which did use MS Visual Web Developer and MS SQL Server Express.

It's just that I've been using DW for ASP, etc and I decided to have a play and find out hence my question.

BTW J, I'll be having a look at PHP and MySQL soon so be on the lookout.


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now