Results 1 to 4 of 4

Thread: Shell Script & SQL 2000 DB

  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Exclamation Shell Script & SQL 2000 DB

    Hi mates,

    I would like to know how to access a foreign (but in my local network) SQL 2000 DB Server from Linux.

    I want to send requests from a Linux Shell Script to this SQL2000 Database Server

    ----
    Example :
    A shell script is running with some e-mail adresses parameters. How to update a table of a SQL2000 DB Server directly from this script ?
    ----

    Can you help me please ?

    Best regards,

    Alex

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You may have to use ODBC or JDBC to connect to SQL Server.

  3. #3
    Join Date
    Jan 2004
    Posts
    2
    Ah ? Is this method complient with a Unix based Shell script plz ?

    Thanks for your answer

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    ODBC and JDBC are open standards, so I would suppose it should be compliant.

    This might be useful

    http://www.algonet.se/~sommar/mssql/unix.html

Posting Permissions

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