ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / WLanguage variables
  • Operating mode
  • Note
  • DLLs used
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Allows you to specify the version of the Native SQL Server Connector (or Native SQL Server Access) that will be used.
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).
Syntax
H.SQLServerMode = <Value>
<Value>: Integer
  • 0 to force the use of the Native SQL Server Connector via OLEDB.
  • 1 (default) to use the installed Native Connector. If both versions of the Native Connector are installed, the Native Connector via OLE DB will be used.
  • 3 to force the use of the Native SQL Server Connector via ODBC.
Remarks

Operating mode

By default, the Native Connector selected during the setup is used.. If the Native Connectors via OLE DB and ODBC are installed, the Native Connector via OLE DB will be 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 an SQL Server 2012 Client installed on the workstation (msoledbsql), preferable to the driver provided by Windows (sqloledb).

Note

HListProvider and SQLListSource take the H.SQLServerMode variable into account.

DLLs used

  • The Native SQL Server Connector via OLE DB corresponds to:
    • the wd290sqlserver.dll library (in 32-bit mode),
    • the wd290sqlserver64.dll library (in 64-bit mode).
  • The Native SQL Server Connector via ODBC corresponds to:
  • the wd290sqlserver2.dll library (in 32-bit mode),
  • the wd290sqlserver2_64.dll library (in 64-bit mode).
Component: wd290hf.dll
Minimum version required
  • Version 11
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/09/2023

Send a report | Local help