having trouble with Postgresql 8.4 ODBC Driver

Aug 29, 2013 at 10:01 PM
Edited Aug 29, 2013 at 10:02 PM
I'm trying to test Postgresql 8.4 as a backend for my model.

When I start the Wizard, after selecting pgODBC driver, the app comes up with the following exception:

The .Net Framework Data Provider for OLEDB (System.Data.OleDb) does not support the Microsoft OLE DB Provider for ODBC Drivers (MSDASQL). Use the .Net Framework Data Provider for ODBC (System.Data.Odbc).

The stack trace is:

at System.Data.OleDb.OleDbConnectionString.ValidateProvider(String progid)
at System.Data.OleDb.OleDbConnectionString.ValidateConnectionString(String connectionString)
at System.Data.OleDb.OleDbConnectionString..ctor(String connectionString, Boolean validate)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
at System.Data.OleDb.OleDbConnection.ConnectionString_Set(String value)
at System.Data.OleDb.OleDbConnection.set_ConnectionString(String value)
at System.Data.OleDb.OleDbConnection..ctor(String connectionString)
at Chili.Opf3.Wizard.UI.Forms.MetadataViewer..ctor(Storage storage) in Z:\WinXpShared\Opf3-Wizard-Open-Sourced\Chili.Opf3.Wizard\UI\Forms\MetadataViewer.cs:line 46
at Chili.Opf3.Wizard.UI.Pages.StorageSchemaDataPage.metaDatabutton_Click(Object sender, EventArgs e) in Z:\WinXpShared\Opf3-Wizard-Open-Sourced\Chili.Opf3.Wizard\UI\Pages\StorageSchemaDataPage.cs:line 206
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

What can I do?

TIA

Regards