WinSQL » Knowledge base
|Subject:||WinSQL's Compatiblity with Vista and Windows 7|
|Creation date:||3/18/10 12:10 PM|
|Last modified on:||12/14/18 11:58 AM|
WinSQL's compatibility with Vista/Windows 7
The latest version of WinSQL is 100% compatible with Windows Vista, Windows 7 and Windows 2008. Having said that, there are a few important pieces of information to keep in mind when using in these operating systems.
By default, Vista, Windows 2008 and Windows 7 use UAC (User Account Control) to prevent a regular user from running a program as an administrator.
This means that a normal program cannot gain access to certain areas on the machine. For example, a program cannot read/write to HKEY_LOCAL_MACHINE node in the registry. Therefore, if you are using WinSQL on a machine with UAC enabled, you cannot use a System DSN; you can only use a User DSN. This is because information for a System DSN is stored under HKEY_LOCAL_MACHINE and applications cannot read that at run-time.
It is important that the ODBC driver you use with WinSQL are also compatible with Windows Vista, Windows 2008, and Windows 7. Some older versions of the ODBC drivers store information under the HKEY_LOCAL_MACHINE area of the registry and therefore do not work on newer versions of the operating system.
Posted by sebastian miller on 8/10/11 6:27 PM
when i write "NOT NULL" on field an appear error:
Error: This property is not supported for external data sources or for databases created with a previous version of Microsoft Jet. (State:S1000, Native Code: FFFFF1EE)
Add a comment to this document
Do you have a helpful tip related to this document that you'd like to share
with other users? Please add it below. Your name and tip will appear at the
end of the document text.