PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • Operating mode
  • Remark
  • 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 the Native SQL Server Connector (also called Native SQL Server Access) that will be used. Indeed, the Native SQL Server Connector has been rewritten. It now uses a more recent technology and is no longer based on DB-Library.
The constant hNativeAccessSQLServer does not change. It must always be used in the functions for handling the Native SQL Server Connector (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 the Native SQL Server Connector SQLnCli via OLEDB.
  • 1 to use the former Native Connector if it is installed ; otherwise, to use the new one. This mode is the default mode.
  • 2 to force the use of the former Native Connector (Native Connector via DB-Library).
  • Versions 19 and later
    3 to force the use of the Native SQL Server Connector SQLnCli via ODBC.
    New in version 19
    3 to force the use of the Native SQL Server Connector SQLnCli via ODBC.
    3 to force the use of the Native SQL Server Connector SQLnCli via ODBC.
Remarks

Operating mode

By default, the former Native Connector (Native Connector via DB-Library) is used if it is installed on the computer, otherwise the new Native Connector (Native Connector 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.
The key word WD CLIENT VERSION specified in the optional connection information is used to indicate the SQL Server Client to use.
For example, the string "WD CLIENT VERSION = 2012" is used to force the access via a SQL Server 2012 Client installed on the workstation (msoledbsql), preferable to the driver provided by Windows (sqloledb).
Remark: If the former Native SQL Server Connector is installed on the development computer, the tools and the editors of WINDEV and WEBDEV will use this former Native Connector. This may lead to differences in the operating mode (if the clients use the new Native Connector).
An error will occur if H.SQLServerMode = 0 is used on a computer where the new Native SQL Server Connector is not found.
Versions 23 and later
Caution: Since version 23, the former Native SQL Server Connector (Native Connector via DB-Library) is available upon request to our Technical Support, via "RequestToTS" (on the "Home" pane of the product used, in the "Online help" group, expand "Help" and select "Request to the technical support").
New in version 23
Caution: Since version 23, the former Native SQL Server Connector (Native Connector via DB-Library) is available upon request to our Technical Support, via "RequestToTS" (on the "Home" pane of the product used, in the "Online help" group, expand "Help" and select "Request to the technical support").
Caution: Since version 23, the former Native SQL Server Connector (Native Connector via DB-Library) is available upon request to our Technical Support, via "RequestToTS" (on the "Home" pane of the product used, in the "Online help" group, expand "Help" and select "Request to the technical support").

Remark

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

The DLLs used

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