That was it, thank you!
On Friday, March 18, 2016 at 3:14:07 PM UTC-5, Jeremy Evans wrote:
>
> 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.
