title: Connecting to SQLServer using JDBC-ODBC Bridge
body: <p>I'm writing an applicationt hat was prototyped on MySQL and is now connecting to an Oracle database.</p>
  
  <p>All I had to do to connect to the oracle database (having built up the table structure) was change the connection string.</p>
  
  <p>What is the format to connect to a SQL Server DB on another machine?</p>
  
  <p>I've read some tutorials which tell you to use the SQL Server JDBC adaptor but I'd rather configure the application so that it's database agnostic, and just have the connection string specify the protocol etc.</p>
  
  <p>Any references I've seen which tell you how to use the bridge with SQL Server require the ODBC Data Source to be installed, this is less than ideal as my app may run on Linux or windows.</p>
  
  <p>I'm not doing anything complicated just inserts.</p>