f$ADOConnectString

With this function you can create the string required for making an ADO connection. If desired, this string can be supplemented with additional information before the ADO connection is established. The information required for such a connection depends on the database used. This function is only for simple usage of ADO. The connection string can also be assigned directly.

Microsoft SQLServer: Provider = SQLOLEDB

Connection string: Provider=sqloledb;Data Source=Server1;Initial Catalog=Salesmanager

Oracle: Provider = OraOLEDB.Oracle

Connection string: Provider=OraOLEDB.Oracle;Data Source=SMP_ORA

Note: when using Oracle, you cannot enter a database as well.

ODBC:

Connection string: DSN=smp;User ID=sa;Password=;’

Syntax:	ConnectString = f$ADOConnectString(Provider,Server,Database)
	Argument	Type	Meaning
	Provider	String	Name of the driver (SQLOLEDB, OraOLEDB.Oracle ...)
	Server	String	Name of the database server or service
	Database	String	Name of the database to be accessed. This only works with Microsoft SQL servers. An empty string is to be entered for other databases.
Result:	String	The connection string created
Example:	Connstr = f$ADOConnectString ('SQLOLEDB','Server1'‚'SMP')