A typical Access DSNLess connection would be:
Driver={Microsoft Access Driver
(*.mdb)};Dbq=c:\somepath\dbname.mdb;Uid=Admin;Pwd=pass;
or an OLE DB connection would be:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\somepath\dbname.mdb;User
Id=admin;Password=pass;
I have an article at http://www.basic-ultradev.com/articles/ADOConnections/
that has some other connection strings, including Oracle. They apply to
UltraDev, but the connection string is generic and would apply to CF 5 as
well.
tom
"Pete Ruckelshaus" <[EMAIL PROTECTED]> wrote in message
news:3af29c4c$[EMAIL PROTECTED]...
> I installed the RC last night at home and was poking around, and saw this:
>
> "ColdFusion Server 5 extends its database connection attributes to include
> specifying a connection string for ODBC data sources. This allows you to
> specify connection attributes that cannot be defined in the odbc.ini
> settings and also allows you to override odbc.ini settings. The ability to
> make ODBC connections dynamically when there is no data source defined in
> the odbc.ini settings is another important improvement. "
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
