Connect to a MS Access or MS SQL Server database

[Juliano Nunes]

How can i connect and perform select, insert, update and delete commands to an Access or SQL Server database without using ODBC DSNs?

[BKBK]

Register your [url]http://livedocs.macromedia.com/coldfusion/7/htmldocs/00001254.htm[/url]
, like
<cfquery name="myQuery" datasource="myDatasourceName">
select * from myTable;
</cfquery>

[mxstu]

What do you mean "without using ODBC DSNs"? Do you mean using JDBC instead of
ODBC? Or are you talking about DSN-less connections? I think CF5 used to offer
the "connectString" attribute, which allowed DSN-less connections, but I don't
think that is supported in MX6/7. You must register a DSN in the CF
Administrator (as BKBK mentioned), or with MX7 you can create one using the
Admin API. There may be a partial workaround for Access databases, but it
would help if you tell us what you're trying to do.