Almost all connections require user name and password which are to be included in the connection string. Dataodyssey Express allows using the following syntax to insert user name and password in the connection string:

1. Explicit insertion. Just type the user name and password in the connection string. For example, if a data source is a SQL server database, user name – sa, password – 123, the connection string will look like: Driver={SQL Server};Server=srvnameorIP;Database=dbname;uid=sa;pwd=123. But this method is unsafe because it’s not secure.

2. Ask before connection. You can make the program ask the user name and password before connection and demand entering the user name and/or password. Use <uid> or <:::> syntax for user name and <pwd> or <@@@> for password. For example: Driver={SQL Server; Server=srvnameorIP; Database=dbname; uid=<uid>; pwd=<pwd>.

3. Take the user name and password the user entered at program start. The user name syntax is <app_uid>, password syntax is <app_pwd>. For example: Driver={SQL Server}; Server=srvnameorIP; Database=dbname; uid=<app_uid>; pwd=<app_pwd>

www.dataodyssey.com         Table of contents