Skip to main content
A
Anonymous
June 26, 2010
Question

Connecting to a LIVE mySQL database via Dreamweaver (ASP)

  • June 26, 2010
  • 1 reply
  • 601 views

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

This topic has been closed for replies.

1 reply

B
bregent
Participating Frequently
June 26, 2010

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.

R
roryross
Participant
June 26, 2010

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

B
bregent
Participating Frequently
June 27, 2010

>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.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices