StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Error with SqlDataSourceItem-Key

Error with SqlDataSourceItem-Key

Thomas Holste — Mon, 09 Aug 2010 15:26:15 GMT

Hi there,

I tried the example found in the help file to manually set up my dataconnection and first tried this:

[CODE]

DataLayer.DataSources.Add(New SqlDataSourceItem("", "SERVER=.\SQL2008EXPRESS;INITIAL CATALOG=MyDB; Integrated Security = True"))

[/CODE]

This works exactly like I expected it. But then I tried to insert a key

[CODE]

DataLayer.DataSources.Add(New SqlDataSourceItem("MyKey", "SERVER=.\SQL2008EXPRESS;INITIAL CATALOG=MyDB; Integrated Security = True"))

[/CODE]

which causes an error when loading a form which uses a businessobject.

Finally I tried it like in the help described

[CODE]

Dim lOSQL As New SqlDataSourceItem("MyKey", "SERVER=.\SQL2008EXPRESS;INITIAL CATALOG=MyDB; Integrated Security = True")

DataLayer.DataSources.Add(lOSQL)

[/CODE]

which is the same but it is split up in 2 lines of code. This caused the error too.

Can somebody help me and tell me what I am doing wrong?

Thanks in Advance

Thomas

RE: Error with SqlDataSourceItem-Key

Greg McGuffey — Mon, 09 Aug 2010 15:26:15 GMT

Thomas, rather than setup it up in the constructor of the BO or using the DataSourceKey of the instance on the form, use the designer of the BO itself (just double click on a Bo, the designer opens, hit F4 (to open properties) and set key there. The it is automatically set whenever it used.

You'd use the form override if a particular form needed to switch data sources or you could use code override if more complicated cases.

RE: Error with SqlDataSourceItem-Key

Edhy Rijo — Sat, 07 Aug 2010 12:26:24 GMT

You are welcome Thomas.

With the DataSourceKey logic, StrataFrame allow us to connect to multiple databases in a single application, this way you can have an application talking by default to MS-SQL and some other business objects talking to MySQL, ORACLE, VFP, Access or whatever without the user knowing it. This is a very, very powerful feature.

RE: Error with SqlDataSourceItem-Key

Thomas Holste — Sat, 07 Aug 2010 02:47:04 GMT

Hi Edhy,

thanks a lot for your help. Adding the datasourcekey did it. Setting it in the property-sheet on the form worked fine and now I'll try setting it in the constructorof the bo.

Best regards

Thomas

RE: Error with SqlDataSourceItem-Key

Edhy Rijo — Fri, 06 Aug 2010 10:54:04 GMT

Hi Thomas,

When using a DataSourceKey in the connection like you are doing, you also have to tell the BO to use that key, so in the BO fill the property DataSourceKey with the value of the key you are using, in this case MyKey