I am having a problem getting C3P0 (or Apache Basic Datasource) configured to work with SQL server. Does anyone have an example? I am interested in how the URL needs structured. I expected it to be: jdbc:sqlserver://[host]:[port]/[database] is this correct? Does the instance need in there somewhere? Example: jdbc:sqlserver://localhost:1433/Northwind.