AccessConnectionProviderMultiUserThreadSafe.GetConnectionString(String, String, String) Method
Returns a connection string to the specified Microsoft Access data base using the specified credentials.
Namespace: DevExpress.Xpo.DB
Assembly: DevExpress.Xpo.v24.2.dll
NuGet Package: DevExpress.Xpo
#Declaration
#Parameters
Name | Type | Description |
---|---|---|
database | String | A string that specifies the path and name of the data base to connect to. |
user |
String | A string that specifies the user’s name. This is used to initialize the “User ID” field of the connection string. |
password | String | A string that specifies the password. This is used to initialize the “Password” field of the connection string. |
#Returns
Type | Description |
---|---|
String | A connection string. |
#Remarks
The value returned by this method can be used to initialize a Session’s connection string (for instance, via the Session.ConnectionString or XpoDefault.ConnectionString property).
The database parameter specifies the name of the database. If the full path is omitted it is assumed that the database resides in the same folder as the application’s executable file.
This method sets the connection string’s “User ID” field to “Admin” and the password to an empty string.
Note
The string returned by the Get
#Example
The following code demonstrates how to connect to an Microsoft Access database. The AccessConnectionProvider.GetConnectionString method is called to construct a connection string to the database. It’s then assigned to the XpoDefault.ConnectionString property.
When a connection is about to be established to a database, a session object obtains the connection string from the XpoDefault.ConnectionString property (unless another connection string is supplied directly to the session). This is then used to connect to the database.
using DevExpress.Xpo;
using DevExpress.Xpo.DB;
XpoDefault.ConnectionString = AccessConnectionProvider.GetConnectionString(
@"c:\Data\nwind.mdb");