| | | 
StrataFrame 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 |
| | | | 
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? |
| | | | 
StrataFrame 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. |
| | | | 
Advanced 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. |
| | | | 
StrataFrame 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? |
| | | | 
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. |
| | | | 
StrataFrame 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? |
| | | | 
Advanced 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. |
| | | | 
StrataFrame 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? |
| | |
|