I am attempting to connect with a SQL Server database using JDBC, the database I am attempting to connecto to consists of an area, and regrettably I've no treatments for the title, and so i can't change it out.
The code I am using is:
String jdbcString = "jdbc:sqlserver://" + hostname + ":" + port + ";databaseName=Database Name";
try {
connection = DriverManager.getConnection(jdbcString, username, password);
}
I have also attempted following a instructions this link: http://msdn.microsoft.com/en-us/library/ms378428%28SQL.90%29.aspx by haveing the area inside braces:
String jdbcString = "jdbc:sqlserver://" + hostname + ":" + port + ";databaseName=Database{ }Name";
but that does not appear to operate either.
The mistake message I gee is:
ERROR: Couldn't connect to the database: The connection string contains a badly formed name or value.
I am while using latest JDBC driver from Microsoft.
All of this?
String jdbcString = "jdbc:sqlserver://" + hostname + ":" + port + ";databaseName={Database Name}";