Cheat Sheet for the Microsoft SQL Server JDBC Driver

Class: com.microsoft.sqlserver.jdbc.SQLServerDriver

URL Format: jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]] (ex.: jdbc:sqlserver://localhost;databaseName=Database1)

http://msdn.microsoft.com/en-us/data/aa937724.aspx

http://www.microsoft.com/downloads/details.aspx?FamilyId=C47053EB-3B64-4794-950D-81E1EC91C1BA&displaylang=en (for Java 5-, like in Progress Sonic ESB 7.7-)

http://www.microsoft.com/downloads/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang=en (for Java 5+)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s