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.
