.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
The page you are viewing does not exist in the .NET Standard 2.0+ platform documentation. This link will take you to the parent topic of the current section.

AccessConnectionProviderMultiUserThreadSafe.GetConnectionString(String, String, String) Method

Returns a connection string to the specified MS Access data base using the specified credentials.

Namespace: DevExpress.Xpo.DB

Assembly: DevExpress.Xpo.v19.2.dll

Declaration

public static string GetConnectionString(
    string database,
    string userId,
    string password
)
Public Shared Function GetConnectionString(
    database As String,
    userId As String,
    password As String
) As String

Parameters

Name Type Description
database String

A string that specifies the path and name of the data base to connect to.

userId 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 GetConnectionString method contains an extra parameter that identifies the database type to which a connection should be established, so it's not fully compatible with the standard connection string format. When a Session receives this connection string it removes this extra parameter and then passes the valid connection string to the database.

Examples

The following code demonstrates how to connect to an MS 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");
See Also