Is there a known issue using odbc and sharding under Windows? Currently I'm using jruby and jdbc to connect to a set of MS SQL databases. All works just fine.
However, I also need to use ruby (1.9.2) and odbc instead in some circumstances. I'm using the exact same working code as in the jruby case, but just using odbc instead. So I have a servers hash like: defaultDB = "odbc:///default?user=sa&password=testing" :dsn1 = "odbc:///dsn1?user=sa&password=testing" :dsn2 = "odbc:///dsn2?user=sa&password=testing" Then: DB = Sequel.connect(defaultDB, :servers => servers) But when I then look at DB.servers (using DB.each_server) I get: #<Sequel::ODBC::Database: "odbc:sa:testing@/default"> #<Sequel::ODBC::Database: "odbc:sa:testing@/default"> #<Sequel::ODBC::Database: "odbc:sa:testing@/default"> It seems that all the database connections have been set to the default database. All subsequent code works just fine, except of course it only ever connects to the one database and not the other shards. Thanks, Gary. -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
