cobom
Posts: 55
|
| Posted: 04/13/2005, 7:28 AM |
|
General question - is there an easy way to change the dbConnection for an entire site? If I move a completed project from one web server to another, along with the database, I get a lot of connections errors on different pages - probably because I use drop downs in the forms that have me select specific connections.
My goal was to have a different development site on another server to continue improving the project, then publish to the main server.
Am I missing something simple here?
_________________
cmckinney@searay.com
Will program for a Sea Ray 680 SS ;} |
 |
 |
marcwolf
Posts: 361
|
| Posted: 04/13/2005, 8:02 PM |
|
Hi.
Well - from my own experiences (and I use ASP) the ODBC connection details are in common.asp.. Which is regenerated each time you do a change to any page.
We have on several occasion moved an application from one location to another without any problems with the database access just by making sure the any connections in the common.asp are changed.
If you use security - you might also look to see where the SERVERURL variable in common.asp is pointing to and change that as well.
What we do is to take a copy of the connection strings and put them into a APPLICATION variable, and then use this application variable for any non-CCS generated accesses.
Like yourself - I have a development version and a live version. Once I have the live version running on the server I only FTP up files that I have generated and changed. NEVER the common.asp file as this contains local information..
Hope it helps.
_________________
' Coding Coding Coding
Keep Those Keyboards Coding.
Raw Code!!!!!!!
|
|
|
|
|
