Burim Ratkoceri posted on Friday, May 22, 2009

Hi,
I am trying to use VistaDB as the database. I am using 3.6 but I am unable to find out what should I put in app.config so that connection manager loads the vistadb provider.
Can anyone guide me through this.

Many thanks,
Burim Ratkoceri

triplea replied on Friday, May 22, 2009

From: http://www.connectionstrings.com/vistadb

Data Source=D:\folder\myVistaDatabaseFile.vdb3;Open Mode=ExclusiveReadWrite;

Never tried it though

Burim Ratkoceri replied on Friday, May 22, 2009

Thanks Triplea,

However I had problems with loading the VistaDB Provider through the ConnectionManager.
After I put the dbProvider in <appSettings> section it loaded correctly.

In case anyone else needs it

<appSettings>
<add key="dbProvider" value="VistaDB.NET20"/>
</appSettings>

<connectionStrings>
<add name="CNN" connectionString="Data Source='C:\\Test.vdb3' providerName="VistaDB.NET20"/>
</connectionStrings>