Yes there is, I have written some components to do this. What database
server are you using?


The component that I have created currently only supports Access and MS
SQL...

Regards
Andrew Scott
Technical Consultant

NuSphere Pty Ltd
Level 2/33 Bank Street
South Melbourne, Victoria, 3205

Phone: 03 9686 0485  -  Fax: 03 9699 7976   

  _____  

From: Butch Zaccheo [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 3 March 2004 10:21 AM
To: CF-Talk
Subject: DSN Creation on the Fly?

Is there a way to create a DSN without going through ColdFusion
Adminstrator? I have an application which updates our site database from a
database file that is uploaded daily to our server. Problem is, sometimes
the database is locked so the file transfer won�t complete. In this case I
have to rename the database, recreate the DSN and then run the update
application. The upload and update functions are scheduled to run nightly,
so in theory I shouldn�t have even worry about it.

Is there a way to dynamically create or delete a DSN? Or is there a better
way of performing this task than what I have in place?

Access Database
CFMX 6.1

BZaccheo
  _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to