Datasource question?

[Komil13]

does anyone know how to create a datasource other than using cfadmin? i saw it somewhere once, but now i can't remember where?

 

[dallasweb]

You create a DSN under control Panel/ODBC if you in a windows environment. This does the same thing that CFADMIN does. Or search for DSN-less connection in this forum.

 

[cfwoohoo]

depending on the rdbms you're using there is a odbc manager which allows you to register your db's (as system/local/etc). The previous post describes the easiest way to register them though.

 

[Komil13]

how would i create a datasource in a coldfusion template or like a setup program??

 

[tleish]

<CF_Datasource>[/u]

http://devex.allaire.com/developer/gallery/info.cfm?ID=9C9C32B0-7F93-11D5-83F300508B94F85A

Description
CF_Datasource allows developers to create, edit, and list ODBC datasource for Access or SQL Server. The tag was previously a commercial tag, and is now free (Open Source Version is still commercial). The tag can be used to automate the creation of a data source, which is useful in applications that allow clients to build their website from a browser. The tag is also useful in management applications, and for deploying web applications that require a datasource.

Tag Syntax
<cf_datasource action=&quot;edit&quot; engine=&quot;access&quot;
dsn=&quot;mydsn&quot; db=&quot;c:\db\new.mdb&quot;>

or

<cf_datasource action=&quot;listall&quot; queryname= &quot;myqry&quot;>
<cfoutput query=&quot;myqry&quot;>
#dsn# - #db# #engine# [COLOR=000080]<br>[/color]
</cfoutput> - tleish