asked on

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

Jason C. Levine

Martin,

Which scripting language are you using?

Martin Cotterill

ASKER

Hi J

I'm trying out using ASP.Net.

Regards

Martin

ASKER CERTIFIED SOLUTION

fuzzboxer

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jason C. Levine

Thanks fuzz. I was hoping he would say PHP :)

Rouchie

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

Martin Cotterill

ASKER

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