WinSQL » Knowledge base

Document information

Document ID:1287
Subject:WinSQL's Compatiblity with Vista and Windows 7
Creation date:3/18/10 12:10 PM
Last modified on:5/10/10 12:35 PM


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 information to keep in mind when using in these operating systems.

UAC restrictions

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.

ODBC Drivers

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.





User comments

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.
Your name:
Your email:
Hide my email address
Verification code:
Enter the verification code you see above more submitting your tip
Tip:Please limit tips to 1000 characters
Powered by 10MinutesWeb.com