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
