jTDS Connect URL

database-connection jtds
Gary picture Gary · Mar 6, 2012 · Viewed 7k times · Source

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.

Answer

sikander picture sikander · Mar 6, 2012

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.

Related questions

Why am I getting "Cannot Connect to Server - A network-related or instance-specific error"?

I get the following error when trying to connect to SQL Server: Cannot connect to 108.163.224.173. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the …

Read More
MySQL Error: : 'Access denied for user 'root'@'localhost'

$ ./mysqladmin -u root -p 'redacted' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' How can I fix this?

Read More
How to connect to SQL Server database from JavaScript in the browser?

Can anybody give me some sample source code showing how to connect to a SQL Server 2005 database from JavaScript locally? I am learning web programming on my desktop. Or do I need to use any other scripting language? Suggest some …

Read More