NEWBIE - Getting error

StrataFrame Forum

NEWBIE - Getting error

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

By Kelvin Gerhart - 2/14/2007

Hi

I get the following error when trying to run the samples or demos. Why can't I logon to the database? How should permissions be set.

Also can your product build a app to work in a offline mode?

How can I build 3-tier applications using StatraFrame?

Thanks

Kelvin BigGrin

ApplicationException
An error occurred while creating the main form
TargetInvocationException
Exception has been thrown by the target of an invocation.
SqlException
Cannot open database "StrataFrameSample" requested by the login. The login failed.
Login failed for user 'ITLCORP.COM\kjg'.

Source : MicroFour StrataFrame UI

Stack Trace:
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)
   at MicroFour.StrataFrame.Data.SqlDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)
   at MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(String Statement, OnChangeEventHandler CallBack)
   at MicroFour.StrataFrame.Data.DataLayer.GetDataTable(String Statement, Boolean RegisterNotification)
   at MicroFour.StrataFrame.Business.BusinessLayer.FillDataTable(String SelectStatement)
   at ChildDialogFormCSharpSample.CustomersBO.FillTop100Customers() in C:\Program Files\MicroFour\StrataFrame\CSharp Samples\ChildFormDialog\ChildDialogFormCSharpSample\CustomersBO.cs:line 70
   at ChildDialogFormCSharpSample.ParentForm..ctor() in C:\Program Files\MicroFour\StrataFrame\CSharp Samples\ChildFormDialog\ChildDialogFormCSharpSample\ParentForm.cs:line 19
   at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
   at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
   at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
   at System.Activator.CreateInstance(Type type, Boolean nonPublic)
   at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
   at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
   at MicroFour.StrataFrame.Application.StrataFrameApplication.RunApplication()

By Greg McGuffey - 2/14/2007

Kelvin,

I'm just a slightly more experienced user than yourself, but I thought maybe I could get you started. The developers are likely knee deep attempting to get a new version out today(ish).

Why can't I logon to the database? How should permissions be set.

Nothing special about access to the database. Make sure the database was created and that you have access via your windows login (ITLCORP.COM\kjg, from error message provided). I'd say when just starting out, make yourself the dbowner of the StrataFrameSample db (though I doubt this is necessary) just to get it working. Later you can trim down permissions as needed.

Also can your productbuild a app towork in a offline mode?

There is nothing built into SF to provide offline capabilities. However, I believe I've heard of users using SQL Server 2005 Express to do this, then they used replication to synchronize the data. The business objects don't care where the database is and you can change the connection on the fly if needed. You'd have to code the logic to take user off/on line and to handle replication though.

How can I build 3-tier applications using StatraFrame?

The new release (the one they are working on to release today(ish)) will have a new product, the Enterprise Server. It provides middle tier data access via a web service. And to use it with an exiting SF application, you need to change one line of code (according to the developers). Thus to build a 3 tier, you'd just build your normal app, then install the Enterprise Server (and pay for licensing fees) and change the data source to point the Enterprise Server web service. There is a white paper around here somewhere that explains it, plus a number of forum posts. Search for Enterprise Server across all forums.

Hope that helps! The developers will likely respond sometime today also.

Cheers!

Greg

By Trent L. Taylor - 2/15/2007

The error you are getting is because the APplicationKey for StrataFrameSample has already been entered at some point when prompted. The information provided failed to authenticate. You can just remove the ConnectionData altogether and the sample will automatically prompt you for this again. To remove delete the .DAT files in the following folder:

C:\Documents and Settings\All Users\Application Data\MicroFour\ConnectionData

Just delete the AppKeys.dat and Connections.dat files and then run the sample again. You MUST have installed the StrataFrameSample database otherwise the samples will not properly execute. Use the SQL Server to which you installed StrataFrame.

Also can your product build a app to work in a offline mode?

THis would require that you serialize your BOs to disk and then restore them. So it is possible and the BOs already have this type of functionality available, but will require some effort on your part to implement within your application.

How can I build 3-tier applications using StatraFrame?

Purchase the Enterprise Server and you can do this in one line of code. http://www.strataframe.net/enterpriseserver.aspx