DSN set up problem (Classic ASP ~ Remote MySQL)

[technov1king]

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.

[David_Powers]

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.

[technov1king]

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

(after define connection)

[David_Powers]

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.

[technov1king]

I'm not using PHP, so i do not have apache installed.

I'm using ASP (classic) vbscript with IIS

I have given up trying to resolve this strange error and defined a Custom Connection String instead of a DSN.

That is somewhat more difficult and a workaround

So i hope maybe some one still can think of a fix for this problem

[David_Powers]

technov1king wrote:

I'm not using PHP, so i do not have apache installed.

I'm using ASP (classic) vbscript with IIS

Ah, with the reference to MySQL, I assumed you were using the PHP server model.

I haven't used ASP for a very long time, but the connection is still made by the web server rather than Dreamweaver. I don't know the inner workings of IIS, but web servers normally run with limited permissions.

Sorry I can't help any further. However, I'll change the subject line of this thread in the hope of attracting someone with more recent ASP experience (although there aren't many around in this forum these days).

[bregent]

You are on a 64-bit machine so you have two different ODBC admin panels - both a 64 and a 32 bit version. Most likely, DW is launching the wrong one.

[technov1king]

yes! that is probrarly it!

How can you change that?

[bregent]

>How can you change that?

I don't know of any way. And I'm not sure what that would accomplish anyway. DW server behaviors will not work with a ASP/MySQL server model. What are you trying to achieve here?

[technov1king]

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

[bregent]

>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

[technov1king]

The error first arose after installing windows again.

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

[bregent]

Well, at least you know it's not a Dreamweaver issue.

You might be an Administrator, but that doesn't mean you're running with Administrative permissions. Try running %SystemRoot%\sysWow64\odbcad32.exe using the "Run As Administrator" option.