Web Hosting Forum | Lunarpages
News: October 6, 2008 - Submit Your Site for the October 2008 Site of the Month!
 
*
Welcome, Guest. Please login or register.
Did you miss your activation email?
October 12, 2008, 09:23:35 AM


Login with username, password and session length


Pages: [1]   Go Down
  Print  
Author Topic: Dreamweaver connection to mySQL database  (Read 530 times)
rcfweb
Newbie
*
Offline Offline

Posts: 2


« on: July 08, 2004, 07:41:18 AM »

Does anyone know much about connecting to a mySQL database using ASP VBScript and Dreamweaver?

I have a connection string which I think works, but everytime I try to connect via dreamweaver, I get an Internal server error.  I know a lot of people prefer to use PHP, but I am not very familiar with PHP and would prefer to use ASP if possible.  I have already conntacted technical support twice and they have tried to help, but it will still not work.

Any help would be greatly appreciated
Logged
Jwink3101
Über Jedi
*****
Offline Offline

Posts: 1838


The one and only.


« Reply #1 on: July 08, 2004, 06:17:17 PM »

I do not really know too much about MySQL and DW but i think i can solve your problem.

In the MySQL part of Cpanel, add your IP address or "%" (no "") to the access host. Try agian.
Logged

-Justin Winokur


"The Music is reversible but time is not. Turn Back! Turn Back! Turn Back! Turn Back!" - Intentional backmasking in ELO's Fire On High.
rcfweb
Newbie
*
Offline Offline

Posts: 2


« Reply #2 on: July 09, 2004, 01:20:12 AM »

This is my connection string

"Driver={mySQL}; Server=localhost; port=3306; option=131072; stmt=;Database=username_dbname; Uid=username_dbusername; Pwd=**********"

As I say, I am almost certain this connection string works ok.  Just to clarify, I am  using the ASP VBScript Server Model in the dreamweaver site definition.   The connection string I have is being inserted into the custom connection dialog in the applications panel in dreamweaver.

I tried the % for the host and also my IP, but this still produced the same errors.

Thanks for the help so far, most appreciated.
Logged
TWebMan
Quantum Encyclopedia Writer
*****
Offline Offline

Posts: 3112



WWW
« Reply #3 on: July 18, 2004, 11:59:43 AM »

"Driver={Mysql};Server=localhost;Database=dbname;UID=dbuser;PWD=password"
Logged

"Computers cause people to make more mistakes than any other invention in history, with the possible exception of handguns and tequila."  - Unknown
"Liberty of any kind is seldom lost all at once." - D. Hume
Every day is an Ode to Joy
The planet will be fine... and so will your site
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.6 | SMF © 2006-2008, Simple Machines LLC

Valid XHTML 1.0! Valid CSS! Dilber MC Theme by HarzeM