Different DB Connection

[p3t3]

Hi All,

I have three seperate Databases,

Development
Test
Live

And three corresponding web sites...

When coding by hand I had a little include which built the connection string. This was different for each site obviously.

Please can some one tell me how i can do the same thing in dreamweaver MX.

For example, I define a connection, in my development site, which points to my dev DB. Then form a recordset from that and display it. But obviously when i move this to the test enviroment, the connection still points to the development DB.

Surely I dont have to manualy change the connection used everytime i move a page from one enviroment to the next??? ***************************************
SPONSER MY SIGNITURE FOR ONLY $5!!

 

[schase]

actually yes you do

Once you define a site - DW maintains various paths to whatever links you specify. You move a page to another directory - it updates them (well asks you first).

but your question is a bit confusing.

are you working off of the same site defination - or creating a new one?

If your using the same site defination - and are just uploading to a new location - than as far as DW knows - its all the same. (as long as you change the ftp info) "Never underestimate the power of determination"

Stuart

 

[p3t3]

Thanks... quick reply...

ok to clarify.

I have one site definition.

I have three shared drives on my Lan X Y Z, set to the roots of D(ev) T(est) L(ive) respectivly.

In DW sie def then,

My local site is set up as X:My Staging site is Y:\
My live site is Z:
With this set up, I edit on the local site...
then 'put' files to staging site...
then if all ok, 'resync' to live site

following your answer , do you think i should have a different set up then?

All I want is to define once on each site a connection say 'con1' which is different on each site. Now, if i make a page on D featuring a recordset ('rs1'), if i am happy and upload this page to T for user testing then surely rs1 should simply become a recordset based on T's own definition of con1... i.e I shouldnt have to regenerate the page using say 'con2-->T's DB'

??chrz??
***************************************
SPONSER MY SIGNITURE FOR ONLY $5!!

 

[schase]

It has to be because it's all local versus on the net.

It sounds as if you are doing it correctly - trying to make DW believe it's going over the net like a web hosting type atmosphere.

But where its local - It's just making modifications.

Why can't you keep it in Z, but under a test directory - make the site, test and then in DW, move the entire site to z root for final go ahead. "Never underestimate the power of determination"

Stuart