On Tue, Dec 16, 2008 at 1:15 PM, Scott Jaderholm <jaderh...@gmail.com> 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 one.
> 3. I'm defining my database connection as follows:
>
> (def db {:classname "com.microsoft.sqlserver.jdbc.SQLServerDriver"
> :subprotocol "sqlserver"
> :subname "//sqlserver\\sqlexpress" ; this is hostname and instance
> name. I've tried just //sqlserver and sqlserver also
> :user "username"
> :password "password"
> })
I think the problem is that you cannot specify the instance in the
:subname part of the connection parameters. Instead use the
':instance' keyword. For example,
(def db {:classname "com.microsoft.sqlserver.jdbc.SQLServerDriver"
:subprotocol "sqlserver"
:subname "//sqlserver"
:instance "sqlexpress"
:user "username"
:password "password"
})
Failing that, send along a connection string that you would use from
Java and we can figure out how to break it apart into its pieces for
the SQL library.
-tree
--
Tom Emerson
tremer...@gmail.com
http://www.dreamersrealm.net/~tree
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Clojure" group.
To post to this group, send email to clojure@googlegroups.com
To unsubscribe from this group, send email to
clojure+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/clojure?hl=en
-~----------~----~----~----~------~----~------~--~---
