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]

