Both Access 20 are most commonly sold as 32-bit versions. But upon checking the version (File, Account, About Access), I see that it is 32 bit. I had previously installed Office 2013, which I assumed was 64 bit. Now I want to connect to it using MS-Access. I restored my application MySQL database in the usual way. MySQL was working fine after the install.I had to install the 32 bit one, discussed below. When you Add a new DSN in the ODBC Manager, this driver appears as "Microsoft ODBC For Oracle". It also seems a little buggy - not for sure on that one. That's nice, but the ODBC driver it installs seems to be the 64 bit one, so it will not work with 32 bit MS-Access. This allows you to install both the database and ODBC drivers all at once. I installed the latest version of MySQL, 5.6, using the All In One package install. I bought a new Windows 7, 64 bit laptop, and I have an app which relies on MS-Access using MySQL tables. Finally got it working, and here are the lessons I've learned along the way: the bit version of the ODBC Manager you used to set it up.įor those of you trying to connect MS-Access to MySQL on a 64 bit Windows system, I went through sheer torture trying to get it to work with both MS-Access 2010 and MS-Access 2013.the bit version of the ODBC Driver you are using.You get this exact same error when trying to connect to a MySQL database from MS-Access when the bit version (32 vs 64) of Access doesn't match ResultSet results = myStmt.executeQuery("SELECT * FROM People") String query = "INSERT INTO People(ID, Name, Surname, Age, Contact, Location, Course) VALUES" Statement myStmt = dbConnection.createStatement() String sourceURL = new String("jdbc:odbc:myDatabase") Ĭonnection dbConnection = DriverManager.getConnection(sourceURL,"admin","") : The specified DSN contains an architecture mismatch between the Driver and ApplicationĬlass.forName("") I am using ODBC and I'm getting this exception: I'm trying to connect to a database made by MS Access using Java, but I cannot seem to manage.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |