HABTM and has_many through only work in one direction

rubyonrails-talk
1

I have two models that have a habtm relationship and it only seems to be working in one direction.

The two models are "recipe" and "msn_lifestyles_feed" with a join table called "msn_lifestyles_feeds_recipes"

the tables for msn_lifestyles_feed and msn_lifestyles_feeds_recipes are in the same database and the recipe table is in a completely different database.

When I create a recipe object, it works fine and I can see all the feeds that it's a part of but when I create a feed object and try to access all its recipes I get an error saying:

OLE error code:80040E37 in Microsoft OLE DB Provider for SQL Server    Invalid object name 'dbo.msn_lifestyles_feeds_recipes'

I've also tried this using has_many :through and I get the same error. Any help on this would be greatly appreciated.

2

Nm, found the solution after two days of pounding my head against my desk.

It turned out the problem had to do with the use of two different databases.