Connect String (Magic xpa 2.x)
To work with the SQL database and execute SQL commands, the user must first connect to the SQL server by sending a connect string to the database. The connect string includes the user name and password of the user to connect with.
Each database has a different connect string structure.
When working with a remote Oracle server, in addition to the user name and password, you need to add an alias pointing to the remote server.
This property does not support logical names.
|
Note:
|
Windows authentication:
SQL Server: The user name and password should remain blank.
Oracle: The user name should be a forward slash (/) and the password should remain blank.
|
Examples:
Oracle: (local)
sqlplus username/password
(remote)
sqlplus username/ password@alias
Relevant interfaces: MSSQL and Oracle
