Re: Microsoft SQL Server and the sql contrib

2008-12-19 Thread Tom Emerson
On Tue, Dec 16, 2008 at 1:15 PM, Scott Jaderholm wrote: > I'm trying to use the sql contrib with Microsoft SQL Server Express 2005. I've used the jTDS driver for SQL Server 2005 (not Express) without any problems, so if you still have problems with the Microsoft driver you may want to try that o

Re: Microsoft SQL Server and the sql contrib

2008-12-17 Thread Michael Reid
On Wed, Dec 17, 2008 at 11:00 AM, Scott Jaderholm wrote: > Thanks for the idea. Although those are definitely necessary steps, > unfortunately the problem still persists. > Can you get a similar Java program work correctly? i.e. we want to try and separate if this is specific to JDBC in Clojure

Re: Microsoft SQL Server and the sql contrib

2008-12-17 Thread Scott Jaderholm
Thanks for the idea. Although those are definitely necessary steps, unfortunately the problem still persists. On Tue, Dec 16, 2008 at 5:47 PM, Wayne R wrote: > > Have a look at > http://dertompson.com/2007/10/06/connection-to-mssql-server-express-2005-with-jdbc/ > > Apparently using JDBC with MS

Re: Microsoft SQL Server and the sql contrib

2008-12-16 Thread Wayne R
Have a look at http://dertompson.com/2007/10/06/connection-to-mssql-server-express-2005-with-jdbc/ Apparently using JDBC with MSSQL Express requires some extra setup. On Dec 16, 3:49 pm, "Scott Jaderholm" wrote: > I don't think that's a problem: > user> (. Class (forName "com.microsoft.sqlser

Re: Microsoft SQL Server and the sql contrib

2008-12-16 Thread Scott Jaderholm
I don't think that's a problem: user> (. Class (forName "com.microsoft.sqlserver.jdbc.SQLServerDriver")) com.microsoft.sqlserver.jdbc.SQLServerDriver On Tue, Dec 16, 2008 at 12:21 PM, MikeM wrote: > > To make sure your driver is really on the classpath, try this from the > REPL: > > (. Class (fo

Re: Microsoft SQL Server and the sql contrib

2008-12-16 Thread MikeM
To make sure your driver is really on the classpath, try this from the REPL: (. Class (forName "com.microsoft.sqlserver.jdbc.SQLServerDriver")) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Clojure" group. To p

Microsoft SQL Server and the sql contrib

2008-12-16 Thread Scott Jaderholm
I'm trying to use the sql contrib with Microsoft SQL Server Express 2005. 1. I've included sqljdbc.jar in my classpath. 2. In my namespace I (:require [clojure.contrib.sql :as sql]) 3. I'm defining my database connection as follows: (def db {:classname "com.microsoft.sqlserver.jdbc.SQLServerDri