StrataFrame Forum

BUSINESS OBJECT MAPPER

http://forum.strataframe.net/Topic156.aspx

By John Frankewicz - 11/28/2005

How to use the business mapper?

After adding a Business object to the project I go into the Object mapper.

The first time it asks you to configure the project. You give it a name, and select SQL server.

The system we are testing with is using sql express on (local)\sqlexpress and the database name is TRAC.

Do you have to enter a connection string and if so what is the format?

By StrataFrame Team - 11/28/2005

The connection string is that which is required to connect to the server... not necessarily the database.



So, your connection string would be something like "Server=localhost\sqlexpress;Integrated Security=SSPI;" if you're using Windows authentication or "Server=localhost\sqlexpress;User Id=sa;Password=MyPassword;" if you're using username authentication.



The connection string is required so that the Business Object Mapper can gather the schema information from the server.
By John Frankewicz - 11/28/2005

I guess it doesn't use the previous connection string information you entered?
By StrataFrame Team - 11/28/2005

Nope, it saves the connection string information on a per-project basis. But, yes, it would be a good idea to carry forward the last entered connection string. I'll look into that.