This topic is locked
[SOLVED]

 Change Connection String

2/23/2010 1:14:04 PM
ASPRunnerPro General questions
C
cpoulin author

I created a project using a test database as well as a test DSN. Now I want to bring that project to the production database. But the connection string still has the test DSN in it. I can change the string in dbConnections.asp. But if I change something in the project and do another build, the new build will have the old test connection string. How can I permanently change this? Thanks!

P
paulwebb 2/23/2010

In Events tab; Global Events / After application initialised: copy the connection string (helpfully shown just above the edit area)
strConnection = "....
and change it to point to your 'production' data
I have a copy of my test data connection string as well, and comment out one of them each time I build.

C
cpoulin author 2/23/2010



In Events tab; Global Events / After application initialised: copy the connection string (helpfully shown just above the edit area)
strConnection = "....
and change it to point to your 'production' data
I have a copy of my test data connection string as well, and comment out one of them each time I build.


Perfect! Worked great!