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



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

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

Here it is

Yep, it looks like

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.

thanks

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!