Re: Accessing SQL Server

From: Philip A. Chapman (pchapman_at_pcsw.us)
Date: 04/19/05

  • Next message: kwhiskers: "Re: multimedia licensing" 
    Date: Mon, 18 Apr 2005 20:50:11 -0500
To: For users of Fedora Core releases <fedora-list@redhat.com>, sundaram@redhat.com

    Richard Crawford wrote:
    > Philip A. Chapman wrote:
    >
    >
    >>I created a java based application that is similar to Query Analyzer that
    >>connect to Microsoft SQL Server 2000 and newer (among other database
    >>variants).
    >>
    >>http://pcsw.us/projects/dbbrowser
    >
    >
    > Philip,
    >
    > Got it up and running (after the standard two hours or so trying to get Java
    > to work), but, sadly, it won't connect to our MS-SQL Server. We're running
    > SQL Server 7, but the only drivers I've been able to find are for SQL Server
    > 2000.
    >
    >

    The jtds driver supports SQL Server 6.5 and better. To use it rather
    than Microsoft's driver, select the "MSSQL Server 2000" provider. On
    the "Database Connection Parameters", unselect "Use Microsoft Driver".
    I haven't tested it since version 0.5.1. However, because of this
    email, I took a few minutes to look at the newest version. It seems to
    work much better.

    Download the latest version of the jtds driver from
    http://jtds.sourceforge.net and store the .jar in the jdbc directory of
    the DBBrowser's install path. Then, either delete or change the
    extension of jtds-0.5.1.jar.

    Once I've finished some other changes and do some testing, I'll try to
    get a new release out there that uses jtds by default rather than
    Microsoft's. I'll get to change the provider name to indicate that
    DBBrowser supports versions prior to 2000. That's great!

    If I can help you any futher, let me know. 

    -- 
Philip A. Chapman
Application Development:
Java, Visual Basic (MCP), PostgreSQL, MySQL, MSSQL
Linux, Windows 9x, Windows NT, Windows 2000, Windows XP



    


    -- 
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: http://www.redhat.com/mailman/listinfo/fedora-list
  • Next message: kwhiskers: "Re: multimedia licensing"

    Relevant Pages

    • Re: jdbc permissions
      ... >When using the SQL Server 2000 Driver for JDBC on a Java ... >the standard security manager enabled, ... Refer to your Java 2 Platform ...
      (microsoft.public.sqlserver.server)
    • Re: microsoft sql server 2000
      ... You can use JDBC drivers to connect to Microsoft SQL servers on OSX, ... or any other platform that supports Java (as long as the driver ... Microsoft provides a pure Java driver. ... supports SQL Server 2000. ...
      (Fedora)
    • Re: Accessing SQL Server
      ... Philip A. Chapman wrote: ... Got it up and running (after the standard two hours or so trying to get Java ... SQL Server 7, but the only drivers I've been able to find are for SQL Server ...
      (Fedora)
    • How use window authentication for JDBC
      ... I want to use window authentication for JDBC connection,but I don't know ... In Mircorosoft 's "SQLServer 2000 Driver for JDBC Help" I view the page ... "When using the SQL Server 2000 Driver for JDBC on a Java 2 Platform ...
      (microsoft.public.sqlserver.jdbcdriver)
    • RE: [dbi] Re: MsSQL DBD::ODBC IsNull and undef
      ... I'd guess this is because the SQL Server ODBC driver is looking at your ... Martin J. Evans ... can you run your test script again but creating an OOB log file ...
      (perl.dbi.users)