Log in

View Full Version : ODBC to MS Access on Netware 6


harshap82
Nov 9, 2006, 10:15 PM
Have the following problem:

I want to link a Mysql db on a linux server to a MS Access db on a
Novell
Netware 6 server.

Now it seems tha MS Access requires the Jet engine and Windows client. So is it that Netware will only store the mdb files, but to contact the Access database, one would not be able to do that without the Windows client?

Kindly help me clear myt concepts


Thanks
Harsha

Slogmeister
Jan 9, 2007, 12:43 PM
Yeah, what you're saying doesn't quite make sense. You can't link DATABASES. You can, however, use the Access PROGRAM as a front end to a MySQL database, but it won't be pretty. The Access program only requires the Jet Engine to access it's own databases. It uses OLEDB and ODBC to interface with other databases, but then it's only operating as a FRONT END. Netware should have nothing to do with any of this, aside from operating system authentication. It might be easier if you explain what your goal is, rather than trying to explain the technical concepts behind it - particularly when you're not really confident in them. Understanding how to achieve the goal will iron out the concepts in your head.