| Author | 
		Message | 
	
	
		
			ssandu 
			 
			
  
			
			
				Joined: 26 Feb 2007 Posts: 95 Country: Romania | 
			 
			  
		 | 
		
			
				  Vista error in SQL Server Management Studio | 
				     | 
			 
			
				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 | 
		          | 
	
	
		  | 
	
	
		
			ssandu 
			 
			
  
			
			
				Joined: 26 Feb 2007 Posts: 95 Country: Romania | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				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 | 
		          | 
	
	
		  | 
	
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7992
  | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				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 | 
		          | 
	
	
		  | 
	
	
		
			ssandu 
			 
			
  
			
			
				Joined: 26 Feb 2007 Posts: 95 Country: Romania | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				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 | 
		          | 
	
	
		  | 
	
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7992
  | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				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 | 
		          | 
	
	
		  | 
	
	
		
			ssandu 
			 
			
  
			
			
				Joined: 26 Feb 2007 Posts: 95 Country: Romania | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				have you found a workaround for this things on Vista ?
  | 
			 
		  | 
	
	
		| Wed Aug 01, 2007 9:43 am | 
		          | 
	
	
		  | 
	
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7992
  | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				Which issues specifically are you referring to?
  | 
			 
		  | 
	
	
		| Wed Aug 01, 2007 9:47 am | 
		          | 
	
	
		  | 
	
	
		
			ssandu 
			 
			
  
			
			
				Joined: 26 Feb 2007 Posts: 95 Country: Romania | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				About what remains on hard drive after unistall.
  | 
			 
		  | 
	
	
		| Thu Aug 02, 2007 1:14 am | 
		          | 
	
	
		  | 
	
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7992
  | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				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 | 
		          | 
	
	
		  | 
	
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7992
  | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				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 | 
		          | 
	
	
		  | 
	
	
		 |