Pragmatically generated database solutions
A great way to add DSN's to Coldfusion, without giving away admin passwords and allowing your customers quickly add a datasource without emailing details across the internet. It also comes with a XML setup file! Before you use the tool below, you have make the swf file swf_builder Copy and Paste these files: PasswordUserNameCheck.cfc, DoesDataSourceExist.cfc, DoesFileExist.cfc, JavaFileDirectoryCheck.cfc, mysql.cfc, unicode.cfc, msaccess.cfc, sqlserver.cfc and point it at your server not locahost. All CFC's are disabled because I did not want people to start adding data sources to my host. Lines 76 through 81 are commented out for my protection.
| STEP 1: Add a dataSource name and file location (ms access) and you are done and data source should be verified. |
|
| STEP 2: If need be, select a different driver |
|
| STEP 3: Fill out form (mysql, sql server) and you are done! |
|
