Dynamic database connections and Asp ?

Is it possible to use the "dynamic database connections" for my site made with Asp Vb-Script ?
Or is it possible to use just 1 connection file for my local testing server and my live server ?


Thanks in advance.

No, dynamic connections cannot be used with ASP / VBScript.


the trick I use is to first define the connection to connect to the remote database, upload that to the server and test it to make sure it is working on the remote server correctly. Once the connection is working on the remote server, use an FTP program like FileZilla to connect to your remote server, right click the connection file and remove the check from all 3 users for write permissions. This makes the connection file on the remote server read only.

Now in Dreamweaver edit the connection to connect to the local database.

If dreamweaver tries to upload the connection again, it will fail because the connection on the remote server is read only.

Great trick ... thanks.

Isn't this the same in DW ?
Or do you need another ftp like FileZilla?

yes, on some servers, you can use the DW Set permissions dialogue, but it doesn't always work. If it doesn't work, you will need a dedicated FTP program.

I trust the Dreamweaver File manager as far as I can throw it...

ok ... thanks :)