Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The easy way

If you want to connect to a TIS-Table or a table within the schema [TIS]Editor runs within – which is the most probable case – then it is enough to select the field data source and enter dal as information on connection.

Enter username and password

Username and password for the connection to the data source. These fields have to be filled in only if the data source requires authentication with username and password (e.g. databases typically do but files typically don't).
If you use Windows authentication then user connected to the WEB-Server is used for authentication (not the account on the client PC where session runs).

Select the Data Source

Choose from the different connection methods<br>

  • MS-SQL-Server 2000
  • MS-SQL-Server 2005
  • Oracle (as of version 9i or higher)
  • PostgresQL (version 9.4 or higher)
  • ODBC-data source... ''e.g. Access, Excel, txt, or CSV files

OPTIONAL fetch additional information

  • DSN: Displays data sources available for the method chosen (data bases, ODBC-sources, etc.)
  • OBJECTS: Displays objects available for the method chosen (data bases, etc.)

Define the Connection String (if entering dal is not sufficient)

Parameter may be used in the form of #XI.TISPar('...')# as part of the connection string.

Status
colourYellow
titleV 5.15


NOTE: This is the only relevant information for the establishment of the connection. The string for connection must comply with the conventions for connection strings. The button Create … combines a valid connection string on the basis of the information User, Password, Data source, etc…
Excellent information on <b>Composition of Connection information can be found on the following website http://www.connectionstrings.com/
An example to access an MS-access table in a file called ODBC.mdb
driver={Microsoft Access Drive(*.mdb)};Dbq= C:\Inetpub\wwwroot\TIS2005\IMPORTEXPORTPROJECT\ODBC.mdb


Many different databases can be accessed.E.g.

  • MySQL
  • Filemaker
  • MSProject
  • MSEXchange
  • Active Directory
  • Lotus Notes

Check Table names and Column Name

As soon as the connection string is defined, on can update the list of tables that can be accessed:

In the next steps one can also see the column-names and types

...