dendenners
Programmer
Hey there
I need to get a data feed from a sqlserver 6.5 database sitting on a NT 4.0 box, and populate a mysql database (on a pc running red hat 8) with this feed. I have a java program that gets the feed running on a machine running windows xp, but this uses a registry-stored ODBC System DSN which I set up in the control panel. Does anyone know how I'd set up such a DSN or the equivalent on Linux, or is there a different way to access SQLServer 6.5 from a unix machine? By the way I'd be happy to script this job as well if there was some other (non jdbc-odbc bridge) way of accessing SQLServer
Thanks
Denis
I need to get a data feed from a sqlserver 6.5 database sitting on a NT 4.0 box, and populate a mysql database (on a pc running red hat 8) with this feed. I have a java program that gets the feed running on a machine running windows xp, but this uses a registry-stored ODBC System DSN which I set up in the control panel. Does anyone know how I'd set up such a DSN or the equivalent on Linux, or is there a different way to access SQLServer 6.5 from a unix machine? By the way I'd be happy to script this job as well if there was some other (non jdbc-odbc bridge) way of accessing SQLServer
Thanks
Denis
