StrataFrame Forum

Cannot Access some properties on designer

http://forum.strataframe.net/Topic11356.aspx

By Fabian R Silva, - - 9/5/2007

When I try to change some properties that have a link "..." or some controls that have a arrow to access some properties in designer (like the attachment) I got the message like "implicit convert text to nVarChar not allowed. Use the CONVERT function to execute this query" it seems like a SQL message but I only try to acess to a property Crazy



I not sure if the attachment is the best example, on a strataframe button say "click to setup solution preferences" when I found other example I post in this thread another message, thanks



Fabian
By StrataFrame Team - 9/6/2007

Most likely, you're using SQL Server 2000 to store the SF database.  We initially had problems with SQL Server 2000 because NVarChar(MAX) is converted to NText, but I thought we took care of all of those.

Looking at the query, it uses a LIKE, which is legal between NText and NVarChar, so I'm not sure why it's throwing an error.  Could you get us the SQL Server version info on the server that's housing your SF database?  Thanks.

By Fabian R Silva, - - 9/6/2007

I only see that this error happen, but (almost now) its not a urgent/important thing, I using sql 2000 server to test purposes, but on deployment I think that I will use SQL Server 2005 (Express), I try to install sql 2005 to development (i think a good choice [development = deploy] )



@@Version:

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: )
By StrataFrame Team - 9/7/2007

Yes, if you swap your SF database over to SQL Server 2005 it will fix that problem.  But it should also be working on SQL Server 2000.  If you want to get some more information, you can turn on DebugMode for the SF design-time by setting a couple registry keys. 

HKEY_LOCAL_MACHINE\Software\MicroFour\VSAddIns\DebugMode - DWORD - any value other than 0

HKEY_LOCAL_MACHINE\Software\MicroFour\VSAddIns\DebugFile - String - Full path to the .html file for output

Then, when you get that exception, copy the .html file immediately, zip it and attach it to the forum.  The last command listed will be the one that is causing the problem.

Thanks

By Fabian R Silva, - - 9/7/2007

Here it is Smile
By StrataFrame Team - 9/10/2007

Yep, it looks like

SELECT [pref_pk],[pref_prj_pk],[pref_sproj_pk],[pref_defaultlanguage],[pref_solution],[pref_ApplicationTheme],[pref_CustomThemeFullName],[pref_ShowFullBOName],[pref_created],[pref_Version] FROM [dbo].[DTEPreferences] WHERE pref_solution LIKE @pref_solution

is the one causing the problem.  The @pref_solution parameter is a VarChar, but SQL Server 2000 allows conversion between Text and VarChar if you use LIKE.  Very strange, I'll have to look into this one.  The only workaround for now, Fabian, would be to install a SQL Server 2005 Express somewhere and use it as your SF database.

By Fabian R Silva, - - 9/10/2007

thanks Smile

No problem, I'll export my sql 2000 data to sql 2005 express (I'm installed SF / sql 2005 and deployed the SF on it but need my actual data from sql 2000)



If I can help on the sql 2000 problem contact me when you need.



Thanks!