Hello All,

I have generated my LLBLgen project using a remote database on another machine. That all worked fine. When I look at the queries generated by LLBLgen I noticed that the catalog name is included in field and table definitions. As expected the query doesn't run.

Sample output from diagnostics trace

Query: SELECT [BURK].[dbo].[MenuItems].[MenuID] AS [MenuId], [BURK].[dbo].[MenuItems].[MainID] AS [MainId], [BURK].[dbo].[MenuItems].[SeqID] AS [SeqId], [BURK].[dbo].[MenuItems].[Header], [BURK].[dbo].[MenuItems].[Img], [BURK].[dbo].[MenuItems].[ImgMo], [BURK].[dbo].[MenuItems].[PageID] AS [PageId], [BURK].[dbo].[MenuItems].[Link], [BURK].[dbo].[MenuItems].[LinkTarget] FROM [BURK].[dbo].[MenuItems]  WHERE ( ( [BURK].[dbo].[MenuItems].[MainID] = @MainId1)) ORDER BY [BURK].[dbo].[SubmenuItems].[SeqID] ASC
    Parameter: @MainId1 : Int32. Length: 0. Precision: 10. Scale: 0. Direction: Input. Value: 1.

Error:
The column prefix 'BURK.dbo.MenuItems' does not match with a table name or alias name used in the query.

Any ideas how to get rid of these prefixes?

BTW I'm using LLBLgen V2 in Selfservicing mode against a SQL Server 2000.

Thanks,

Willem Jan

Use catalog name overwriting. Please see in the docs: Application configuration through .config files.