f$SQLConnect

Make a connection to a database via ODBC and to a user or system data source. The channel number returned must be given for all following access attempts.

Note: since it takes time to make the connection, a new connection should not be established for every SQL function.

Hint:

The f$SQLDriverConnect function can also use file data sources. Compared to user or system data sources, these offer the advantage of not having to be installed on every ePOS user PC and can instead be created (and transported) on a central network drive. If the appropriate keywords are known, a connection to the database can be made with f$SQLDriverConnect without needing data sources.

If further connection information is needed which is not already saved in the ODBC data source, the f$SQLDriverConnect function can also be used.

Syntax:	Channel = f$SQLConnect( db, user, password )
	Argument	Type	Meaning
	Db	String	Name of the database (name of the ODBC data source)
	User	String	User identifier
	Password	String	Password
Result:	Integer	Channel number or –1 if the connection cannot be established.