Results 1 to 3 of 3

Thread: Help with accessing MSSQL on Linux

  1. #1
    runnshine NNTP User

    Default Help with accessing MSSQL on Linux

    I am fairly new to Linux and MSSQL,
    1. can we use shell script to connect to and access MSSQL databse.

    2. If we can is it better to use shell script or is it better to use a programming language PERL/JAVA/PHP to do the same.

    Any help is much appreciated

  2. #2
    ab@novell.com NNTP User

    Default Re: Help with accessing MSSQL on Linux

    -----BEGIN PGP SIGNED MESSAGE-----
    Hash: SHA1

    I would guess it depends on what you want to do. There is the JTDS
    open-source JDBC driver on SourceForge that will at least let you make
    the connection but it's just a driver and what you do with it depends on
    your experience, at least at some level, with Java. There are also
    products like DB Visualizer which can use these (and other) JDBC drivers
    to connect to a wide range of databases including Oracle, MySQL,
    PostgreSQL, etc. I believe DB Visuzlizer is entirely GUI-based so that
    doesn't help with your scripting. I'm not sure how you would interface
    at the command line without going through Java, to be honest, but I
    haven't tried.

    Good luck.




    runnshine wrote:
    | I am fairly new to Linux and MSSQL,
    | 1. can we use shell script to connect to and access MSSQL databse.
    |
    | 2. If we can is it better to use shell script or is it better to use a
    | programming language PERL/JAVA/PHP to do the same.
    |
    | Any help is much appreciated
    |
    |
    -----BEGIN PGP SIGNATURE-----
    Version: GnuPG v1.4.2 (GNU/Linux)
    Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

    iD8DBQFIfLfA3s42bA80+9kRAgPZAJ9K6GL5833fzhAE8QswX2XKi50HUACeNmsL
    iE0Tzv6z+t8wWmui7DjxoRA=
    =8TYw
    -----END PGP SIGNATURE-----

  3. #3
    Join Date
    Jan 2008
    Location
    Kenton, TN USA
    Posts
    1,023

    Default Re: Help with accessing MSSQL on Linux

    Thread moved to Applications
    Last edited by kastorff; 15-Jul-2008 at 11:24.
    Keith Kastorff

Posting Permissions

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