Where communities thrive

  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
Repo info
    I need to set up a connection with sql server 2008 in rails
    all I want to make is a direct sql connection that I can write sql queries
    I have the database credentials
    would need 1. set up the database connection, 2. sql interface to database
    Benjamin Fleischer
    Going from version 4.2.18 to 5.0.8 (We're of course also upgrading Rails) has broker finder behavior on a table with multiple primary keys, and I'm not sure how to address it. For exampleMyRecord.where(field_name: value).take now fails with ActiveRecord::StatementInvalid:
    TinyTds::Error: Invalid column name '"TicketNo", "UniqueID", "ItemNo"'.: EXEC sp_executesql N'SELECT [Tkscale].* FROM [Tkscale] WHERE [Tkscale].[TicketNo] = @0 ORDER BY [Tkscale].["TicketNo", "UniqueID", "ItemNo"] ASC OFFSET 0 ROWS FETCH NEXT @1 ROWS ONLY', N'@0 nvarchar(max), @1 int', @0 = N'10234770', @1 = 1 which is odd since I didn't ask for the ordering. I'm not sure how to fix this. I have set MyRecord.table_name = 'Tkbatch' and MyRecord.primary_key = :UniqueId. MyRecord.connection.schema_cache.primary_keys("Tkbatch") returns ["TicketNo", "UniqueID", "ItemNo"]. I can't find an issue or in the code where this should be addressed. any ideas?
    I could get around it by setting a default scope with an order but that's kind of a workaround
    Benjamin Fleischer
    @metaskills --^
    I'm just starting out and learning a lot. Is this supported by the latest Active Record?
    John Paul Bamberg
    I'm running ubuntu. The rails 4 app with my config worked on my mac. I'm getting an error:
    "Unable Adaptive Server connection failed (servername.database.secure.windows.net:1433)"
    tiny_tds (2.1.2) lib/tiny_tds/client.rb:60:in 'connect'
    tiny_tds (2.1.2) lib/tiny_tds/client.rb:60:in 'initialize'
    If I look at the username of the opts being passed to connect is has the wrong username. There was an @server automatically appended to it. I don't know if that is what the problem might be?
    Please help. I've been stuck on this for dayyyyssss
    Hello, Wanted to check if there are plans to upgrade openssl to latest version as default i.e 1.1.0f
    Corey Vincent
    Hello I'm trying to connect to a Sql Server that is on a remote windows server, using ruby. I've tried using the gem tiny_tds, but I keep getting a connect server name not founderror. I'm thinking this is just for connecting to a local sql server, and not one that is on a completely different machine. Can anyone point me in the right direction?
    Vincent Smith

    Perhaps I'm missing something, is there a way to define an Identity column that is not a primary key?

    I am working with a legacy database which has some non-PK identity columns. When a performed a schema dump against our development database nothing seems to indicate that these columns are to be auto incremented.

    Oliver Miehe
    Hi, we want to use Ruby 2.6 and tiny_tds is currently only running with 2.5. Do you already know a timeline when we can expect Support for 2.6?
    Thx in advance!
    Eduardo J Moreno M
    I'm working with Windows 10, Ruby 2.6 and already tryed to install tiny_tds with gem install --platform ruby tiny_tds without success. I saw that currently there isn't ruby 2.6 support for this gem. Any workaround so far?
    Rafael Vicente Saura
    hello I have a doubt I need a non relational database for now I am using mongodb and I am happy with it but sql has taken filetables that allows the use of files in the sql Which is better?
    Rob Widmer
    @metaskills We're making an effort to support mssql in jruby and we currently have 2 different approaches that we're trying and we need some input from this project as to what makes sense long term
    I think the preferred method is to have a wrapper around the ActiveRecord-sqlserver-adapter gem that just takes care of the driver specifics, i.e. jruby/activerecord-jdbc-adapter#1008
    But that depends on us being able to get some changes into activerecord-sqlserver-adapter and knowing that there will be support long term
    The other option that has been proposed is basically a fork of the activerecord-sqlserver-adapter into the activerecord-jdbc-adapter gem i.e. jruby/activerecord-jdbc-adapter#1007
    Rob Widmer
    I think it is beneficial for both projects in the long term to go with the first option because then we don't have 2 entirely different implementations of the core of the adapter, but if you think it will be too much work to make it happen, then we can go the "fork" route
    vipul Aggarwal
    is anyone working on this project these days?
    And is @metaskills around?
    folks, re-iterating Eduardo's question above. Any help for installing this for ruby 2.6 ?
    Benjamin Fleischer
    we have it working on Ruby 2.6
    it works fine, no?
    on windows 10 ?
    so still cimplains
    I mean it still complains about being incompatible with ruby 2.6
    yassine ben gharsallah
    Hello guys i have some questions about an sql query could you help me ?
    Hi guys, does this gem work with jdbc as well, or do I have to use 'activerecord-jdbcmssql-adapter' instead?
    Rob Widmer
    Hi @podsi, It depends what version of active record you are using, if you are 4.2 or lower you can use the activerecord-jdbcmssql-adapter gem, 5 or above, we're hoping to have an activerecord-jdbcsqlserver-adapter gem released before rubyconf
    Hi @rdubya, thx for your fast response, we are using activerecord 5.2.3, so I am looking forward to the release!
    David McDonald
    I'm attempting to fix the failing tests on Master. I've gotten them resolved down to just 17 ActiveRecord errors. But I'm new to contributing to projects and alot of this is new to me. I'm getting a lot of messages like "Unfound coerced test: ActiveRecord::AdapterTest#test_select_all_with_legacy_binds" when running "rake test TEST=test/cases/coerced_tests.rb"
    I'm not sure quite how to interpret that
    Enrique González
    hi! i was able to run rails 6 with the github branch 6-0-dev. is there a reason that it is not being pushed to master?
    Titov Andrey

    H everyone:
    I'm experiencing below error altough database.yml stated database different from "master":

    "<username>" is not able to access the database "master" under the current security context

    Any ideas?

    Dale Glaser
    @Enrand22_twitter I would assume it's because there are still tests failing.
    Titov Andrey
    @idrozd upd: added azure: true / solved
    Joseph Haig
    Hi. We are possibly going to be moving some Rails apps to Azure and, as such, could start using an MS SQL server as the database. I have literally just starting playing around with this (thanks for this gem, by the way) and am trying it with a mcr.microsoft.com/mssql/server:2017-latest-ubuntu docker image. Our migrations are failing because at some points we are defining columns as 'bool' which, I see now, is not standard SQL. Is there a way to get the sqlserver adapter to automatically substitute for (presumably) a tiny int or a char?

    NoMethodError: undefined method `alias_method_chain' for #<Class:ActiveRecord::Base>
    Did you mean? alias_method

    i always get this error when i make db with sql server in rails

    Andrew Blignaut
    Hi All, I just recently a pull request to the repo but I see that the build is failing for most open pull requests. What's up? Is anyone actively getting the tests back up and running and reviewing pull requests? Thanks
    anyone got this thing running with rails 6 and ruby 2.7?
    anyone even reading this ? xD
    Andrew Blignaut
    @nemesit - No, we are running rails 5.2 at the moment.
    @AndrewBlignaut_twitter yeah we are too, shame really. do the 5.2 tests for this adapter all pass for you?
    I fixed all the ONLY_SQLSERVER=1 errors for rails 6 dunno bout the activerecord stuff