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: 7948
|
|
|
|
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: 7948
|
|
|
|
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: 7948
|
|
|
|
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: 7948
|
|
|
|
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: 7948
|
|
|
|
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 |
|
 |
|