Skip to main content
Participating Frequently
September 3, 2012
Question

DSN set up problem (Classic ASP ~ Remote MySQL)

  • September 3, 2012
  • 1 reply
  • 3383 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
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.

Participating Frequently
September 3, 2012

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

(after define connection)

Participating Frequently
September 12, 2012

>Yes they do work. I've been using this setup for years now.

OK, so when did this stop working? After upgrading DW to a new version? Installing a new OS?

First thing I would try is to test both odbcad32 utilities and make sure they are working. Then make sure the datasource you need is configured in both.

%SystemRoot%\system32\odbcad32.exe

%SystemRoot%\sysWow64\odbcad32.exe


The error first arose after installing windows again.

The %SystemRoot%\sysWow64\odbcad32.exe gives me exactly the same error as of outside dreamweaver