ODBC - seemingly OT but not - honest :)
We are trying to connect our OpenOffice.org clients to our MySQL server, using any technology which works. Some of our clients are Windows (NT and 2K) boxes, the rest are LTSP terminals. First job is setting up the Windows clients. It is very easy to set up a single client using odbc. Once the myodbc driver is installed, it's simply a matter of twiddling the ODBC stuff in the control panel, and then configuring OOo with the new data source. However, this is of little use to us :( We want to implement a system that configures the ODBC connection when a student logs in, so that they are connected to their own database. Since we use Samba as our PDC we should be able to write a script to facilitate this, but... I've googled the web and searched the registry, and everything points to the fact that the details are stored at HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\. However, installing the myodbc driver on another machine and then copying in the ODBC.INI\myconnection registry settings from a machine set up using the control panel does not cause the connection to be available. I suspect there is something else I need to do but I can't find any useful information anywhere :( Does anyone have any ideas? Cheers -- Phil Driscoll
participants (1)
-
Phil Driscoll