Folks,
You might want to bear in mind that it is not good to leave CFregistry
active on a production server......
Regards
Stephen
> -----Original Message-----
> From: Allan Pichler [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 02 January 2001 10:46
> To: CF-Talk
> Subject: RE: Creating Datasources Using CF
>
>
>
> This code has worked fine for me on a windows box!
>
> <CFSET newdatasource = "Whatever">
> <CFSET description = "">
> <CFSET database = "whateverDB">
> <CFSET server = "(local)">
> <CFSET Trusted_Connection = "">
> <CFSET UseProcForPrepare = "Yes">
> <CFSET OEMTOANSI = "Yes">
> <CFSET driver = "C:\WINDOWS\System32\SQLSRV32.dll">
>
> <CFREGISTRY action="SET"
> branch="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI"
> ENTRY="#newdatasource#" type="KEY">
> <CFREGISTRY action="SET"
> branch="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\#newdatasource#"
> ENTRY="Description" value="#description#">
> <CFREGISTRY action="SET"
> branch="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\#newdatasource#"
> ENTRY="Database" value="#database#">
> <CFREGISTRY action="SET"
> branch="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\#newdatasource#"
> ENTRY="server" value="#server#">
> <CFREGISTRY action="SET"
> branch="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\#newdatasource#"
> ENTRY="Trusted_Connection" value="#trusted_connection#">
> <CFREGISTRY action="SET"
> branch="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\#newdatasource#"
> ENTRY="UseProcForPrepare" value="#UseProcForPrepare#">
> <CFREGISTRY action="SET"
> branch="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\#newdatasource#"
> ENTRY="OEMTOANSI" value="#OEMTOANSI#">
> <CFREGISTRY action="SET"
> branch="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\#newdatasource#"
> ENTRY="Driver" value="#driver#">
> <CFREGISTRY action="SET"
> branch="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources"
> ENTRY="#newdatasource#" value="SQL Server">
>
> Allan Pichler
> Machine Dreams Inc.
>
>
> -----Original Message-----
> From: Johan Coens [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 02, 2001 12:29 AM
> To: CF-Talk
> Subject: RE: Creating Datasources Using CF
>
>
> Check the CF Developer Gallery for creating datasources.
>
> Regards,
> Johan Coens
>
> -----Original Message-----
> From: Tan Siew Ling [mailto:[EMAIL PROTECTED]]
> Sent: dinsdag 2 januari 2001 5:01
> To: CF-Talk
> Subject: Creating Datasources Using CF
>
>
> Hi All
>
> Can i write CF codes to create datasources instead of using cold fusion
> admin?
>
> Thanks,
> Siew Ling
>
~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
