oradirect.net with Compact Framework; Toolbar disabled

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Gardan
Posts: 1
Joined: Mon 18 Dec 2006 17:54

oradirect.net with Compact Framework; Toolbar disabled

Post by Gardan » Mon 18 Dec 2006 18:03

Hello,

i downloaded the trial version of the oradirect.net for creating an oracle applikation on a mobile device.

when i create a new projekt in visual studio 2005 (smart device, windows ce, device application) i can see in the toolbar only specific components for the compact framework but the oraDirect components are greyed out. When i create a standard project the oraDirect components are available. The help from the faq about the component design mode doesnt work here. Could it be that the trial version isnt usable for the compact framework.

thx for any help
Gardan

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Tue 19 Dec 2006 07:50

You should have installed another package (specifically intended for Compact Framework).

tangster
Posts: 6
Joined: Thu 21 Dec 2006 17:34

Post by tangster » Thu 21 Dec 2006 17:39

Hi,
I am also having the same problem regarding the grayed out toolbox. I have installed " OraDirect .NET Mobile 3.55 for .NET CF 2.0 [size 2479 Kb]
". Is there another download I have to install to make it work. I am using VS 2005 and want to connect my IPAQ handheld to our Oracle databases.

Thanks.

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 22 Dec 2006 10:27

Is there another download I have to install to make it work.
You've installed the right package. Make sure that you are in the Designer view.

tangster
Posts: 6
Joined: Thu 21 Dec 2006 17:34

Post by tangster » Fri 22 Dec 2006 12:15

I am in Design View and they are still grayed out. To be sure, I go to View, Designer or "Shift+F7". The "Common Device Controls" are not grayed out, but the others are. I am also in "Form1.vb[Design]" screen where I design my textboxes, lables and buttons.

Let me backtrack a little. After installation, I went to Project, Add Reference, in .NET, I added "CoreLab.Oracle". Then in the ToolBox, right click "General" tab,
Add Tab, I then added a "OraDirect" tab. right click to "Choose items", I checked off "OracleCommand", "OraclecommandBuilder", "OracleConnection", "OracleDataAdapter". clicked OK. The items are added to the tab "OraDirect", but the items are all grayed out.

Please help.

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 22 Dec 2006 17:04

Where did you choose CoreLab.Oracle.dll from?

tangster
Posts: 6
Joined: Thu 21 Dec 2006 17:34

Post by tangster » Fri 22 Dec 2006 17:28

Finally!!! The toolbox is there and not grayed out!!! Please forgive me if I'm tearing up.... I just got my Christmas present.
What I did was remove all versions of the CoreLab installs. I had done it a couple of times. From the Start, Program Files, CoreLab, Uninstall. And also from the Control Panel, Add/Remove Programs.

This time the computer installed the "OraDirect Mobile" tab by itself and put in the functions whereas the other times, this tab did not appear and I had to manually create.
You have to uninstall everything, reboot PC and install it again. Keep trying.

Thanks, Alexey, for your help.

Well, time to move on. Let's do some programming!!!

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 22 Dec 2006 17:41

Good luck.

tangster
Posts: 6
Joined: Thu 21 Dec 2006 17:34

Post by tangster » Fri 22 Dec 2006 18:25

I dragged the OracleConnection function over to the Handheld project. And I am able to connect to my Oracle server though "Connectionstring" and "Connect".

Do I need an Oracle datbase installed in the handheld? What would you recommend? Oracle Lite?

Now that the handheld can connect to the server. I need the the project form to have a connection to something in the handheld that will hold the data, like a database, but, What?

Thanks,
Tangster

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Mon 25 Dec 2006 09:54

You do not have to install Oracle on a handheld device. It is up to you.

tangster
Posts: 6
Joined: Thu 21 Dec 2006 17:34

Post by tangster » Tue 26 Dec 2006 12:47

If I don't need to install Oracle onto handheld, what kind of database would you recommend to be installed onto the handheld? So the form can connect to the database and then using OraDirect connectionstring to connect to Oracle server.

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Wed 27 Dec 2006 09:42

OraDirect .NET works with Oracle and connects from a handheld to the server, which is installed on a desktop. There is no need in installing anything onto handheld.

tangster
Posts: 6
Joined: Thu 21 Dec 2006 17:34

Post by tangster » Thu 28 Dec 2006 17:09

Alexey,
I am not connecting the handheld to the Oracle server wireless. I want to input/save data onto the handheld as a stand alone. Once the data is saved, I would dock the handheld and upload the data to the Oracle server through my PC. Wouldn't I need some sort of a database on the handheld?

Thanks,
Tangster

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 29 Dec 2006 07:54

OraDirect .NET may work in disconnected mode only (with a PC on whcih Oracle database resides).
Oracle Lite 9, 10 allows to store data locally on a hedheld, but OraDirect .NET doesn't work with such databases.

Post Reply