Mark
Thanks for the help, I'll give it a go providing this ISP hasn't
disabled CFRegistry.
Thanks
Tristram Charnley
--------------------------------------
Allaire Certified ColdFusion Developer
e-mail: [EMAIL PROTECTED]
> -----Original Message-----
> From: Mark Smeets [mailto:[EMAIL PROTECTED]]
> Sent: 12 June 2001 16:45
> To: CF-Talk
> Subject: RE: Write your own DSN
>
>
> 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">
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
