Can any one tell how to connect Ms access 2010 (.accdb ) database with odbc driver in c# and.NET 4.0 I tried string. Connecting to MS Access 2010 using C#. To install and configure the ODBC driver for Microsoft Access Office Software, you have to download the 64-bit ODBC driver from the ftp files directory of the IBM Websphere database. Download the driver list on to a temporary directory. Now, give the command tar -xvf file_name.tar to untar the files and then placefile_name.tar in the nameof the file selected before as the ftp file. After running the script/setup commands, there are some prompts to follow as to complete the ODBC driver installation. Lastly, you must configure the odbc.ini file. Once the ODBC Driver is installed, edit the system information file, name it odbc.ini, and set or modify the attributes of this file as required. Hi smantha11, Currently Microsoft does not have any 64 bit ODBC drivers available for the Office products. However, as long as the application that you want to connect to is 32 bit, you can use the 32 bit ODBC drivers to create the DSN. To get to the 32 bit ODBC drivers, the 32 bit Data Source administrator must be used. The 32 bit Data Source administrator must be launched directly if you are using a 64 bit OS. The file should be located at the following path: c: windows sysWOW64 odbcad32.exe Hope this helps! You can download the drivers here: This file will add Access to the list of file types in the ODBC administrator. Not sure if its 32 or 64 bit. But it worked on a machine running 64bit Win 7 Hope this helps, Scott P.S. Please post a response to let us know whether our answer helped or not. Microsoft Access MVP 2009 Author: Microsoft Office Access 2007 VBA Technical Editor for: Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports and Queries Hope this helps, Scott Blog: Microsoft Access MVP since 2007.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
September 2018
Categories |