On Friday, July 20, 2012 2:07:35 PM UTC-7, Duc Qui wrote: > > Ran DB.database_type and got :mssql > > >> How are you creating your db object? > I'm using the following configuration > :adapter => : jdbc > :driver => com.microsoft.sqlserver.jdbc.SQLServerDriver > > L:\sequel>jruby -rsqljdbc4.jar -I lib bin\sequel -E "jdbc:sqlserver://localhost;database=sequel_test;integratedSecurity=true" Your database is stored in DB... irb(main):001:0> DB[:table].select( ['a','b','c'].sql_string_join.as(:test)).sql => "SELECT (N'a' + N'b' + N'c') AS [TEST] FROM [TABLE]"
Can you use Sequel.connect with a jdbc connection string? That's the supported way to use the jdbc adapter. You appear to be using an options hash, but you are only showing a tiny part. If you want help, you need to post your full connection code (only blanking out sensitive stuff like username and password). Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/sequel-talk/-/mIqkJ2XNnpkJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
