Spring JDBC/C3P0 SQL Server Woes

[immortal_hero]

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.

[immortal_hero]

Figured it out. C3P0 was not giving a very descriptive error message. Switched to Apache Basic Data Source and discovered my driver class was wrong. I had flipped a folder in the package. The proper URL is jdbc:sqlserver://[server]:[port].

[a3g]

Can you please explain steps connecting with MS SQL Server. Please specify jar name, auth dll path, driver class name, url and other property in url. I am stuck there.