I'm pretty sure ThinkingSphinx only works with MySQL and Postgres right now unless someone's written other adapters.
I've been intending to write one for SQL Server, but ran into an issue with SQL Server lacking a few functions MySQL has built-in and Postgres can easily include with stored functions. The main one being a comparable function for MySQL's GROUP_CONTACT function. If you'd like to take a stab at writing an adapter for it, I think the Postgres adapter is actually a bit closer to what you'd need than the MySQL one. In the gem source for TS just look in the lib/thinking-sphinx/adapters directory. -Wade Winningham On Tue, Jul 28, 2009 at 10:48 AM, Tonkatsufan<[email protected]> wrote: > > Hi, > > I have a running Rails 2.3.2 application on a Ubuntu box connected to > a SQL-Server 2005 database via UnixODBC/FreeTDS. I set up my Rails' > database.yml accordingly and can read and write to all tables. Of > course, tsql and isql also work on my unix machine, so the connection > to the SQL-Server is working as it should. > > Now, I tried adding Thinking Sphinx for fulltext search to my Rails > app. Therefore, I compiled Sphinx 0.9.9-RC2 with unixodbc support. > > I set up the model with a define_index like described in the docs and > ran rake ts:in which produced the following error: > > (in /var/www/r_tools) > Generating Configuration to /var/www/r_tools/config/ > development.sphinx.conf > Sphinx 0.9.9-rc2 (r1785) > Copyright (c) 2001-2009, Andrew Aksyonoff > > using config file '/var/www/r_tools/config/development.sphinx.conf'... > FATAL: no indexes found in config file '/var/www/r_tools/config/ > development.sphinx.conf' > > here is the generated conf file: > > indexer > { > } > > searchd > { > listen = 127.0.0.1:3312 > log = /var/www/r_tools/log/searchd.log > query_log = /var/www/r_tools/log/searchd.query.log > pid_file = /var/www/r_tools/log/searchd.development.pid > } > > It seems Thinking Sphinx was not able to set up a configuration for my > scenario. What do I need to do in order to make this work? Apparently, > having a working connection in Rails / ActiveRecord does not mean TS > will also be able to use that connection for configuring. But where > and how do I set up Thinking Sphinx in a way that uses odbc ? > > Thank you for any help! > Toni > > > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
