• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1484
  • 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.

Regards

Martin
0
Martin Cotterill
Asked:
Martin Cotterill
1 Solution
 
Jason C. LevineNo oneCommented:
Martin,

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

I'm trying out using ASP.Net.

Regards

Martin
0
 
fuzzboxerCommented:
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.
0
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
Jason C. LevineNo oneCommented:
Thanks fuzz.  I was hoping he would say PHP :)
0
 
RouchieCommented:
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.

http://www.asp.net/learn/videos/video-49.aspx
http://www.asp.net/learn/sql-videos/video-110.aspx
0
 
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.

Regards

Martin
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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