If I use Sequel.odbc('mssql://url') instead of Sequel.connect , then I
got result. But tests use connect method and I don't know how to make
it to enable mssql-adapter2014-03-28 2:27 GMT+04:00 Yaroslav Zemlyanukhin <[email protected]>: > 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 -- --- 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.
