» Fig Leaf Software Home

We've Got You Covered.

Monday, June 29, 2009

Creating a SQL Server Datasource in JackBe's Presto

Today I went through the interesting process of installing Microsoft SQL Server Express 2008 and connecting it up to JackBe's Presto running on Tomcat.

Here's a few tips:

1) Assuming that you're setting up a development system (like myself) - when installing SQL Server Express 2008, make sure to select the option to install SQL Server 2008 Management Studio. This option is not selected by default and can only (apparently) be installed with the default instance. If you fail to select this option you must de-install the instance and re-install to get the administrative tools.

2) Install SQL Server to use sql server authentication

3) The SQL Server browser service MUST be running

4) On my Win32 platform, SQLJDBC.JAR, located in Microsoft JDBC Driver installer, seemed to work the best with Presto. This file can be uploaded directly from the Presto GUI depicted below. Note the name of the java class - com.microsoft.sqlserver.jdbc.SQLServerDriver



5) Enter your connection string as follows:

jdbc:sqlserver://localhost;instanceName=SQLEXPRESS;DatabaseName=testdb

No comments:

Post a Comment

About Us

Fig Leaf Software is an award-winning team of imaginative designers, innovative developers, experienced instructors, and insightful strategists.

For over 20 years, we’ve helped a diverse range of clients...

Read More

Contact Us

202-797-7711

Fig Leaf Software

1400 16th Street NW
Suite 450
Washington, DC 20036

info@figleaf.com