SQLManageDSN() function

The SQLManageDSN function runs the Microsoft ODBC Manager setup program while an InTouch application is running. SQLManageDSN() can be used within a script to add, delete, and modify existing data source names of a SQL Server or Access database.

Category

SQL

Syntax

SQLManageDSN(ConnectionId)

Argument

ConnectionId

ConnectionId is not used. It is retained for backward compatibility with older versions of SQL Access. Therefore, any number can be passed to the function. No database connection needs to be established before running the function to open Microsoft ODBC Manager.

Example

SQLManageDSN(0);