Hi,

I have checked out the forum for a solution to my problem but not found a specific answer that has worked, and as usual I am up against a deadline.

I have generated my SelfServicing interface on my local machine by using the connection details:

login = dbuser and the database is parkins

My shared hosting provider does not allow me to create the same database and logins which is fine, but now when running the app on their server I get an exception

An exception was caught during the execution of a retrieval query: Invalid object name 'dbuser.Role'.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception

Now I see that the login is hard coded in the EntityFieldFactory.cs class, and was wondering if this is the cause of the issue, I could do a paste of the new login in this file, but noted that some people have indicated you can override this in the config files..

Is there a way to override the login used dynamically OR change the login when generating the code?

Many thanks

Richard

Please check the following 2 sections in the LLBLGen Pro Manual:

1- "Using the generated code -> Compiling the code" _you have to copy the generated app.config file to the executable project which references (indirectly perhaps via another assembly) the generated code. If you are developing a webproject, you have to copy the appSettings tag and its contents of generated app.config file to the web.config file of your application, inside the configuration tag. This will make sure the generated code will be able to read the connection string. _

2- "Using the generated code -> Application configuration through .config files" _Catalog name overwriting _

Also to change the dbUser, you may do the following:

1- Open the LLBLGen Pro project file in the designer. 2- Open the Catalog Explorer 3- Navigate to the dbUser node under the schemas 4- Right-Click and Rename the dbUser to the new name 5- Save the LLBLGen Pro in another place (to keep your old project un-altered) 6- Re-genrate the code

You may also rename the catalog in the same way.

Many thanks For information, the catalogue explorer needs a right click to open it via the icon. My drop down menu with catalogue explorer is un selectable..

I WILL take further time to read documentation, but this was a quick fix, so many thanks

Richard