Ok, new guy has a problem!

I cannot run the StrataFlix sample. I downloaded and installed ok, I attached the database and built the application per the help file. When I run it, it gives me an error attaching to the database. I can use and select fine from SQL MGR. I have detached and removed the database several times. I have deleted and reinstalled the solution multiple times. I started out with the c# version and tried the vb version with no success.



The instructions say that the first time it runs, it will ask me about the connection info but it never did, it just crashed. Using VS2008, SLQ Express 2008 Named instance. (I even stopped the service for the non-named version just in case, no help). I can access the samples in the tutorial ok, just not StrataFlix. When I open the Business Object Mapper, all of the projects are x'd out. Below is the exception dump.



Thanks!

Bill



System.Data.SqlClient.SqlException was unhandled

Class=11

ErrorCode=-2146232060

LineNumber=65536

Message="Cannot open database "StrataFlix" requested by the login. The login failed. Login failed for user 'WCM-CONSULTING\wcm'."

Number=4060

Procedure=""

Server="wcm1"

Source=".Net SqlClient Data Provider"

State=1

StackTrace:

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.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)

at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

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.QuietOpen(IDbConnection connection, ConnectionState& originalState)

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.DataLayer.GetDataTable(DbCommand Command, Boolean RegisterNotification)

at MicroFour.StrataFrame.Business.BusinessLayer.FillDataTable(DbCommand CommandToExecute)

at MicroFour.StrataFrame.Security.BusinessObjects.SFSPreferencesBO.FillAll(Int32 ProjectPK)

at MicroFour.StrataFrame.Security.BusinessObjects.SFSPreferencesBO.RetrieveSecurityPreferences()

at StrataFlix.AppMain.InitApplication(InitializingApplicationEventArgs e) in D:\MicroFour\StrataFlix\VB.NET\StrataFlix\AppMain.vb:line 103

at MicroFour.StrataFrame.Application.StrataFrameApplication.Raise_InitializingApplication(InitializingApplicationEventArgs e)

at MicroFour.StrataFrame.Application.StrataFrameApplication.RunApplication()

at StrataFlix.AppMain.Main() in D:\MicroFour\StrataFlix\VB.NET\StrataFlix\AppMain.vb:line 21

at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)

at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)

at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()

at System.Threading.ThreadHelper.ThreadStart_Context(Object state)

at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

at System.Threading.ThreadHelper.ThreadStart()

InnerException:

Ok, I think I see the issue after I posted the dump. Too many things names WCM!! It is looking to server "wcm1". I do not know how that go in there. That is the SBS server. The data is on my local workstation, "wcm-01"



Where can I make this change?



Thanks,

Bill

I always get a kick out of guys on a forum having a conversation by themselves and here I am.



Just for the heck of it, I stopped the SQL server service on the SBS server and ran the application again. I received a slightly different error message but basically the same.



Just as a data access test, I create a plain old windows forms application (no Stataframe) and added the database as a data connector to the project and form and drug the customer file to the form. The form runs just fine and I can edit and delete records.



I feel like I should just be able to find an ini file or an xml file where this is saved but I haven't found any yet.



I give up for tonight. 6:00 am comes soon and I am too old for all-nighters!



Thanks,

Bill

Ok, continuing my conversation with myself...



I was able to create my first app working through the tutorials and the data connection form came up like it was supposed to. So I went back to the StrataFlix project and changed the name of the connection in AppMain.vb to xStrataFlix. This forced the data connection form to come up when I ran it and everything is working ok now. Now I just have to go back and find out where this info is saved because is seems to have survived a total uninstall of the sample app and Strataframe.



Bill

Hi Bill.

All of the connection settings are stored in an external encrypted file which you can just delete and when you re-run your application the wizard will automatially appear. These files are located in the following location:

C:\ProgramData\MicroFour\ConnectionData

There are two files, the AppKeys.dat and the Connections.dat. If you delete these any StrataFrame application that uses the Connection String Wizard will automatically show the wizard the next time the app is run...

Cheers.

Hi Ivan,



Thanks much. No wonder I couldn't find them. I installed Strataframe and Strataflix to the d:\microfour directory. I never even considered looking in C:\ProgramData\MicroFour\ConnectionData.



Oh well, live and learn. Where were you at 1:00 am when I needed you?



Bill

Looks like he was slacking off and sleeping!

It is a bad habit, I know!

Trying to get rid of it.