corelibraries-403639-devexpress-data-library-data-sources-use-the-sql-data-source-connection-strings-for-xpo-providers.md
When you construct a connection string manually and assign it to the CustomStringConnectionParameters property, use the XpoProvider parameter to identify the provider type. Connection string examples are listed in the following table:
|
Relational Database System
|
Connection String Sample[1]
| | --- | --- | |
Microsoft SQL Server[2]
|
XpoProvider= MSSqlServer ;Data Source=(local);User ID=username;Password=password;Initial Catalog=database;Persist Security Info=true
| |
Microsoft Access
|
XpoProvider= MSAccess ;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;
XpoProvider= MSAccess ;Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\mydatabase.accdb;User Id=admin;Password=;
| |
Microsoft SQL Server CE
|
XpoProvider= MSSqlServerCE ;Data Source=MyDatabase.sdf;Password=MyPassword
| |
Oracle Database
|
XpoProvider= Oracle ;Data Source=TORCL;User ID=MyUserName;Password=MyPassword
XpoProvider= ODP ;Data Source=TORCL;User ID=MyUserName;Password=MyPassword
XpoProvider= ODPManaged ;Data Source=TORCL;User ID=MyUserName;Password=MyPassword
| |
Amazon Redshift
|
XpoProvider= Amazon Redshift ;Server=127.0.0.1;User ID=MyUserName;Password=MyPassword;Database=MyDatabase;Encoding=UNICODE
| |
Google BigQuery
|
XpoProvider= BigQuery ;ProjectID=myProject;DataSetId=myDataSet;OAuthClientId=myClientId;OAuthClientSecret=mySecret;OAuthRefreshToken=myRefreshToken
XpoProvider= BigQuery ;ProjectId=project;DatasetId=dataset;ServiceAccountEmail=[email protected];PrivateKeyFileName=key.p12
| |
Teradata
|
XpoProvider= Teradata ;Data Source=myServerAddress;User ID=myUsername;Password=myPassword;
| |
SAP Sybase Advantage
|
XpoProvider= Advantage ;Data Source=\myserver\myvolume\mypat\mydd.add;ServerType=local;User ID=ASSSYS;TrimTrailingSpaces=true
| |
SAP Sybase ASE
|
XpoProvider= Ase ;Port=5000;Data Source=MyAseServer;User ID=MyUserName;Password=MyPassword;Initial Catalog=MyDatabase;Persist Security Info=true
| |
SAP SQL Anywhere
|
XpoProvider= Asa ;eng=server;uid=user;pwd=password;dbn=database;persist security info=true;
| |
IBM DB2
|
XpoProvider= DB2 ;Server=server:port;Database=database;UID=user;PWD=password;
| |
Firebird
|
XpoProvider= Firebird ;DataSource=localhost;User=SYSDBA;Password=masterkey;Database=MyDatabase.fdb;ServerType=0;Charset=NONE
| |
MySQL
|
XpoProvider= MySql ;Server=MyServerAddress;User ID=MyUserName;Password=MyPassword;Database=MyDatabase;Persist Security Info= true;Charset=utf8
| |
Pervasive PSQL
|
XpoProvider= Pervasive ;Server=MyServerAddress;UID=MyUserName;PWD=MyPassword;ServerDSN=MyDatabase
| |
PostgreSQL
|
XpoProvider= Postgres ;Server=127.0.0.1;User ID=MyUserName;Password=MyPassword;Database=MyDatabase;Encoding=UNICODE
| |
VistaDB
|
XpoProvider= VistaDB ;Data Source=C:\mydatabase.vdb4
XpoProvider= VistaDB5 ;Data Source=C:\mydatabase.vdb5
| |
SQLite
|
XpoProvider= SQLite ;Data Source=filename
| |
XML file
|
XpoProvider= InMemoryDataStore ;data source=D:\Contacts.xml;read only=True
|
Footnotes
The connection strings demonstrated above are examples. You can specify alternative strings.
The MS SQL Server data provider is automatically specified if you set the “Initial Catalog” parameter and do not use the word “Provider” (for instance, the “XpoProvider” parameter) in the connection string.