Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2005
    Posts
    6

    Unanswered: connecting from Mysql to MSSQL 2000

    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

  2. #2
    Join Date
    Dec 2004
    Location
    Malaysia
    Posts
    24
    can u post the error that u get....
    or the step that u hav problem...
    have u try run the program in the web??

  3. #3
    Join Date
    Sep 2005
    Posts
    6
    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??

  4. #4
    Join Date
    Dec 2004
    Location
    Malaysia
    Posts
    24
    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....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •