Greg Hamer wrote: > I am trying to confirm is anyone has ever succeeded using CF on *nix to > connect to Microsoft Access? (Bonus points if it is on Solaris :)
To the best of my knowledge, this can't be done. Access isn't a database. It's a file. The Microsoft Jet Database engine is absolutely required to use an Access database. The Jet database engine is part of Windows. Unless you can find a solaris port of the Jet database engine, you're SOL. > - Java talks to data files using drivers, e.g. JDBC or a JDBC-to-ODBC > bridge > - .MDB is a dumb file format Java does not talk to data files. Java talks to file based datasources, and it talks to database servers via TCP/IP. Accessing an MDB file would be like trying to access an oracle or SQL Server data file directly. You can't do it, you MUST go through the database engine. And that database engine is "Microsoft Jet". Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247962 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
