jTDS Connect URL

Question

I am using jTDS to connect SQL Server 2005 Express. My connect url is jdbc:jtds:sqlserver://127.0.0.1:1433/dbstore;user=myusername,password=mypassword

It's not connecting with a "SQL server refusing connection" problem.

Is there something wrong with my code.

This is a simple and valid question, do not understand why is it closed... — lrl, Dec 24 '13 at 18:29

score 5 · Accepted Answer · edited May 23 '17 at 11:58

5

Your connection string is incorrect. The user and password parameters should be separated with a ";" instead of ","

jdbc:jtds:sqlserver://127.0.0.1:1433/dbstore;user=myusername;password=mypassword

Also, there are numerous other questions about jTDS connection strings such as:

Help me create a jTDS connection string

Please search before creating a new question.

edited May 23 '17 at 11:58

Community

1
1

answered Mar 06 '12 at 18:59

sikander

2,286
16
23

jTDS Connect URL

1 Answers1