programmatically creating a cf5 dsn

[jeramie72]

Hello,

I was curious if there was a way to programmatically create a coldfusion dsn
for a ms sql 2000 database using coldfusion 5.0 code? i have been searching
the forum for a past posting on this subject and haven't found one but i do
appologize if i missed it. I would think i could using cfobject but i would be
very grateful for an example if possible.

thanks a lot,

Jeramie

[Mountain Lover]

it's been a while since I tinkered with this code...and I'll dig a
little deeper if I get time. I think I have some code using cfhttp and
the cf admin. This might get you started...it uses cfregistry:

!--- add the datasource --->
<CFREGISTRY ACTION="SET"
BRANCH="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\odbc.ini\ ODBC Data Sources"
ENTRY="#data_source_name#" TYPE="String" VALUE="SQL Server">
<!--- add datasource key --->
<CFREGISTRY ACTION="SET"
BRANCH="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\odbc.ini"
ENTRY="#data_source_name#" TYPE="Key">
<!--- set the file name --->
<CFREGISTRY ACTION="SET"
BRANCH="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\odbc.ini\ #data_source_name#"
ENTRY="Database" VALUE="#FORM.createDB#" TYPE="String">
<!--- set the description --->
<CFREGISTRY ACTION="SET"
BRANCH="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\odbc.ini\ #data_source_name#"
ENTRY="Description" VALUE="" TYPE="String">
<!--- get the SQL Server Driver --->
<CFREGISTRY ACTION="GET"
BRANCH="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST. INI\SQL Server"
ENTRY="Driver" VARIABLE="gotDriver" TYPE="String">
<!--- set the driver --->
<CFREGISTRY ACTION="SET"
BRANCH="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\odbc.ini\ #data_source_name#"
ENTRY="Driver" VALUE="#gotDriver#" TYPE="String">
<!--- set the server --->
<CFREGISTRY ACTION="SET"
BRANCH="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\odbc.ini\ #data_source_name#"
ENTRY="Server" VALUE="(local)" TYPE="String">
<!--- set the trusted connection --->
<CFREGISTRY ACTION="SET"
BRANCH="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\odbc.ini\ #data_source_name#"
ENTRY="Trusted_Connection" VALUE="Yes" TYPE="String">
<!--- set the last user --->
<CFREGISTRY ACTION="SET"
BRANCH="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\odbc.ini\ #data_source_name#"
ENTRY="LastUser" VALUE="" TYPE="String">

HTH,
Tim
--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]