PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

  • Overview
  • Configuring a connection
  • Notes
  • Date format returned by the native Oracle driver (5.5 compatibility)
  • Options of a connection
  • Options for the locks
  • Test of a connection
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
Configuring the connection with WDORAINS (optional setting)
Native AccessesAvailable only with this kind of connection
Overview
For backward compatibility with the earlier versions of Native Oracle Connector (also called Native Oracle Access), the connection can still be configured in WDSQSINS (supplied with Native Oracle Connector). WDORAINS can also be used to configure some specific options of the Native Connector.
This software is supplied:
  • in 32 bits: WDORAINS.EXE
  • Versions 21 and later
    in 64 bits: WDORAINS64.EXE
    New in version 21
    in 64 bits: WDORAINS64.EXE
    in 64 bits: WDORAINS64.EXE
WDORAINS is no longer required since version 8 (and later).
Reminder: The setting of the connection performed by WDORAINS must be done once only.
This page presents:
Configuring a connection
To configure the connection:
  1. Start WDORAINS (32 bits or 64 bits).
  2. In the window that is opened (used to list the existing connections), click the "Add" button to create a new connection.
  3. Specify the connection settings:
  • Choose the name of the data source. This name will be passed in parameter to SQLConnect in order to establish the connection to the database. If the connection was defined in the data model editor of WINDEV or WEBDEV, specify the name of the corresponding connection.
  • Add a description caption
  • Specify a connection string. This connection string will allow SQL*Net to find the database. This value must be supplied by the administrator of the Oracle database. Example of connection string: "OracleServer". In this example, "OracleServer" is the alias to the server defined in SQL*Net.
  • Specify whether the format of the dates must remain compatible with WINDEV 5.5.
    Reminder: Between version 5.5 and version 5.5B, the date format was modified. If you check the box, you will restore the date format returned before version 5.5B (see the paragraph below).
  • Specify the format of the dates for the INSERT and UPDATE queries: this option is used to define the format used by default for the dates in text format. This format will be used if the date format is not specified in the query.
  • Specify the prefetch options for Oracle 8i or later.
    Reminder: Oracle 8i fetches blocks of records ("prefetch"). A large block requires more memory but reduces the network traffic.
    • The number of records corresponds to the number of rows in each block.
    • The maximum memory used corresponds to the size (in bytes) of each block. The "No limit" option allows you to specify no limit.
  • Specify whether the distributed transactions must be used or not. By default, the distributed transactions are used by the locks and transactions handled by Native Oracle Connector. Check this option if:
    • The distributed transactions are not supported by your server.
    • The distributed transactions are not supported by the versions of the client layers (ORA_02041 error).
  • The connection is added to the list once the parameters are validated.

Notes

  • The information about the setting is stored in the .INI file in the directory of Windows.
  • WDSQL is used to check whether the connection to the database is correct.

Date format returned by the native Oracle driver (5.5 compatibility)

In version 5.5: The date returned by the native Oracle driver when reading a Date item was: JJ-MM-AAAA
In version 5.5B: The date returned by the native Oracle driver when reading a Date item now is: YYYYMMDD.
Reasons behind this modification: Harmonizes the management of dates in WINDEV. Simplifies the assignment of the date read by the Oracle driver in a WINDEV control of DATE type. No specific process is required to convert the date into a format recognized by WINDEV.
How to keep the former operating mode?
Configure the date format in WDORAINS: all you have to do is check "Compatibility: return the dates in 'DD-MM-YYYY' format" when describing the database used.
Reminder: When writing into a database via the native Oracle driver, we recommend that you use the standard ODBC format {d 'YYYY-MM-DD'} (with a space between d and '). The driver automatically converts the date into the format used by the database.
Example:
INSERT INTO TABLE(DATE) VALUES ({d '1999-12-25'})
Note: Since version 12, the empty dates correspond to strings competed by zeros. In the earlier versions, the empty dates corresponded to empty strings.
Options of a connection

Options for the locks

SQLLock expects two parameters:
  • the time-out: the time-out during the call to SQLLock can be infinite or not (deadlock).
  • the lock mode. See the documentation about the server for more details.
Note: Some failures may occur if the version of the Oracle server is earlier than the version of the Oracle client (Oracle 7.3 server and Oracle 8 client for example). To avoid these problems, check "Always use a 7.x client".
Test of a connection
To run the test of a connection from WDORAINS:
  1. Select the connection whose test must be run.
  2. Click the "Test" button.
  3. Specify the name and password of the user.
  4. Click the "Test the connection" button. The status report is displayed.
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment