On Friday, March 18, 2016 at 1:05:48 PM UTC-7, Chris Ortman wrote:
>
> I am having the same problem. I am using jruby (jre 1.8) and jdbc ...
>
> require 'sequel'
> require 'sqljdbc_4.0/enu/sqljdbc4.jar'
>
> server_name = "yours"
> user = "YOURS"
> pass = "YOURS"
>
> DB = Sequel.connect
> "jdbc:sqlserver://#{server_name};databaseName=master;user=#{user};password=#{password}"
> DB.fetch("SELECT TOP 5 * FROM INFORMATION_SCHEMA.TABLES").first
> works
> ss = DB['INFORMATION_SCHEMA.TABLES']
>
Providing a String to Database#[] uses a dataset with that SQL, and that
SQL is not a valid query (it's just a qualified identifier). You probably
want:
DB[:INFORMATION_SCHEMA__TABLES]
Thanks,
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
