PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • Operating mode
  • Remark
  • 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.
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 value) 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 a SQL Server 2012 Client installed on the workstation (msoledbsql), preferable to the driver provided by Windows (sqloledb).

Remark

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

DLLs used

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