I used tdsodbc + unixobc libs. So I've replaced SEQUEL_MSSQL_URL='odbc://username:[email protected]' with SEQUEL_MSSQL_URL='odbc://username:[email protected]/azure' Where azure is dsn in odbc.ini and it connects. But I got errors like 'Incorrect syntax near 'AUTOINCREMENT'' or unable to find some mssql adapter methods. Seems it uses incorrect adapter. How can I enforce mssql adapter?
2014-03-28 2:14 GMT+04:00 Jeremy Evans <[email protected]>: > On Thursday, March 27, 2014 3:03:10 PM UTC-7, Yaroslav Zemlyanukhin wrote: >> >> Still not clear what should I pass for azure sql storage. >> >> Used >> SEQUEL_MSSQL_URL='odbc://username:[email protected]' >> rspec --color spec/adapters/mssql_spec.rb >> >> And got >> Sequel::DatabaseConnectionError: >> ODBC::Error: INTERN (0) [RubyODBC]No connection >> >> although cli isql works fine for the configuration > > > I recommend using the tinytds adapter (or try JRuby with the sqlserver or > jtds JDBC drivers). The error you are getting is because ruby-odbc can't > connect. I don't think the odbc adapter will work with the connection > string format you are using. > > FWIW, I've only ever used the odbc adapter to connect to something with a > local DSN in windows, though I know people have used it with unixODBC. > > 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 http://groups.google.com/group/sequel-talk. > For more options, visit https://groups.google.com/d/optout. -- --- Best regards Yaroslav -- 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 http://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
