OdbcConnect

Syntax

OdbcConnect(str_dbidentifier, str_data_source, str_userID,              str_password);

str_dbidentifier	A name you specify which will be used in all the following ODBC functions to identify which data source they will access.
str_data_source	The name of the ODBC data source to which you want to establish a connection.
str_userID	The user ID to login to the data source.
str_password	The login password to the data source.

Description

Connects the user to the data source. You do not need to use OdbcConnect for every scripting function. Once the server connection is established, it will only be closed when you call the OdbcDisconnect function, or when the job completes.

If the data retrieved with ODBCGetFirst, ODBCGetNext, or ODBCGetOne is of Unicode type, you should use the OdbcConnectW (instead of OdbcConnect) when connecting to the data source.

If str_dbidentifier is already associated with a data source, no new connection is established. The existing connection remains open.

Note:

If you call ODBCConnect twice without calling ODBCDisconnect in between, ODBCDisconnect will automatically be called before the new connection is made.

Returns

	A connection to the data source has been established successfully.
-1	Error. No connection to the data source could be established.

Example

OdbcConnect("my_identifier","address.dsn","sa","abc_1");