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?
Announcement
Collapse
No announcement yet.
Microsoft SQL server
Collapse
X
-
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)
-
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
-
Comment