[thelist] ColdFusion hosting

Isaac - have you considered using DSN-less connections on your test pages? 
You can write a simple function that will initiate your database 
connections through a DSN-less interface when on the testing server and 
using a DSN when you specify that you are on your launch server.

That's what I have just started doing to skip paying for extra datasources 
- for instance

ProdServer = 1
IF ProdServer = 1 THEN
         SET Cmd = Server.CreateObject("ADODB.Command")
         Cmd.ActiveConnection = "Aspen"
         Cmd.CommandText = SQL
         RS.Open Cmd, , adOpenForwardOnly
ELSE
         set con1=server.createobject("adodb.connection")
         con1.Open "Provider=MSDASQL;" & _
                 "DRIVER={Microsoft Access Driver (*.mdb)};" & _
                 "DBQ=" & server.mappath("data\aspen.mdb") & ";" & _
                 "UID=;PWD=;"
         Set RS=con1.execute(SQL)
END IF

(Not the world's best code - but it's working for me right now!)





>One thing that I've noticed on a couple of sites that I've checked out is that
>they charge more per datasource added, etc. Since the main domain will 
>also host
>a lot of demos and testing, I need to add datasources fairly often (generally
>just little access ones). Are there any places that charge nothing for 
>this, or
>are fairly cheap?
>
>Thanks heaps for any suggestions/pricing,
>
>
>isaac


Med vänliga hälsningar
Steve Cook: Projektledare
----------------------------------
Skapa Digital Design i Göteborg AB
tel: 031-40 01 50, fax: 031-40 01 53
e-post:   steve.cook@sdd.se
webb: http://www.sdd.se