ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Developing an application or website / User Groupware / User Groupware - Compatibility version
  • Overview
  • How to?
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
User Groupware and Native Connector files
Native Connectors (Native Accesses)Available only with this kind of connection
Warning
From version 18, the User Groupware evolves. This help page corresponds to the User Groupware kept for backward compatibility. To get this help page for the new version of the User Groupware, see User Groupware and Native Connector.
Overview
An application that works with the user groupware can be used with a database handled by a Native Connector.
To integrate a Native Connector to an application that uses the User Groupware, the latter must be configured to use the data files on the server. These operations are presented in this help page.
How to?
To use the User Groupware files with a Native Connector:
  1. The User Groupware must not use the "Automatic start" mode in your application.
    Make sure that "Automatic run" is unchecked in the window for configuring the user groupware ("Workshop .. Configure the user groupware").
  2. In the initialization code of the project, use gpwOpenConnection to describe the connection to the database handled by a Native Connector.
    Caution: the passwords defined for the files of user groupware are ignored.
  3. Use gpwOpen without specifying the paths of the data files. The concept of directory does not exist in this case.
Minimum version required
  • Version 9
This page is also available for…
Comments
Exemplo de uso do Driver Nativo Ms SQL Server e Groupware
//Conexao
ok, ok1, ok2, ok3 is boolean

myConn is Connection
myConn..Provider = hNativeAccessSQLServer
myConn..User = "adriano"
myConn..Password = "adriano@2016"
myConn..Source = "192.168.0.162\projeto01"
myConn..Database = "projeto01"
myConn..Access = hOReadWrite

ok1 = HOpenConnection(myConn)
IF ok1 = False THEN
Info(ErrorOccurred() +" - "+ HErrorInfo())
END


IF gpwInitAnalysis() = False THEN
Error(ErrorInfo())
ok2 = False
ELSE

ok2 = True
IF gpwOpen() = gpwOk
ok3 = True
ELSE
Info(ErrorOccurred() +" - "+ HErrorInfo())
ok3 = False
END

END

NextTitle("Atenção")

IF ok1 = True AND ok2 = True AND ok3 = True THEN //deve dar tudo ok

Info("Conectou com sucesso no banco de dados!")

ELSE

Info("Falha ao tentar conectar no Servidor")

END
BOLLER
28 Nov. 2016

Last update: 05/26/2022

Send a report | Local help