This content has been marked as final. Show 2 replies
ODBC is not supported on 64-bit Windows
Convert the Access databases to MySQL and use MySQL
Adobe Community Expert Dreamweaver/ColdFusion
Adobe Certified Expert - Dreamweaver CS3
Adobe Certified Expert - ColdFusion 8
"snovak70" <email@example.com> wrote in message
> I'm hoping someone can help us out here. We are setting up a new web
> that is running windows 2003 64-bit edition and running CF8 Enterprise
> We have serveral clients that use Acess databases for their web sites.
> trying to set up an ODBC connection in the CF Admin I keep getting errors.
> then try to set up an ODBC connection in the Windows ODBC admin and there
> not even an option of Access. From my research, there are no ODBC drivers
> Access in the standard 64-bit environment. (You would think a Microsoft OS
> would be be able to talk to a Microsoft database!) We are running into
> trying to find a work around. Any ideas or suggestions out there!
Thanks for the response Ken. We do have a MS SQL server that we primarily use but the reason for the Access databases is "portability". For example we have a client that downloads an access database and gives it to vendors for use. We need the Access database for the sole reason of portability. I find it hard to believe that a Microsoft OS can not talk to a Microsoft database but that may be the mentality of Microsoft! There has to be some kind of solution out there! Any other ideas out there?