connection to windows pc
at present i have a windows PC with 2 odbc connections 1 to Linux / mysql the other to novell server (micro focus cobol in read only mode) i use access on the windows PC to run query's on novell and write them to mysql on the Linux machine. this is very slow and causes problems because of access limitations. i cant connect the Linux box into the novell server as our IT Manager will not allow this but i can copy the data files to the windows PC first.
How can i connect to the windows PC to access the odbc link on there, and what program would i use for this, would mysql be able to do this? if this cant be done then i can use samba to view the files on the windows PC but then how do i set up an link into the data files (on the windows PC a micro focus cobol driver had to be installed) how would to connect mysql to this ?
thanks in advance for any thoughts anyone has on this.
[warning]I have no experience with this situation.[/warning] Would this be of any use?