StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Newbie SetConnection help

Newbie SetConnection help

Kirk M Sherhart — Fri, 27 Mar 2009 17:18:33 GMT

I'm working my way through the tutorials and have hit a snag trying to establish a db connection. If I use the following...

[codesnippet]ConnectionManager.ApplicationKey = "App1";
ConnectionManager.ApplicationDefaultTitle = "App1 Connection";
ConnectionManager.ApplicationDefaultDescription = "This application connection is used by App1";

ConnectionManager.SetConnections();
[/codesnippet]

then the application starts, brings up the Connection Wizard, I enter the Oracle connection info (for TNSNAMES, etc.) and then bombs with the following message

[codesnippet]The program '[2308] App1.exe: Managed' has exited with code -1073741819 (0xc0000005).[/codesnippet]

But, if I use the following...

[codesnippet]
ConnectionManager.ApplicationKey = "App1";
ConnectionManager.ApplicationDefaultTitle = "App1 Connection";
ConnectionManager.ApplicationDefaultDescription = "This application connection is used by App1";

DataLayer.DataSources.Add(new OracleDataSourceItem("", "Data Source=STSGEO;user id=abc;password=xyz;"))
[/codesnippet]

it works! Any help is much appreciated!!!

RE: Newbie SetConnection help

Trent L. Taylor — Fri, 27 Mar 2009 17:18:33 GMT

You are missing the AddRequiredDatasource calls. You have to tell the connection manager what data sources are expected.

[codesnippet]

ConnectionManager.ApplicationKey = "App1";
ConnectionManager.ApplicationDefaultTitle = "App1 Connection";
ConnectionManager.ApplicationDefaultDescription = "This application connection is used by App1";

ConnectionManager.AddRequiredDataSourceItem("", "Oracle Connection",
DataSourceTypeOptions.Oracle, "MyDatabaseName", "This connection is used by App1.");

ConnectionManager.SetConnections();[/codesnippet]

RE: Newbie SetConnection help

Aaron Young — Fri, 27 Mar 2009 15:58:22 GMT

I am no expert on this but it sounds like the Connection Wizard is not saving the connection string. I have seen this before on Vista so, if you are running Vista, try running your application as Administrator and see if the connection string is saved.

Aaron