StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      


123»»»

Error When Click on ViewSecurityKey....Expand / Collapse
Author
Message
Posted 11/10/2006 9:46:48 AM


StrataFrame User

StrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame User

Group: StrataFrame Users
Last Login: 07/09/2008 2:20:16 PM
Posts: 436, Visits: 944
When I click on the ViewSecurityKey for a Form I get this error...

Any ideas why?

Thanks

Post #4330
Posted 11/10/2006 9:51:31 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Yesterday @ 4:50:35 PM
Posts: 4,796, Visits: 4,766
No...I have never seen this before.  First, you do have solution preferences setup, correct?

Second, what version are you running?  Have you loaded 1.5.1?

Post #4331
Posted 09/23/2008 9:55:34 AM


StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: StrataFrame Users
Last Login: Yesterday @ 1:10:22 PM
Posts: 16, Visits: 53
Hi there,

I don't know if this is the same error, but it seems to fit in this category. I currently get the following error message when clicking the ViewSecurityKey ellipsis button:

"Implicit conversion from data type text to nvarchar is not allowed. Use the CONVERT function to run this query."

Now to qualify this, it had been working correctly. I initially installed StrataFrame with its database on my local SQL Server. However, I wanted all of our development team to use a common database, so I re-ran the install and set it to create and use the StrataFrame database on our database server. I have been able to setup the security on this database, but now I can't set the permissions on the forms using the security keys.

Also, I try going to the Solution Preferences to see the security settings, but the window does not open. No error message, just select the menu option and nothing.

I'm thinking of uninstalling and starting from scratch, but thought I'd see if you had any ideas.

Thanks,
Doug.
Post #19631
Posted 09/23/2008 10:23:57 AM


Advanced StrataFrame User

Advanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame User

Group: StrataFrame Users
Last Login: Today @ 5:03:45 AM
Posts: 809, Visits: 11,674
Hi Doug.

Please, go to the StrataFrame menu on the Visual Studio IDE, choose Database Connection. The StrataFrame Data Store should be selected. You can edit it and make sure that this connection is pointing to the StrataFrame Database in your server.

Post #19632
Posted 09/23/2008 10:42:00 AM


StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: StrataFrame Users
Last Login: Yesterday @ 1:10:22 PM
Posts: 16, Visits: 53
This is set correctly to my database server, pointing to the StrataFrame dB.

Any other thoughts?
Post #19634
Posted 09/23/2008 10:47:19 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Yesterday @ 4:50:35 PM
Posts: 4,796, Visits: 4,766
I tend to lean towards Ivan response in regards to an issue with your SF database.  This is a bit strange

Instead of just giving the error message, please provide the full stack trace so that we can have a better idea of what is going on.

Post #19637
Posted 09/23/2008 11:08:22 AM


StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: StrataFrame Users
Last Login: Yesterday @ 1:10:22 PM
Posts: 16, Visits: 53
This may be a miscommunication. I'm not receiving the error message during runtime. This is a simple message after I have selected the form in Visual Studio, go to its properties and go to the StrataFrame: Security grouping and select the ViewSecurityKey. Is there specific stack trace you are after?
Post #19641
Posted 09/23/2008 11:57:43 AM


Advanced StrataFrame User

Advanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame User

Group: StrataFrame Users
Last Login: Today @ 5:03:45 AM
Posts: 809, Visits: 11,674
In the case you haven't done anything new after moving to the server, you could try detaching the StrataFrame database from the old place, also detaching the StrataFrame database from the server, then copying from the old place onto the server, and ataching it back again.
Post #19642
Posted 09/23/2008 1:42:49 PM


StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: StrataFrame Users
Last Login: Yesterday @ 1:10:22 PM
Posts: 16, Visits: 53
Well, in trying to get this to work with the dB on the server, I toasted my local copy. Other ideas?
Post #19644