Invalid Object name error

Posts   
 
    
fox88
User
Posts: 1
Joined: 05-Jun-2009
# Posted on: 05-Jun-2009 13:39:57   

I have been using LLBLGen Pro 2.6 for a few months without any issues, last few days however been experiencing some strange errors.

I have a SQL Server 2000 db, simple Client table

Created another table, 'Apple', three fields, AppleID, ClientID, AppleName

Created a relationship between Apple and Client, via ClientID

Refreshed my catalog, re-generated my database code, reloaded my database project

Ran some test code

ClientEntity client = new ClientEntity(1); --> client loads fine AppleCollection apples = client.Apple --> Invalid object name 'AVP.dbo.Apple'

Really stumped here, I have been creating lots of client child tables before and they still work no problem, just any new ones I add I just get "Invalid object name 'AVP.dbo.NEWTABLE'"

I have been messing around with sourcesafe lately, so that could be the cause. However I have removed all source control from the project, and marked every project file to be writable.

I have also tried deleting all the code from the database project so I am 100% sure I am using the re-generated code, but still the error persists.

I have attached the error with full stack trace.

Help!!


EDIT

MODS, please delete

My connection string was wrong,

I drank too much beer last night, including a 750ml bottle of Belgian Tripple Ale @ 9.5%

Now, where's my dunces hat

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39859
Joined: 17-Aug-2003
# Posted on: 05-Jun-2009 14:08:45   

fox88 wrote:

Help!!

EDIT MODS, please delete My connection string was wrong, I drank too much beer last night, including a 750ml bottle of Belgian Tripple Ale @ 9.5%

I hope your head doesn't hurt wink

triple is indeed sometimes a tad much, though the best beer from belgium I've ever tasted was Bush, which is also the strongest beer htere is (15%). If you ever ran into a bottle of that, don't hesitate to taste it simple_smile

Frans Bouma | Lead developer LLBLGen Pro