Thanks Jeremy, It seems to be working now. I noticed two aspects: 1. For odbc-based adapter ruby-odbc gem is required, although you've commented no dependencies required at all 2. Some test are skipped for SEQUEL_MSSQL_URL='odbc://username:[email protected]/azure?db_type=mssql' since condition DB.adapter_scheme == :odbc is true. Is it correct behaviour?
2014-03-28 2:54 GMT+04:00 Jeremy Evans <[email protected]>: > On Thursday, March 27, 2014 3:27:47 PM UTC-7, Yaroslav Zemlyanukhin wrote: >> >> 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? > > > ODBC works on all types of databases, not just MSSQL. You have to tell it > you are using MSSQL. Add ?db_type=mssql to the connection string, hopefully > that should fix it (as mentioned on > http://sequel.jeremyevans.net/rdoc/files/doc/opening_databases_rdoc.html). > > 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.
