Results 1 to 4 of 4

Thread: T-sql + Jsp

  1. #1
    Join Date
    Jan 2003
    Posts
    1

    Unanswered: T-sql + Jsp

    Does T-SQL work with JSP? i know T-SQL supports ASP

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320

    Re: T-sql + Jsp

    Originally posted by superstardom
    Does T-SQL work with JSP? i know T-SQL supports ASP
    The question is is Ms Sql server support jdbc

    yes for ms sql 2000
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Jan 2003
    Location
    KL, Malaysia
    Posts
    38
    yes it does. Both MS SQL 7 + MS SQL 2000 supports JDBC.

    Put your T-SQL statements in a store-proc.

    You can use the CallableStatement interface to call the stored-procedures

    http://java.sun.com/j2se/1.3/docs/ap...Statement.html

    You can get microsoft type 4 JDBC driver from:
    http://msdn.microsoft.com/downloads/...positedoc.xml.


    Alternatively, you can register your DB under ODBC.

    hope this helps.

  4. #4
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    [SIZE=1]Originally posted by tswern
    yes it does. Both MS SQL 7 + MS SQL 2000 supports JDBC.
    Be carefull only Ms Sql 2000 support JDBC with the Microsoft jdbc driver. With Ms Sql 7 you need to buy an other dirver or try the free jdts driver.
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

Posting Permissions

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