Only a single store for Database Connection Wizard data???


Author
Message
Sam Tenney
Sam Tenney
StrataFrame User (140 reputation)StrataFrame User (140 reputation)StrataFrame User (140 reputation)StrataFrame User (140 reputation)StrataFrame User (140 reputation)StrataFrame User (140 reputation)StrataFrame User (140 reputation)StrataFrame User (140 reputation)StrataFrame User (140 reputation)
Group: StrataFrame Users
Posts: 70, Visits: 3.5K
I am still a beginner and so I am not sure if the problem I am seeing was caused by something I did wrong or if my complaint is valid, but here is what I am seeing.

While learning StrataFrame I create lots of little applications to test various things.  These applications access lots of different test databases and tables.  Today I made a mistake when I first launched a new test application.  I mistakenly chose the wrong database and table when the Database Connection Wizard ran.  Les Pinter's article showed me how to delete the Connections.dat file and the AppKeys.dat file to force the Database Connection Wizard to run again.  That did cause the wizard to run again, but I was surprised that now the wizard must be run for every test application that I have previously created and for which I have already completed the wizard.

To my surprise I discovered there is only one pair of Connections.dat and AppKeys.dat files that are used by all the applications I have ever run.  And I was surprised to find those files under the Documents and Settings\All Users\... folder on my Windows XP system rather than under my personal documents folder.

Did I do something wrong?  Shouldn't these files relate to only one application?

Sam Tenney

Reply
Edhy Rijo
E
StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Hi Sam,



A trick I have used for this scenario is to just temporarily rename the ConnectionManager.Applicationkey value for one of your connections in the SetDatasource() of the AppMain.vb to force the Connection Wizard to show up.



Also you can create another application with an option to show you the connection wizard like this:



'-- Show the connection dialog and allow a connection to be selected

If MicroFour.StrataFrame.Data.ConnectionManager.ShowAvailableConnectionStrings() Then

'-- Since a connection was selected, then all of the existing dialogs need to be closed

' since their connection is established to the original source.

For Each loForm As Form In Me.MdiChildren

loForm.Close()

loForm.Dispose()

Next



'-- Force the connections to be reset

MicroFour.StrataFrame.Data.ConnectionManager.SetConnections()



End If



Edhy Rijo

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search