Database Providers Howto

There are problems connecting to certain databases because the path to their dlls are incorrect in the configuration file.

There is a file called RdlEngineConfig.xml that has paths to all the databases that are supported but some of the paths are incorrect. It is up to you to make sure the path is correct on your own computer. Databases affected are:

• Oracle
• iAnywhere.NET
• Firebird.NET 2.0
• Firebird.NET
• MySQL.NET
• SQLce

Sqlite Mono

When using SQLite on Linux or Mac using mono the data provider section (in RdlEngineConfig.xml) will be different then when running on Windows. The the section should look the following. As you can tell the ClassName and CodeModule is different.

<DataSource> 
	<DataProvider>SQLite</DataProvider> 
    	<CodeModule>/usr/lib/mono/4.0/Mono.Data.Sqlite.dll</CodeModule> 
    	<ClassName>Mono.Data.Sqlite.SqliteConnection</ClassName> 
    	<TableSelect>SELECT name FROM sqlite_master WHERE type = 'table'</TableSelect> 
    	<Interface>SQL</Interface> 
</DataSource>