Microsoft SQL server

[[email protected]]

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?

[nshaik]

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)

[vijaypanchal2006]

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

[jbartels]

http://jtds.sourceforge.net/faq.html - Connection strings for JTDS

[cie779]

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