Almost all connections require specifying a user name and password to be included into the connection string. Dataodyssey Express allows to use the following syntax to do it:

1. Explicit inclusion. Just type the user name and password in the connection string. For example, if the data source is a Microsoft SQL Server database, where the user name is sa and the password - 123, the connection string will look like: Driver={SQL Server};Server=srvnameorIP;Database=dbname;uid=sa;pwd=123. But! This is not a good way because it is insecure.

2. Demand on connection. You can make the program demand the user name and password on connection to the data source. Use the <uid> or <:::> user name and <pwd> or <@@@> password syntax and the program will require the user name and/or password on connection.

3. Use the user name and password entered at logon. The user name and password syntaxes are <app_uid> and <app_pwd> respectively. For example: Driver={SQL Server};Server=srvnameorIP;Database=dbname;uid=<app_uid>;pwd=<app_pwd>

www.dataodyssey.com         Contents