Connecting to a LIVE mySQL database via Dreamweaver (ASP)

[Guest]

Hi All,

Have a bit of of an issue with connecting to my live database... I've created several sites in PHP and each time its been really easy to set up a connection to the live database (on a shared server), and work using live data... but I can't figure out how to do it when working on an ASP (vb) site!? Can anyone direct my on how to do it please? ... or direct to some documentation on the subject? Cheers!

Regards,

Dan

[bregent]

It's pretty simple:

http://www.sqlstrings.com/mysql-asp-connection.htm

Note that you can not use DW's server behaviors with this model - you will need to code everything by hand.

[roryross]

Sorry for jumping into the thread with a bit of an off topic question, but how do you find out what kind of a db the asp server is using? I've asked my company's web host a number of times for info/help in getting connected using Dreamweaver so I can redesign our site and I never hear back from them. It's a very specialized web hosting server set up for rubber stamp web sites. Looks like most of their customers use the online website design tool that they provide, but it is very limited in what it can do. Very limited.

They give me ftp access and I've changed what I can on the page, but with out access to the db it's hard to really change the look of the site.

Here's the link:

http://www.tacomarubberstamp.com

[bregent]

>Sorry for jumping into the thread with a bit of an off topic question

Yes, please create a new thread. Hijacking other threads just makes it more confusing to carry on a discussion.

You can probably look at the connection string to see what dbms it's connecting to. BTW, it looks like an ASP.net site, not ASP. I would guess it's using MS SQL Server.

[roryross]

Sorry for Hijacking and thank you for the help. I'll post a new thread.