Hi there,
I think this is what you're looking for, it was posted on the list a while
ago.
It creates a new datasource via cfform
<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">
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
