T
tomb1818
Guest
I started my day yesterday looking towards using a MS Access database from my C# windows forms application. What I found is a horror story.
Apparently you cannot use ODBC or OlleDb to access a 32 bit ms access database from a pure 64 bit application. You need to use 64 bit drivers. In fact you cannot even install the drivers unless you migrate 32 bit office to 64 bit office.
This means that clients of mine that run a 64 bit version of my application would need to upgrade their copy of Office but many of my clients also need to connect to a different 32 bit installation of access from another product.
So to put a long story short, where can I find a database that I can use WITHOUT ODBC ?
The same goes for MySQL. What were these developers thinking??? (MS of coarse).
I cant go ahead and ask my people to install sqlserver or Oracle.
Any suggestions?
Continue reading...
Apparently you cannot use ODBC or OlleDb to access a 32 bit ms access database from a pure 64 bit application. You need to use 64 bit drivers. In fact you cannot even install the drivers unless you migrate 32 bit office to 64 bit office.
This means that clients of mine that run a 64 bit version of my application would need to upgrade their copy of Office but many of my clients also need to connect to a different 32 bit installation of access from another product.
So to put a long story short, where can I find a database that I can use WITHOUT ODBC ?
The same goes for MySQL. What were these developers thinking??? (MS of coarse).
I cant go ahead and ask my people to install sqlserver or Oracle.
Any suggestions?
Continue reading...