When I click on the ViewSecurityKey for a Form I get this error...

Any ideas why?

Thanks

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?

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.

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.

This is set correctly to my database server, pointing to the StrataFrame dB.



Any other thoughts?

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.

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?

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.

Well, in trying to get this to work with the dB on the server, I toasted my local copy. Other ideas?

Run?

Well, with the info we have so far I can't think of anything else, but the other guys might do it.