I just got a hosting account from 1and1 and they don't allow access to sql server using query analyzer or enterprise manager which also means that LLBLGen can't connect to the server either so I've been trying to get my LLBLGen project to work with the new catalog.

I followed the directions and changed the catalog name its accessing using the web.config file but now all of the queries are trying to execute as so: dbo176397624.dbo.User but for some reason it should be dbo176397624.dbo176397624.User.

How can I fix my LLBL Library to remove the [dbo] and replace it with my hosting account username?

I actually figured out that I could change [dbo] to another value in the PersistenceInfoProvider file but now the problem is that my shared hosting sql is setup to be accessed using only the dbname.dbtable instead of dbname.dbowner.dbtable. Is there any way to change this so the query can be created to appear like:

[dbo176397624].[User]

when dbo176397624 is my database name and User is a table name?

Any help is greatly appreciated. thanks.

BTW: I am using self-servicing

-Kas

Use schema name overwriting, similar to catalogname overwriting. See the documentation about schema name overwriting in "Application configuration through .config files"