Database Connection Wizard always shows
 
Home My Account Forum Try It! Buy It!
About Contact Us Site Map
StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      


12»»

Database Connection Wizard always showsExpand / Collapse
Author
Message
Posted 04/11/2008 5:31:02 PM
StrataFrame Novice

StrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame Novice

Group: StrataFrame Users
Last Login: Today @ 10:11:34 AM
Posts: 102, Visits: 229
Hi,

I have a simple one BO, one form project on a Vista 64bit system. When I do an F5, the form runs and the Database Connection Wizard appears. I setup the connection and the form loads and throws an error when I attempt to fill the BO.

The error is:-

DataLayerException
  An error occurred while creating a new DataLayer for the business object.
DataLayerException
  The DataSourceKey [] is not defined.

Each time I do an F5 and run the project, the Database Connection Wizard always displays. From what I have read, it doesn't look like the wizard is saving the connection details as I believe it is supposed to only run the wizard once.

Have I missed something silly?

Thanks,

Aaron

Post #15557
Posted 04/11/2008 5:42:45 PM
StrataFrame User

StrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame User

Group: StrataFrame Users
Last Login: Today @ 3:29:20 PM
Posts: 400, Visits: 1,612
Hi Aaron,

If you are using the SF sample database, try changing the name of the onnectionManager.ApplicationKey in your AppMain.vb class so it will create a new connection record.

This is just a guess



Edhy Rijo
Progytech (Computer Consultants)
Post #15558
Posted 04/11/2008 6:07:51 PM
StrataFrame Novice

StrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame Novice

Group: StrataFrame Users
Last Login: Today @ 10:11:34 AM
Posts: 102, Visits: 229
Hi Edhy,

Afraid I am using my own database.

Thanks anyway,

Aaron

Post #15559
Posted 04/11/2008 7:31:22 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 11:13:06 AM
Posts: 4,104, Visits: 4,176
Actually it is probably a permissions issue.  We create two encrypted files in the All Users App data folder.  One called Connections.dat and another caled AppKeys.dat.

I am willing to bet that these files cannot be created or properly accessed.  However, this may not be the issue in the sense that the StrataFrame connection and the samples use these same files, so if they work then it may be a matter of setup.

In the case that this is the latter issue, look in your AppMain.vb or progam.cs files and look in the SetDataSources method.  If you are going to let the connection Wizard manage your connections, then you will need to have the Applicationkey as well as define the RequiredDataSources.

So you might let me take a look at your SetDataSources method to see what you have there if you don't get it figured out.

Post #15562
Posted 04/12/2008 3:13:06 AM
StrataFrame Novice

StrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame Novice

Group: StrataFrame Users
Last Login: Today @ 10:11:34 AM
Posts: 102, Visits: 229
You are right - it is a permission problem. Running VS2008 as Administrator and the connection saves and the form works. Running again with normal permissions and the form continues to operate.

Thanks.

Post #15568
Posted 04/12/2008 8:19:36 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 11:13:06 AM
Posts: 4,104, Visits: 4,176
Cool.  Glad it worked.
Post #15569
Posted 04/14/2008 2:16:12 AM
StrataFrame Novice

StrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame Novice

Group: StrataFrame Users
Last Login: 07/01/2008 9:51:35 PM
Posts: 62, Visits: 515
G'day

I have just experienced the same problem. Running as administrator allowed me to continue development and testing, however, my concern is how this will effect deployment of our application.

I prefer to leave permissions as default but I don't want all our users having to have administrator privileges. So is this a case of easing permissions on "C:\ProgramData\MicroFour\ConnectionData" and is there a recommendation of what the permissions should be?

Peter

Post #15582
Posted 04/14/2008 9:31:29 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 11:13:06 AM
Posts: 4,104, Visits: 4,176
So is this a case of easing permissions on "C:\ProgramData\MicroFour\ConnectionData" and is there a recommendation of what the permissions should be?

You don't have to ease permissions on the entire machine.  Technically there should be permissions on this folder anyway for anyone to create, update, and access a file.  So there were actually restrictions placed on this folder or hightened security added via group policies to prevent this access.  You only need to allow permissions to this one folder if you are going to use the Connection String Manager.  The other option would be for us to add a preference so that you can set this folder location (which is truth is not a bad idea) but these would be the only two options.

Post #15585
Posted 04/14/2008 7:51:05 PM
StrataFrame Novice