Help... I have spent several hours on this and I cant figure out which way I need to go.

Situation I have a mysql 4.0 (Solaris 8) box that I am attempting to conenct to a MSSQL 2000 system (NOTE: I do not want to do this through php or VB I want to do it via command line) the mysql Dbase I have no problems being the admin and can do most tasks that I need to do. I understand that I need a client or a bridge to do the translation. I have tried installing the JDBC on Microsofts site and following these instructions (Microsofts site doenst tell you JACK) (http://www.akadia.com/services/sqlsrv_jdbc.html) but I also do not know java (I have been trying to set this up but I just can not seem to get it right)

I have been to http://www.unixodbc.org/ and installed the solaris package but I think that this is not the right thing. I have also added the mysql-connector-odbc-3.51.12-sun-solaris2.8-sparc-32bit.pkg package

Is there any step by step instructions on what I need to do???

Thank you for any help

Signed
Lost and confused

can u post the error that u get....
or the step that u hav problem...
have u try run the program in the web??

That is the problem I am not sure which step to do first or even if I am looking at the right thing. Ideally I would think that there is a MSSQL client that connects to the MSSQL Dbase... From there I would extract the information that I need.. Via shell scripting change it to the format that I want it in for mysql and import it into mysql. Maybe I have this totally backwards??

u can follow the tutorials in http://www.akadia.com/services/sqlsrv_jdbc.html ....
it's a complete tutorials... to show how to connect to ms sql using java....