SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Vista error in SQL Server Management Studio

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Vista error in SQL Server Management Studio
Author Message
ssandu



Joined: 26 Feb 2007
Posts: 95
Country: Romania

Post Vista error in SQL Server Management Studio Reply with quote
After I type SELECT in a query I get the error
Execute ODBC error:SQLExecDirect
[Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error
selectr name, xtype, id
from [mydatabase].dbo.sysobjects
where
xtype in ('U', 'S', 'V', 'P', 'X', 'RF', 'FN', 'TF;, 'IF')
and uid=?
and not (name = 'dtproperties')
and not (name like 'dt%' and xtype='P')
Wed Aug 01, 2007 2:37 am View user's profile Send private message
ssandu



Joined: 26 Feb 2007
Posts: 95
Country: Romania

Post Reply with quote
Look at my Options window


When I try to modify Target Options sometimes I see this


and OK button is disabled
Sometimes I don't get that warning but I get this SQL Assistance options (None)



Wed Aug 01, 2007 4:35 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
You should upgrade to a more recent version of SQL Assistant 2.5.12. The version you have installed is not fully compatible with Vista.
Wed Aug 01, 2007 8:18 am View user's profile Send private message
ssandu



Joined: 26 Feb 2007
Posts: 95
Country: Romania

Post Reply with quote
It's the newest(2.5.12)
I found that if I uninstall and install it on another folder (e.g. SQLAssistant) it's working.
Do you retain after uninstall some information (in registry or else) ?
I've deleted all information from hard disk but only on another folder it's working.
Wed Aug 01, 2007 8:26 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
We don't, but Vista does. It does a lot of stupid things for data caching, configurations caching and other, in order to virtualize the environment and allow different users to run the same programs from "C:\Program Files" folders with their own different settings. So you are observing the impact of bad decisions made by MS developers.
Wed Aug 01, 2007 9:07 am View user's profile Send private message
ssandu



Joined: 26 Feb 2007
Posts: 95
Country: Romania

Post Reply with quote
have you found a workaround for this things on Vista ?
Wed Aug 01, 2007 9:43 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
Which issues specifically are you referring to?
Wed Aug 01, 2007 9:47 am View user's profile Send private message
ssandu



Joined: 26 Feb 2007
Posts: 95
Country: Romania

Post Reply with quote
About what remains on hard drive after unistall.
Thu Aug 02, 2007 1:14 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
Vista maps configuration file settings to multiple entries in the registry, and these entries remain in the registry for undetermined time. I don't know what algorithm it uses to clean up the settings and for how long they remain in the registry.

By the way, we are working on a fix to convert SQL Assistant configuration file to binary format and access it as a binary file, so that Vista couldn't do such things.
Thu Aug 02, 2007 12:44 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
Here is a status update. This issue has been resolved in build 2.5.14. Please download the last upgrade.
Fri Aug 10, 2007 1:34 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.