“Unknown host machine name.” on FreeBSD + unixODBC + FreeTDS

Question

I have a Product class and a Tag class which have a many-to-many relationship.

Product.tags gives me the list of all tags for a product.

I have a list of tags as search criteria: ['tag1', 'tag2', 'tag3'].

How can I get a list of products containing at least one tag matching the list?

I can solve this easily using SQL, but I'm not quite sure how to solve it using the ORM way.

matching_products = Product.query.join(Product.tags).filter( ??? ).all()

Solution

I'm now able to answer my own question.

Following a hint from the unixODBC mailinglist 1 I invoked

odbcinst -i -s -f /usr/local/etc/odbc.ini

and now I am able to connect to the server via osql.

Comments

[Daniel Böhmer]

+1 for answering your own question although not very active member of the site. You've got the concept. Thanks!