Skip to main content
T
technov1king
Participating Frequently
September 3, 2012
Question

DSN set up problem (Classic ASP ~ Remote MySQL)

  • September 3, 2012
  • 1 reply
  • 3374 views

Hi.

I'm on windows 7 64 bit.

I have no trouble setting up a system-DSN to my remote MySQL database in windows. That works.


The problem is when i try to define the connection in dreamweaver;

So when i try to set up the DSN connection in dreamweaver I end up in the exactly the same windows screen as outside dreamweaver, but windows now gives me an error

"You are logged on with non-Administrative privileges. System DSNs could not be created or modified". You must be logged on as an administrator to make these changes."

But this doesn't make sense.

I am logged on as an Administrator. I've started dreamweaver specifically with administrator rights

I've disabled UAC and the windows firewall to try it out. But the error remains.


Very annoying.

This topic has been closed for replies.

1 reply

David_Powers
David_Powers
Inspiring
September 3, 2012

I'm not quite sure what you're trying to do. Dreamweaver's connection to a MySQL database uses the mysql_pconnect() function. It's actually quite an antiquated setup, and not really recommended for use.

T
technov1kingAuthor
Participating Frequently
September 3, 2012

No i am trying to configure the windows dsn, which pops up from dreamweaver.

(after define connection)

David_Powers
David_Powers
Inspiring
September 3, 2012

The way that Dreamweaver connects to a MySQL database is by creating a folder called _mmServerScripts in the root of your testing server. The folder doesn't show up in the Dreamweaver files panel because its name begins with an underscore.

Normally, if you want to connect to a remote MySQL database, you need to define the remote server as the testing server. Dreamweaver then uploads _mmServerScripts to the remote server and connects locally. This configuration was chosen because most hosting companies don't permit remote access to MySQL.

It sounds as though you are trying to connect a local testing server to a remote database. I suspect the problem is that the mysql.php script in _mmServerScripts is running with limited permissions, as is usual within Apache. Even though you're running Dreamweaver as administrator, Apache won't have the same permissions.

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