Get or set connection string.

Property Value

Remarks

Example

Some examples of connection strings for native clients:

SQL Server: 
Data Source=localhost;User Id=your_username;Password=your_password

MySQL: 
Data Source=localhost;Database=indootestdata;User ID=your_username;Password=your_password

Oracle: 
Data Source=localhost;User Id=your_username;Password=your_password

SQL Server Express: 
Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf
        ''' 

Some examples for ODBC clients:

Oracle Express: 
Driver={Oracle in XE};;Server=localhost;Uid=hr;Pwd=your_password;QTO=F

Microsoft Access: 
Driver={Microsoft Access Driver (*.mdb)};DBQ=[app_path]\TestDB.mdb;DriverId=25;FIL=MS Access;

SQL Server (also for express): 
Driver={SQL Server};Server=localhost;Uid=your_username;Pwd=your_password;

MySQL:
DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=indootestdata;UID=your_username;PASSWORD=your_password;OPTION=3

See Also

client Class | Indoo.Data Namespace

---