-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Here's a question: Why use a datasource at all? You can access MS
Access databases directly using OLE/DB, then you don't need to use a
datasource. You'd have to change your code around, but it seems
worth it. Here's how it would work:
In your application.cfm, do something like:
<cfset DBPath = "d:\inetpub\wwwroot\Data\MyDB.mdb">
Then in your CFQuery blocks do:
<Cfquery name="Whatever"
dbtype="OLEDB"
provider="Microsoft.Jet.OLEDB.4.0"
datasource="#DBPath#"
providerdsn="#DBPath#"
username="Admin"
password=""
>
Now when you need to change databases, just upload it as MyDB2.mdb,
change the application.cfm to point to the new data, and keep going.
Very nice & easy...
Also, odds are you could use more than one database without your host
charging you for another datasource.
Best regards,
Zac Bedell
========================================
Zachary S. Bedell,
Chief Technology Officer,
Adirondack Technologies, Inc.
Please include original message in any replies -- I get a
lot of email every day, and I have a REALLY bad memory...
So I don't always remember everything that was said.
Thanks!
> -----Original Message-----
> From: Guy J. McDowell [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 08, 2000 11:15 AM
> To: CF-Talk
> Subject: Remote DB Alteration
>
>
> Hello CF'ers
>
> Situation:
> Database and sites hosted externally, site created internally.
> Currently if any changes to the datasource's structure are made
> they are made locally and then uploaded to the host, who has to
> shut off the CFServer and restart it. This requires scheduling a
> time and is unacceptable. Also, the uploaded datasource may
> corrupt/overwrite the data as it is not up to date. Employer will
> not spring for extra
> datasources to be hosted. ( multiple applications and domains, one
> datasource, yay! ;) )
>
> Goal:
> To be able to add tables to the datasource without scheduling a
> shutdown and uploading entire datasource.
>
> Resources:
> MS Access 97
> CF 4.5
> CuteFTP
> Budget =$0
>
> Is this possible? Please direct me to resources that will show me
> how.
>
> Also, anyone know what the 20 or so CFML tags supported by
> CFExpress are?
>
> Yours In Conservation,
>
> Guy J. McDowell,
> Webmaster
> The Ontario Federation of Anglers & Hunters
> E-mail: [EMAIL PROTECTED]
> Phone: (705) 748-6324 ext. 262
>
> P.S. You may want to check out the fresh new look of www.OFAH.org
> Launched 1st November 2000.
> Don't forget our other great sites:
> www.AuctionForWildlife.com - Your chance to make your bid for
> conservation.
> www.EcoEd.org - an online adventure for kids in grades 1 through 8.
> www.HuntingDog.org - Celebrating our Hunting Dog Heritage.
> www.AHTV.com - Your online companion to the Angler and Hunter
> Television show.
> www.OHEP.net - Where to find out and learn about the Ontario
> Hunter Education Program.
>
>
>
> --------------------------------------------------------------
> ----------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>
iQA/AwUBOgmJf6vhLS1aWPxeEQLwLgCgi6zwghDm0soeDBmwpRIrj8BJhl4AoPC2
b0yzMCKhohB9mi/vrNSJ56VP
=EhgJ
-----END PGP SIGNATURE-----
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
