Replacement for OLEDB connection in MX?

[OFAH Webmaster]

My ISP used to have Cold Fusion 5 running on their servers, allowing me to
connect to databases via OLEDB connection: <CFSET DB='C:\Web\Files\DB.mdb'>
<cfquery name='Get_Files' datasource='#DB#' dbtype='OLEDB' username='Admin'
password='' provider='Microsoft.Jet.OLEDB.4.0' providerdsn='#DB#'> SELECT *
FROM Files ORDER BY Num </cfquery> They have since updated to CF Server MX,
thus not allowing me to connect via OLEDB. Is there any way that I can work
around this and still manually connect to databases without a DNS? Any help
would be GREATLY appreciated.:confused;:cool;:confused;

[Mountain Lover]

The unicode driver for Access in CFMX 6 uses JDBC/OLEDB/Jet. So you
could set up a dummy (or live) DSN using the unicode driver and then
query other databases using the IN statement (e.g SELECT * FROM
tablename IN 'path to mdb file') and this, in theory(untested), would be
using the OLEDB driver for all connections.

HTH

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