DevExpress v24.2 Update — Your Feedback Matters
Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.
Take the survey
Not interested
Specify the connection string in the following dialog:

Use the XpoProvider parameter to identify a data source provider. See connection string examples in the table below.
Relational Database System
| Connection String Sample
|
---|
Microsoft SQL Server
| 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=example@gmail.com;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
|
Click Next to proceed to the next wizard page: Save the Connection String.