You don't have to re-start the server if you do two things: first, make sure the
"maintain database connections" checkbox for that ODBC datasource (in the CF
Administrator) is unchecked. And second, use the following function to "flush" the
connection, thus allowing your user to upload the new database.
<cfoutput>
#CFUSION_DBCONNECTIONS_FLUSH()#
</cfoutput>
--------------------------------------------------------------
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--------------------------------------------------------------
> -----Original Message-----
> From: William H. Bowen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 07, 2000 9:43 AM
> To: [EMAIL PROTECTED]
> Subject: Access uploads and Remote CF restart
>
>
> This is a cryptographically signed message in MIME format.
>
> --------------ms1C95003524CA825ECA7335D5
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> De-lurking to ask if/how the can following be done?
>
> Problem:
> I have a client that must upload a database to my server. This
> database is Access97 and contains mission critical data. (This
> database is output from a larger, more cumbersome database that
> the client keeps at his location)
>
> Question:
> Is there a way to remotely stop and restart CF so that this
> client does not need to phone in and tell me when they are
> uploading a new database?
>
> will
>
> --
> William H. Bowen
>
> misterbowen.com
> *Web Design Solutions for Business*
>
> [EMAIL PROTECTED]
> http://www.misterbowen.com/
>
> 425.423.0794 Voice
> 425.740.0183 FAX
>
> ICQ#: 2062149
>
>
> --------------ms1C95003524CA825ECA7335D5
> Content-Type: application/x-pkcs7-signature; name="smime.p7s"
> Content-Transfer-Encoding: base64
> Content-Disposition: attachment; filename="smime.p7s"
> Content-Description: S/MIME Cryptographic Signature
>
> MIIH8AYJKoZIhvcNAQcCoIIH4TCCB90CAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCC
> BcEwggKlMIICDqADAgECAgMBZ1kwDQYJKoZIhvcNAQEEBQAwgZQxCzAJBgNVBAYTAlpBMRUw
> EwYDVQQIEwxXZXN0ZXJuIENhcGUxFDASBgNVBAcTC0R1cmJhbnZpbGxlMQ8wDQYDVQQKEwZU
> aGF3dGUxHTAbBgNVBAsTFENlcnRpZmljYXRlIFNlcnZpY2VzMSgwJgYDVQQDEx9QZXJzb25h
> bCBGcmVlbWFpbCBSU0EgMTk5OS45LjE2MB4XDTk5MDkxNzE1Mjg0MloXDTAwMDkxNjE1Mjg0
> MlowRjEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEjMCEGCSqGSIb3DQEJARYU
> d2lsbEBtaXN0ZXJib3dlbi5jb20wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAOlzm9u0
> WrSTiSs5uemdEFoljOltJYrtMmJt7e3A1BkYagk+fj/tNaovsW6GvcVnG68ABiBLZKNJ4DGH
> +uFPxfG9aEdFKats99IdiVQBz4qC1ry7Wbouj+yaW6tO/VpS8QKv2dk3o0EbFn3Yk8PzXWOd
> s6+rFWA9bxuFvV95ZkwPAgMBAAGjUjBQMB8GA1UdEQQYMBaBFHdpbGxAbWlzdGVyYm93ZW4u
> Y29tMAwGA1UdEwEB/wQCMAAwHwYDVR0jBBgwFoAUiKvxYINmVfTkWMdGHcBhvSPXw4wwDQYJ
> KoZIhvcNAQEEBQADgYEAM1GGG2bT8fMPoLz+ZHqqtqTr85taghWnOTF3PjUqaYeanZzBuI29
> fyIYgPZKQoRm3zgdANNU9GaveX9HLc6rStY5pOplLuJuUyoWMlJ/UIXzftTw/89yPmNXAzMN
> ShRzJ68RRGnXoRWYreb/t+HiavJ7Yninpvdfcoq6hwN4Av0wggMUMIICfaADAgECAgELMA0G
> CSqGSIb3DQEBBAUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIw
> EAYDVQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQL
> Ex9DZXJ0aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVy
> c29uYWwgRnJlZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRo
> YXd0ZS5jb20wHhcNOTkwOTE2MTQwMTQwWhcNMDEwOTE1MTQwMTQwWjCBlDELMAkGA1UEBhMC
> WkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTEUMBIGA1UEBxMLRHVyYmFudmlsbGUxDzANBgNV
> BAoTBlRoYXd0ZTEdMBsGA1UECxMUQ2VydGlmaWNhdGUgU2VydmljZXMxKDAmBgNVBAMTH1Bl
> cnNvbmFsIEZyZWVtYWlsIFJTQSAxOTk5LjkuMTYwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJ
> AoGBALNpWpfU0BYLerXFXekhnCNyzRJMS/d+z8f7ynIk9EJSrFeV43theheE5/1yOTiUtOrt
> ZaeSBl694GX2GbuUeXZMPrlocHWEHPQRdAC8BSxPCQMXMcz0QdRyxqZd4ohEsIsuxE3x8NaF
> PmzzlZR4kX5A6ZzRjRVXjsJz5TDeRvVPAgMBAAGjNzA1MBIGA1UdEwEB/wQIMAYBAf8CAQAw
> HwYDVR0jBBgwFoAUcknCczTGVfQLdnKBfnf0h+fGsg4wDQYJKoZIhvcNAQEEBQADgYEAa8ZZ
> 6TH66bbssQPY33Jy/pFgSOrGVd178GeOxmFw523CpTfYnbcXKFYFi91cdW/GkZDGbGZxE9AQ
> fGuRb4bgITYtwdfqsgmtzy1txoNSm/u7/pyHnfy36XSS5FyXrvx+rMoNb3J6Zyxrc/WG+Z31
> AG70HQfOnZ6CYynvkwl+Vd4xggH3MIIB8wIBATCBnDCBlDELMAkGA1UEBhMCWkExFTATBgNV
> BAgTDFdlc3Rlcm4gQ2FwZTEUMBIGA1UEBxMLRHVyYmFudmlsbGUxDzANBgNVBAoTBlRoYXd0
> ZTEdMBsGA1UECxMUQ2VydGlmaWNhdGUgU2VydmljZXMxKDAmBgNVBAMTH1BlcnNvbmFsIEZy
> ZWVtYWlsIFJTQSAxOTk5LjkuMTYCAwFnWTAJBgUrDgMCGgUAoIGxMBgGCSqGSIb3DQEJAzEL
> BgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTAwMDkwNzE2NDMwMVowIwYJKoZIhvcNAQkE
> MRYEFNB2aGIO00MiaNZoccGZxu2lEXmbMFIGCSqGSIb3DQEJDzFFMEMwCgYIKoZIhvcNAwcw
> DgYIKoZIhvcNAwICAgCAMAcGBSsOAwIHMA0GCCqGSIb3DQMCAgFAMA0GCCqGSIb3DQMCAgEo
> MA0GCSqGSIb3DQEBAQUABIGAA5lqE75wIjfmvtHh8Kfsj0yZRyABkLbWM9DQ4ELY7F90xTQA
> jTMM70RQPJ+IO0s0SBrTL9qZY1Ny65cWWZvNEj4PVTlHsSMyrThrqtYSRtELXHIkRSyRN1J/
> +UNiRXK8QAHMv4aH/M/cqXco4x6qsnmksPBWACvxYXr18ispvMs=
> --------------ms1C95003524CA825ECA7335D5--
>
> ------------------------------------------------------------------
> ------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
