This topic is locked

DB that blocks connections

9/13/2007 1:58:09 AM
ASPRunnerPro General questions
T
Triel author

Hello,
I am new to ASPRunner and have only one problem. My server will not allow outside computers to connect to MYSQL or MSSQL. This problem had plagued me on most things till Dreamweaver CS3. After my purchase of that software, I also purchased the Developer Toolbox. The tool box allowed me to connect to my databases form any computer I was on (while testing or upating my websites). It does it by uploading a file to my server that allows me to connect through my web server.
Is there anyway to do something like this for ASPRunner Pro?
I have to create a MYSQL and MSSQL database on my local host. After I finish building I upload the files to my server. I have to go into dbconnection.asp and change all the server information. I then have to export my SQL via phpMyAdmin and then quary my server to get the tables correct. Finally, I can go to my url and test the site. Since I am new this takes a very long time building, testing, building, testing, and so on.
If anyone can be of assistance, please let me know.

Sergey Kornilov admin 9/13/2007

Answered to your personal email.

T
Triel author 9/13/2007

Answered to your personal email.


Thank you for the fast response!

S
SteveKincade 3/23/2008

Answered to your personal email.


Hello, Well it's great that there is an answer but considering that this is a forum to help people can you please post the answer here? I would like to work in MSSQL on a remote server but likewise, it is no fun re-creating the database twice and changing the connection string every time I do a build.

Sergey Kornilov admin 3/23/2008

Steve,
if you database don't allow remote connections you don't have any choice but to build application using local database and upload it to the server changing connection string.
You can setup local database the same way you setup remote database to avoid connection string modification.