Hi Casper Sorry I've not been faster to respond to all your emails... I really do appreciate the effort you've gone to for getting this working.
I'm open to removing the enforced requirement from Riddle for a sql_host - can you confirm what settings an ODBC/SQL Server connection *does* need, at a minimum? Also, if there's other questions you've got that haven't been answered yet, please let me know. Again - Great work! -- Pat On 02/03/2010, at 10:03 PM, Casper wrote: > > Ok. I've gotten a bit further with this thing. The problem now is that > ThinkingSphinx::Source expects the ActiveRecord connection adapter to > contain a magic variable named @config that contains the host, > username, password etc. for the connection. > > I'm using the rails-sqlserver-2000-2005-adapter-2.2.21, and it doesn't > contain this variable. > > Well, no problem I was thiniking - I'll just monkey patch around that. > And I found that the rails adapter contains a similar variable > @connection_options. So far so good. > > BUT! Then Source is trying to configure Riddle in > set_source_database_settings. And here's when I hit the wall. It needs > an sql_host. Since this is an ODBC connection the host property is not > configured in Rails at all. It's configured at the ODBC driver level, > which in Linux happens to be FreeTDS. Rails has no idea where the host > is, it's just connecting to an ODBC datasource provided by FreeTDS. > > Is there any way around this? Pat? Does anyone know? > > Thanks. > > Casper > > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" 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/thinking-sphinx?hl=en. > -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" 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/thinking-sphinx?hl=en.
