Announcement

Collapse
No announcement yet.

Microsoft SQL server

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Microsoft SQL server

    I am trying to set up a channel using MS SQL server 2000 as the source. What is the format for the URL of the database reader?

  • #2
    Re: Microsoft SQL server

    jdbc:jtds:sqlserver://TestServer:1433/TestDB

    TestServer: Name of the SQL Server 2000 Server

    TestDB: Database Name

    Default Port is 1433 (Enterprise Manager / Right-click on server / General Tab / Network Configuration / TCP/IP / Properties)

    Comment


    • #3
      I nither connect MS sql server 2000 (personal) nor MS sql server 2005 express edition

      Environment : Windowx XP SP 2, Mirth 1.8.0.4126 , MS sql server 2000 personal editon, MS sql server 2005 express edition.

      For MS sql 2000 personal edition
      Source
      Connector Type : Database Reader
      Driver : SQL Server/Sybase
      URL : jdbc:jtds:sqlserver://localhost:1433/Vijay
      Username: sa
      Password : gateway

      For MS sql 2005 express edition

      I followed the guidelines mentioned in http://www.mirthproject.org/communit...ht=sql+express

      But in both cases i got the same error msg.

      "Could not retrieve database metadata. Please ensure that your driver, URL, username, and password are correct".

      I appreciate if somebody help me.

      Thanks

      Comment


      • #4
        http://jtds.sourceforge.net/faq.html - Connection strings for JTDS
        Jon Bartels

        Zen is hiring!!!!
        http://consultzen.com/careers/
        Talented healthcare IT professionals wanted. Engineers to sales to management.
        Good benefits, great working environment, genuinely interesting work.

        Comment


        • #5
          For me is working

          jdbc:jtds:sqlserver://127.0.0.1:1433/mirth_DB;instance=SQLEXPRESS

          where mirth_DB is db name
          and SQLEXPRESS is instance name

          Comment

          Working...
          X