PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Operating mode
  • Note
  • The DLLs used
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Allows you to specify the version of Native SQL Server Access that will be used. Indeed, the Native SQL Server Access was re-written. It is now using a more recent technology and it does not rely on DB-Library anymore.
The hNativeAccessSQLServer constant does not change. It must still be used in the functions for handling the Native SQL Server Access (HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection).
This variable is used to manage the compatibility between the different versions.
Syntax
H.SQLServerMode = <Value>
<Value>: Integer
  • 0 to force the use of Native SQL Server Access SQLnCli via OLEDB.
  • 1 to use the former Native Access if it is installed ; otherwise, to use the new one. This mode is the default mode.
  • 2 to force the use of former Native Access (Native Access via DB-Library).
  • Versions 19 and later
    3 to force the use of Native SQL Server Access SQLnCli via ODBC.
    New in version 19
    3 to force the use of Native SQL Server Access SQLnCli via ODBC.
    3 to force the use of Native SQL Server Access SQLnCli via ODBC.
Remarks

Operating mode

By default, the former Native Access (Native Access via DB-Library) is used if it is installed on the computer; otherwise, the new Native Access (Native Access via SQLnCli) is used.
The H.SQLServerMode variable is used to force a mode. The variable must be modified before using HDescribeConnection and/or HOpenConnection.
Note: If the former Native SQL Server Access is installed on the development computer, the tools and the editors of WINDEV and WEBDEV will use this former Native Access. Differences may occur regarding the operating mode (if the clients use the new native access).
An error will occur if H.SQLServerMode = 0 is used on a computer where the new native SQL Server access is not found.
Versions 23 and later
Caution: From version 23, the former Native SQL Server Access (Native Access via DB-Library) is available upon request to our Technical Support, via "RequestToTS" (on the "Home" pane of product used, in the "Online help" group, expand "Help" and select "Request to technical support").
New in version 23
Caution: From version 23, the former Native SQL Server Access (Native Access via DB-Library) is available upon request to our Technical Support, via "RequestToTS" (on the "Home" pane of product used, in the "Online help" group, expand "Help" and select "Request to technical support").
Caution: From version 23, the former Native SQL Server Access (Native Access via DB-Library) is available upon request to our Technical Support, via "RequestToTS" (on the "Home" pane of product used, in the "Online help" group, expand "Help" and select "Request to technical support").

Note

HListProvider and SQLListSource take the H.SQLServerMode variable into account. For example, if the former Native Access is forced (H.SQLServerMode = 2) and if only the new Native Access is found, the Native Access will not be listed.

The DLLs used

  • The former Native SQL Server Access corresponds to the wdxxxsqs.dll library
  • The new Native SQL Server Access via SQLnCli (by OLE DB) corresponds to the wdxxxsqlserver.dll library.
  • Versions 19 and later
    The new Native SQL Server Access via SQLnCli (by ODBC) corresponds to the wdxxxsqlserver2.dll library.
    New in version 19
    The new Native SQL Server Access via SQLnCli (by ODBC) corresponds to the wdxxxsqlserver2.dll library.
    The new Native SQL Server Access via SQLnCli (by ODBC) corresponds to the wdxxxsqlserver2.dll library.
The new Native Access is also available in 64 bits with specific DLLs:
  • The new Native SQL Server Access via SQLnCli (by OLE DB) corresponds to the wdxxxsqlserver64.dll library.
  • Versions 19 and later
    The new Native SQL Server Access via SQLnCli (by ODBC) corresponds to the wdxxxsqlserver2_64.dll library.
    New in version 19
    The new Native SQL Server Access via SQLnCli (by ODBC) corresponds to the wdxxxsqlserver2_64.dll library.
    The new Native SQL Server Access via SQLnCli (by ODBC) corresponds to the wdxxxsqlserver2_64.dll library.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Minimum required version
  • Version 11
This page is also available for…
Comments
Click [Add] to post a comment