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 |