ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
  • 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:
    • in 32 bits to the library wd28 0sqlserver.dll,
    • in 64 bits to the library wd28 0sqlserver64.dll.
  • The Native SQL Server Connector via ODBC corresponds to:
  • in 32 bits, to the library wd28 0sqlserver2.dll,
  • in 64 bits, to the library wd28 0sqlserver2_64.dll.
Component: wd280hf.dll
Minimum version required
  • Version 11
This page is also available for…
Comments
Click [Add] to post a comment