Reportizer, among other data sources, can open databases described by ADO connection strings.
The following examples of connection strings contain only parameters, which are required for opening the data sources, and mostly do not contain optional parameters. May be, you will need to modify them to adapt for your needs or depending on version of Microsoft Data Access Components (MDAC) installed.
There are many connection string examples are available in Internet, so if you cannot find the corresponding example for your database type, please try to search there.
XLS files
Jet
Provider=Microsoft.Jet.OLEDB.4.0;excel 8.0;DATABASE=C:\MyExcelData.xls;
ACE
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\MyExcelFile.xls;Extended Properties="Excel 8.0;HDR=YES"; (Microsoft ACE must be installed)
ODBC
Provider=MSDASQL.1;Extended Properties="DBQ=C:\MyExcelFile.xls;DefaultDir=C:\;Driver={Microsoft Excel Driver (*.xls)};DriverId=790;"
MDB files
Jet
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MyDatabaseFile.mdb;
ODBC
Provider=MSDASQL.1;Extended Properties="DBQ=MyDatabaseFile.mdb;Driver={Microsoft Access Driver (*.mdb)};DriverId=25;"
XLSX, XLSB, XLSM files
ACE
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\MyData\myExcel2007file.xlsx;Extended Properties="Excel 12.0;HDR=YES"; (Microsoft ACE must be installed; use it for Excel 2007 files)
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\MyData\myExcel2010file.xlsx;Extended Properties="Excel 14.0;HDR=NO"; (Microsoft ACE must be installed; use it for Excel 2010 files)
ODBC
Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=C:\MyExcelFile.xlsx; (Microsoft Excel 2007 ODBC Driver must be installed)
ACCDB files
ACE
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\MyData\myAccess2007file.accdb;Persist Security Info=False; (Microsoft ACE must be installed)
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\MyData\myAccess2007file.accdb;Jet OLEDB:Database Password=MyDbPassword; (Microsoft ACE must be installed)
ODBC
Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\MyAccessDB.accdb; (Microsoft Access accdb ODBC Driver must be installed)
Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\MyAccessDB.accdb;SystemDB=C:\MyAccessDB.mdw; (Microsoft Access accdb ODBC Driver must be installed)
Interbase (GDB) files
OLE DB
provider=sibprovider;location=localhost:;data source=C:\My_db.gdb;user id=SYSDBA;Password=masterkey; (SIBPROvider Interbase OLE DB Provider must be installed)
ODBC
Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};Server=localhost;Database=localhost:C:\My_db.gdb;Uid=myUsername;Pwd=myPassword; (Intersolv InterBase ODBC Driver must be installed)
Driver={Easysoft IB6 ODBC};Server=localhost;Database=localhost:C:\My_db.gdb;Uid=myUsername;Pwd=myPassword; (Easysoft ODBC Driver must be installed)
DRIVER=Firebird/InterBase(r) driver;Uid=myUsername;Pwd=myPassword;DBNAME=C:\My_db.gdb; (IBPhoenix Open Source ODBC Driver must be installed)
FireBird (FDB) files
ODBC
DRIVER=Firebird/InterBase(r) driver;Uid=myUsername;Pwd=myPassword;DBNAME=C:\My_db.fdb; (IBPhoenix Open Source ODBC Driver must be installed)
HTML, HTM files
Jet
Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties="HTML Import;DATABASE=C:\MyHTMLFile.html";
Visual FoxPro (DBC) files
OLE DB
Provider=vfpoledb;Data Source=C:\MyData\MyVFPDbFile.dbc;Collating Sequence=machine; (VFP OLE DB Provider must be installed)
ODBC
Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=C:\MyData\MyVFPDbFile.dbc; (Microsoft Visual FoxPro ODBC Driver must be installed)
Folder with Lotus (WJ2, WK1) files
Jet
Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties="Lotus WJ2;DATABASE=C:\MyLotusFolder";
Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties="Lotus WK1;DATABASE=C:\MyLotusFolder";
Folder with dBase (DBF) files
Jet
Provider=Microsoft.Jet.OLEDB.4.0;dBase 5.0;DATABASE=C:\MyDBaseFolder;
Provider=Microsoft.Jet.OLEDB.4.0;dBase IV;DATABASE=C:\MyDBaseFolder;
ACE
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\MyDBaseFolder;Extended Properties=dBASE IV; (Microsoft ACE must be installed)
ODBC
Provider=MSDASQL.1;Extended Properties="DefaultDir=C:\MyDBaseFolder;Driver={Microsoft dBase Driver (*.dbf)};DriverId=277;"
Folder with FoxPro (DBF) files
OLE DB
Provider=VFPOLEDB.1;Data Source=D:\MyFoxProFolder;Collating Sequence=MACHINE (VFP OLE DB Provider must be installed)
Folder with Paradox (DB) files
Jet
Provider=Microsoft.Jet.OLEDB.4.0;Paradox 4.X;DATABASE=C:\MyParadoxFolder;
ACE
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\MyParadoxFolder;Extended Properties=dBASE IV; (Microsoft ACE must be installed)
ODBC
Provider=MSDASQL.1;Extended Properties="DefaultDir=C:\MyParadoxFolder;Driver={Microsoft Paradox Driver (*.db )};DriverId=26;"
Folder with TXT, CSV, ASC, TAB files
Jet
Provider=Microsoft.Jet.OLEDB.4.0;TEXT;DATABASE=C:\MyCSVFolder;
ODBC
Provider=MSDASQL.1;Extended Properties="DefaultDir=C:\MyCSVFolder;Driver={Microsoft Text Driver (*.txt; *.csv)};DriverId=27;Extensions=asc,csv,tab,txt;"
UDL files
FILE NAME=c:\MyDataLinkFile.udl;
Adaptive Server Anywhere databases
OLE DB
Provider=ASAProv;Data source=myASADatabase; (Adaptive Server Anywhere OLE DB Provider must be installed)
ODBC
Driver=Adaptive Server Anywhere 7.0;ENG=server.database_name;UID=myUsername;PWD=myPassword;DBN=myDataBase;LINKS=TCPIP(HOST=serverNameOrAddress); (Adaptive Server Anywhere ODBC Driver must be installed)
DB2 databases
OLE DB
Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=xxx.xxx.xxx.xxx;Initial Catalog=MyCatalog;Package Collection=MyPkgCol;Default Schema=mySchema;User ID=myUsername;Password=myPassword; (Microsoft OLE DB Provider for DB2 must be installed)
Provider=IBMDADB2;Database=myDatabase;Hostname=myServerAddress;Protocol=TCPIP;Port=50000;Uid=myUsername;Pwd=myPassword; (IBM OLE DB Provider for DB2 must be installed)
ODBC
Driver={IBM DB2 ODBC DRIVER};Database=myDbName;Hostname=myServerAddress;Port=myPortNum;Protocol=TCPIP;Uid=myUserName;Pwd=myPwd (IBM DB2 Driver for ODBC must be installed)
Informix databases
OLE DB
Provider=Ifxoledbc;Data Source=dbName@serverName;User ID=myUsername;Password=myPassword; (IBM Informix OLE DB Provider must be installed)
Ingres databases
ODBC
Provider=MSDASQL;DRIVER=Ingres;SRVR=xxxxx;DB=xxxxx;Uid=myUsername;Pwd=myPassword;Extended Properties="SERVER=xxxxx;DATABASE=xxxxx;SERVERTYPE=INGRES"; (ODBC Driver for Ingres must be installed)
SQL Server databases
OLE DB
Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword; (Microsoft OLE DB Provider for SQL Server must be installed)
Provider=SQLNCLI;Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; (SQL Native Client 9.0 OLE DB provider must be installed; use it for SQL Server 2005)
Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; (SQL Server Native Client 10.0 OLE DB Provider must be installed; use it for SQL Server 2008)
Provider=SQLNCLI11;Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; (SQL Server Native Client 11.0 OLE DB Provider must be installed; use it for SQL Server 2012+)
Provider=SQLNCLI11.1;Integrated Security=SSPI;Persist Security Info=False;User ID="";Initial Catalog="";Data Source=localhost\SQLEXPRESS; (SQL Server Native Client 11.1 OLE DB Provider must be installed; use it for SQL Server 2012+)
ODBC
Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; (Microsoft SQL Server ODBC Driver must be installed)
Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; (SQL Native Client 9.0 ODBC Driver must be installed; use it for SQL Server 2005)
Driver={SQL Server Native Client 10.0};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; (SQL Server Native Client 10.0 ODBC Driver must be installed; use it for SQL Server 2008)
Driver={SQL Server Native Client 11.0};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; (SQL Server Native Client 11.0 ODBC Driver must be installed; use it for SQL Server 2012+)
MySQL databases
OLE DB
Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword; (MySQL OLEDB Provider must be installed)
Oracle databases
OLE DB
Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword; (Microsoft OLE DB Provider for Oracle must be installed)
Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword; (Oracle Provider for OLE DB must be installed)
ODBC
Driver={Microsoft ODBC Driver for Oracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword; (Microsoft ODBC Driver for Oracle must be installed)
Pervasive PSQL databases
OLE DB
Provider=PervasiveOLEDB;Data Source=myServerAddress; (Pervasive OLE DB Provider must be installed)
ODBC
Driver={Pervasive ODBC Client Interface};ServerName=myServerAddress;dbq=@dbname; (Pervasive ODBC Client Interface must be installed)
PostgreSQL databases
OLE DB
Provider=PostgreSQL OLE DB Provider;Data Source=myServerAddress;location=myDataBase;User ID=myUsername;password=myPassword; (PostgreSQL OLE DB Provider must be installed)
ODBC
Driver={PostgreSQL};Server=IP address;Port=5432;Database=myDataBase;Uid=myUsername;Pwd=myPassword; (PostgreSQL ODBC Driver must be installed)
SQLite databases
ODBC
Driver=SQLite3 ODBC Driver;Database=C:\MyData\My_db.db; (SQLite3 ODBC Driver must be installed)
SQLBase databases
OLE DB
Provider=SQLBaseOLEDB;Data source=myServerAddress;Location=myDataBase;User Id=myUsername;Password=myPassword; (SQLBase OLE DB Data Provider must be installed)
ODBC DSN
1. Provider=MSDASQL.1;Extended Properties="DSN=IBLOCAL_ADO_EMP;UID=sysdba;PWD=masterkey"
2. MYDSN;
3. Provider=MSDASQL.1;Extended Properties="DSN=ORACLE_DB;UID=ADM;PWD=freedom;"
4. Provider=MSDASQL.1;Data Source=DBF_DATA;Extended Properties="DSN=DBF_DATA;DriverId=533;FIL=dBase 5.0;"