Re: CF MX Access DSN w/o ODBC Service
On 2/9/07, dsmith @ psea. org dsmith @ psea. org [EMAIL PROTECTED] wrote: Is it possible to create an access datasource on 6.1 w/o having the ODBC service running? There appears to be an access native driver but when I try to use it it tells me that the ODBC service isn't running. Thanks, I don't think Java can get to Access without ODBC. The native JDBC driver actually connects to the ODBC service to connect to access, I think. I don't think the JDBC driver included with Coldfusion is actually a Type IV driver, it's only a type 2 driver or something like that, so it requires some native code to get to Access - in this case, the ODBC service. I don't know if I'm right or not, because I haven't used Access in YEARS (it's not suitable for web apps, IMO) There is a pure java Type IV driver available from this company: http://hxtt-access.hongxin-technology-trade-ltd.qarchive.org/ don't know anything about it really though, other than I'd seen it before. Rick -- I'm not certified, but I have been told that I'm certifiable... Visit http://www.opensourcecf.com today! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269400 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF MX Access DSN w/o ODBC Service
I don't know if this is it but have you checked if Coldfusion MX 7 ODBC Server is running In windows: Start Programmes Administrative Tools Services ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269403 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF MX Access DSN w/o ODBC Service
Once upon a time, I seem to remember hearing that you could use OLEDB to connect to access: cfquery dbtype=oledb ... /cfquery However, I've never tried that :). If it works out, let me know. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269405 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF MX Access DSN w/o ODBC Service
Once upon a time, I seem to remember hearing that you could use OLEDB to connect to access: cfquery dbtype=oledb ... /cfquery However, I've never tried that :). If it works out, let me know. OLEDB is not supported in CFMX or newer versions. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269419 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF MX Access DSN w/o ODBC Service
Is it possible to create an access datasource on 6.1 w/o having the ODBC service running? There appears to be an access native driver but when I try to use it it tells me that the ODBC service isn't running. Are you using the Access w/Unicode driver? That doesn't rely on the ODBC services. The regular Microsoft Access driver does, in fact, rely on ODBC. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269420 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
