Error System.Data.IDbConnection

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
TEDI_IT
Posts: 4
Joined: Wed 22 Jun 2011 14:00

Error System.Data.IDbConnection

Post by TEDI_IT » Thu 23 Jun 2011 16:07

Fehler 2 Der Typ "System.Data.IDbConnection" ist in einer nicht referenzierten Assembly definiert. Fügen Sie einen Verweis auf die Assembly "System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" hinzu.
Hi programmers,

compiling my new Win-CE Project, VS2008 (C#) generates the quoted error above.
What can I do?

with best regards

Ralf

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 24 Jun 2011 08:17

Please make sure that:
1) your Win-CE Project has a reverence to System.Data.dll v 2.0;
2) .NET Compact Framework v 2.0 is installed on your development workstation (by default, \Program Files\Microsoft.NET\SDK\CompactFramework\v2.0\);
3) .NET Compact Framework v 2.0 is installed on the mobile device (or emulator) where you are deploying your application (launch the \Windows\cgacutil.exe utility on your device).

For more information, refer to http://en.wikipedia.org/wiki/.NET_Compact_Framework.

TEDI_IT
Posts: 4
Joined: Wed 22 Jun 2011 14:00

Post by TEDI_IT » Fri 24 Jun 2011 08:33

i have a reference to System.Data which refer to C:\Programme\Microsoft.NET\SDK\CompactFramework\v2.0\WindowsCE\System.Data.dll

Code: Select all

using System.Windows.Forms;
using System.Data;
using Devart.Common;
using Devart.Data;
using Devart.Data.Oracle;

namespace PalettenKontrolle
{
    public partial class frmPalCheck : Form
    {
        private Devart.Data.Oracle.OracleConnection oraCon;
        public frmPalCheck()
        {
            InitializeComponent();
            oraCon = new OracleConnection();
            oraCon.Sid = "db_sid";
            oraCon.Port = 1521;
            oraCon.Server = "server";
            oraCon.UserId = "user_id";
            oraCon.UserId = "user_pw";
        }

        

        private void frmPalCheck_KeyDown(object sender, KeyEventArgs e)
        {
            switch (e.KeyValue)
            {
                case 112:
                    this.Close();
                    break;
                case 113:
                    this.Close();
                    break;
            }
        }

       
    }
}
All references are set correctly...

It's not my first project for WinCE, but the first using devart components...

btw: System.Data.DataSet dsTest = new DataSet(); works while commenting all devArt references !!! ???
Last edited by TEDI_IT on Fri 24 Jun 2011 09:12, edited 1 time in total.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 24 Jun 2011 09:10

TEDI_IT wrote:All references are set correctly...
Which edition of dotConnect for Oracle are you using?

The .NET Compact Framework support is available only in the Mobile edition of dotConnect for Oracle: http://www.devart.com/dotconnect/oracle/editions.html. You should add the referece to Devart.Data.Oracle.dll from the Mobile edition (the Devart.Data.Oracle namespace) into your project. You can check your current edition via the Tools > Oracle > About menu of Visual Studio.

TEDI_IT
Posts: 4
Joined: Wed 22 Jun 2011 14:00

Post by TEDI_IT » Fri 24 Jun 2011 09:31

Thanks for your reply,

Trial Version of dotConnect for Oracle

Version 6.30.172.0

I guess, i am using the wrong version :shock:

Best regards, Ralf

TEDI_IT
Posts: 4
Joined: Wed 22 Jun 2011 14:00

Post by TEDI_IT » Fri 24 Jun 2011 11:24

Many Thanks for your support.

It works fine. The topic can be closed.

With best regards

Ralf

Post Reply