java.sql.SQLException: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
I get the following error when I try to connect to my Microsoft Access database from an eclipse project using jdbc.
I am using 64bit windows and microsoft office 2007.
any help on this matter would be great.
Access 2010 has 64 bit drivers and can be downloaded http://www.microsoft.com/downloads/details.aspx?FamilyID=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en
64bit applications can t play with the 32bit Jet (Access) drivers. You need to fix this.
Two ways:
The hard, crazy cat lady way is to route the queries through something that can go both ways, such as installing the 32bit version of SQL Server Express, writing stored procedures in it to query the Access database, and then call the stored procedures from your 64bit application.
The easy, "correct", but potentially buggy for a short while way is to download and install the beta version of the Office 2010 Jet drivers (redistributable), which finally support 64bit mode. They can be downloaded from Microsoft here.
I am copying a record from one table to another in Access 2007. I iterate through each field in the current record and copy that value to the new table. It works fine until I get to my lookup column ...
In C#, I know that I can overload the constructor for a class by specifying it in the body of the class: public class MyClass() { public MyClass(String s) { ... } } This overrides the default ...
I have an Access app where I use search functionality. I have a TextBox and a Search Button on the form, and it does a wildcard search of whatever the user enters in the TextBox, and displays the ...
i have two access tables tableA num count 1 7 2 8 3 9 4 9 5 13 6 6 tableB num count 0 1 1 14 2 12 3 5 4 5 5 11 6 5 how can i create an access query that ...
I want to show a dialog where the user can pick a file, click OK, and then the path to the file will be saved in the database. I have just one problem, I can t figure out how tho show the dialog ...
On a continouos form in ms-access, I have a record source similar to select col_1, col_2 & " " & col_3 as col_expr from tblFoo and then I have bound col_expr to a text box on that form....
I have to deal with a few macros (not VBA) in an inherited Access application. In order to document them, I would like to print or list the actions in those macros, but I am very dissatisfied by ...
I have 4 tables, from which i select data with help of joins in select query...I want a serial no.(row number) per record as they are fetched. first fetched record should be 1, next 2 and so on... In ...
