473,653 Members | 2,972 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

PocketPC and ODBC

I have a question... Will 3rd party ODBC drivers work on PocketPC? We
have drivers to connect to a proprietary database and I was wondering if
they would work on a handheld PDA running Windows CE or PocketPC 2003.
We have a project coming up that needs to grab info from these databases
and I need to know if it is one of our options..

Thanks,
Aaron
--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.
Nov 21 '05 #1
13 1444
Aaron,

Do you mean install the PC based ODBC drivers on the Windows CE device?
If this is the case then I very much doubt it. For a start they will be for
a different processor and unless they have written something specifically for
Windows CE then I would think you are out of luck.

Chris.

"Aaron Smith" wrote:
I have a question... Will 3rd party ODBC drivers work on PocketPC? We
have drivers to connect to a proprietary database and I was wondering if
they would work on a handheld PDA running Windows CE or PocketPC 2003.
We have a project coming up that needs to grab info from these databases
and I need to know if it is one of our options..

Thanks,
Aaron
--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.

Nov 21 '05 #2
Chris,

Yea that is what I meant. I since then found out that PPC doesn't
support databases like I had hoped. So we are going to move to a TCP/IP
communication solution to communicate with a server. One idea was to
just tell the device what form controls and text to display on the
screen from the server. My idea is to write all the screens we need
entry for and then just request and send data to/from the server.

Anyone have any experiance with either approach and if you did, did it
work well?

Aaron

Chris Podmore wrote:
Aaron,

Do you mean install the PC based ODBC drivers on the Windows CE device?
If this is the case then I very much doubt it. For a start they will be for
a different processor and unless they have written something specifically for
Windows CE then I would think you are out of luck.

Chris.

Nov 21 '05 #3
The way we did it is to have an application on the PPC that retrieves & sends
it's data to the server via a web service. Works quite well for our
application.

"Aaron Smith" wrote:
Chris,

Yea that is what I meant. I since then found out that PPC doesn't
support databases like I had hoped. So we are going to move to a TCP/IP
communication solution to communicate with a server. One idea was to
just tell the device what form controls and text to display on the
screen from the server. My idea is to write all the screens we need
entry for and then just request and send data to/from the server.

Anyone have any experiance with either approach and if you did, did it
work well?

Aaron

Chris Podmore wrote:
Aaron,

Do you mean install the PC based ODBC drivers on the Windows CE device?
If this is the case then I very much doubt it. For a start they will be for
a different processor and unless they have written something specifically for
Windows CE then I would think you are out of luck.

Chris.

Nov 21 '05 #4
I never even thought of a web service... The problem though is that I
don't think that is going to be an option for us. The data that we are
accessing is in DataFlex.. I think the main goal that they wanted was to
be able to use Visual DataFlex to retrieve the data and ship it out to
the handheld through TCP/IP...

Chris Podmore wrote:
The way we did it is to have an application on the PPC that retrieves & sends
it's data to the server via a web service. Works quite well for our
application.

"Aaron Smith" wrote:

Chris,

Yea that is what I meant. I since then found out that PPC doesn't
support databases like I had hoped. So we are going to move to a TCP/IP
communicati on solution to communicate with a server. One idea was to
just tell the device what form controls and text to display on the
screen from the server. My idea is to write all the screens we need
entry for and then just request and send data to/from the server.

Anyone have any experiance with either approach and if you did, did it
work well?

Aaron

Chris Podmore wrote:
Aaron,

Do you mean install the PC based ODBC drivers on the Windows CE device?
If this is the case then I very much doubt it. For a start they will be for
a different processor and unless they have written something specifically for
Windows CE then I would think you are out of luck.

Chris.

--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.
Nov 21 '05 #5
How are the PPC's going to connect to the server? GPRS, GSM, ActiveSync?

Does DataFlex have an ODBC? The web service could always use this to get the
data. I think a web service would be the quickest solution, to use some other
method would probably mean reinventing the wheel somewhere along the line.

"Aaron Smith" wrote:
I never even thought of a web service... The problem though is that I
don't think that is going to be an option for us. The data that we are
accessing is in DataFlex.. I think the main goal that they wanted was to
be able to use Visual DataFlex to retrieve the data and ship it out to
the handheld through TCP/IP...

Chris Podmore wrote:
The way we did it is to have an application on the PPC that retrieves & sends
it's data to the server via a web service. Works quite well for our
application.

"Aaron Smith" wrote:

Chris,

Yea that is what I meant. I since then found out that PPC doesn't
support databases like I had hoped. So we are going to move to a TCP/IP
communicati on solution to communicate with a server. One idea was to
just tell the device what form controls and text to display on the
screen from the server. My idea is to write all the screens we need
entry for and then just request and send data to/from the server.

Anyone have any experiance with either approach and if you did, did it
work well?

Aaron

Chris Podmore wrote:

Aaron,

Do you mean install the PC based ODBC drivers on the Windows CE device?
If this is the case then I very much doubt it. For a start they will be for
a different processor and unless they have written something specifically for
Windows CE then I would think you are out of luck.

Chris.

--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.

Nov 21 '05 #6
Unfortunately, in order to get ODBC for DataFlex, we have to purchase
it, which adds even more cost to this project. I will run it by the
bosses and see what they think about that.

The devices will connect through a wireless network in a building. We
bought a test device that has 802.11b capabilities. That is one of the
reasons I didn't like the idea of controlling what is on the screen of
the device from a server application. If it drops connection or can't
communicate, the device is dead in the water and you can't do anything.
If we just request and send information, we can at least continue on in
most instances.

Chris Podmore wrote:
How are the PPC's going to connect to the server? GPRS, GSM, ActiveSync?

Does DataFlex have an ODBC? The web service could always use this to get the
data. I think a web service would be the quickest solution, to use some other
method would probably mean reinventing the wheel somewhere along the line.

"Aaron Smith" wrote:

I never even thought of a web service... The problem though is that I
don't think that is going to be an option for us. The data that we are
accessing is in DataFlex.. I think the main goal that they wanted was to
be able to use Visual DataFlex to retrieve the data and ship it out to
the handheld through TCP/IP...

Chris Podmore wrote:
The way we did it is to have an application on the PPC that retrieves & sends
it's data to the server via a web service. Works quite well for our
applicatio n.

"Aaron Smith" wrote:

Chris,

Yea that is what I meant. I since then found out that PPC doesn't
support databases like I had hoped. So we are going to move to a TCP/IP
communicati on solution to communicate with a server. One idea was to
just tell the device what form controls and text to display on the
screen from the server. My idea is to write all the screens we need
entry for and then just request and send data to/from the server.

Anyone have any experiance with either approach and if you did, did it
work well?

Aaron

Chris Podmore wrote:
>Aaron,
>
>Do you mean install the PC based ODBC drivers on the Windows CE device?
>If this is the case then I very much doubt it. For a start they will be for
>a different processor and unless they have written something specifically for
>Windows CE then I would think you are out of luck.
>
>Chris.
>


--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.

--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.
Nov 21 '05 #7
That's the reason we went for a smart client rather than browser based. The
users of our software are out and about doing repairs and there's a good
chance they won't be able to get a mobile phone signal.

I haven't tried a wireless network connection but a web service should still
work fine.

I'd try and push the web service route, there would certainly be less code
to write to get the data to/from the device and you could then concentrate on
the core system code.
"Aaron Smith" wrote:
Unfortunately, in order to get ODBC for DataFlex, we have to purchase
it, which adds even more cost to this project. I will run it by the
bosses and see what they think about that.

The devices will connect through a wireless network in a building. We
bought a test device that has 802.11b capabilities. That is one of the
reasons I didn't like the idea of controlling what is on the screen of
the device from a server application. If it drops connection or can't
communicate, the device is dead in the water and you can't do anything.
If we just request and send information, we can at least continue on in
most instances.

Chris Podmore wrote:
How are the PPC's going to connect to the server? GPRS, GSM, ActiveSync?

Does DataFlex have an ODBC? The web service could always use this to get the
data. I think a web service would be the quickest solution, to use some other
method would probably mean reinventing the wheel somewhere along the line.

"Aaron Smith" wrote:

I never even thought of a web service... The problem though is that I
don't think that is going to be an option for us. The data that we are
accessing is in DataFlex.. I think the main goal that they wanted was to
be able to use Visual DataFlex to retrieve the data and ship it out to
the handheld through TCP/IP...

Chris Podmore wrote:

The way we did it is to have an application on the PPC that retrieves & sends
it's data to the server via a web service. Works quite well for our
applicatio n.

"Aaron Smith" wrote:

>Chris,
>
>Yea that is what I meant. I since then found out that PPC doesn't
>support databases like I had hoped. So we are going to move to a TCP/IP
>communicati on solution to communicate with a server. One idea was to
>just tell the device what form controls and text to display on the
>screen from the server. My idea is to write all the screens we need
>entry for and then just request and send data to/from the server.
>
>Anyone have any experiance with either approach and if you did, did it
>work well?
>
>Aaron
>
>Chris Podmore wrote:
>
>
>>Aaron,
>>
>>Do you mean install the PC based ODBC drivers on the Windows CE device?
>>If this is the case then I very much doubt it. For a start they will be for
>>a different processor and unless they have written something specifically for
>>Windows CE then I would think you are out of luck.
>>
>>Chris.
>>
>

--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.

--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.

Nov 21 '05 #8
Unfortunately, in order to get ODBC for DataFlex, we have to purchase
it, which adds even more cost to this project. I will run it by the
bosses and see what they think about that.

The devices will connect through a wireless network in a building. We
bought a test device that has 802.11b capabilities. That is one of the
reasons I didn't like the idea of controlling what is on the screen of
the device from a server application. If it drops connection or can't
communicate, the device is dead in the water and you can't do anything.
If we just request and send information, we can at least continue on in
most instances.

Chris Podmore wrote:
How are the PPC's going to connect to the server? GPRS, GSM, ActiveSync?

Does DataFlex have an ODBC? The web service could always use this to get the
data. I think a web service would be the quickest solution, to use some other
method would probably mean reinventing the wheel somewhere along the line.

"Aaron Smith" wrote:

I never even thought of a web service... The problem though is that I
don't think that is going to be an option for us. The data that we are
accessing is in DataFlex.. I think the main goal that they wanted was to
be able to use Visual DataFlex to retrieve the data and ship it out to
the handheld through TCP/IP...

Chris Podmore wrote:
The way we did it is to have an application on the PPC that retrieves & sends
it's data to the server via a web service. Works quite well for our
applicatio n.

"Aaron Smith" wrote:

Chris,

Yea that is what I meant. I since then found out that PPC doesn't
support databases like I had hoped. So we are going to move to a TCP/IP
communicati on solution to communicate with a server. One idea was to
just tell the device what form controls and text to display on the
screen from the server. My idea is to write all the screens we need
entry for and then just request and send data to/from the server.

Anyone have any experiance with either approach and if you did, did it
work well?

Aaron

Chris Podmore wrote:
>Aaron,
>
>Do you mean install the PC based ODBC drivers on the Windows CE device?
>If this is the case then I very much doubt it. For a start they will be for
>a different processor and unless they have written something specifically for
>Windows CE then I would think you are out of luck.
>
>Chris.
>


--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.

--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.
Nov 21 '05 #9
That's the reason we went for a smart client rather than browser based. The
users of our software are out and about doing repairs and there's a good
chance they won't be able to get a mobile phone signal.

I haven't tried a wireless network connection but a web service should still
work fine.

I'd try and push the web service route, there would certainly be less code
to write to get the data to/from the device and you could then concentrate on
the core system code.
"Aaron Smith" wrote:
Unfortunately, in order to get ODBC for DataFlex, we have to purchase
it, which adds even more cost to this project. I will run it by the
bosses and see what they think about that.

The devices will connect through a wireless network in a building. We
bought a test device that has 802.11b capabilities. That is one of the
reasons I didn't like the idea of controlling what is on the screen of
the device from a server application. If it drops connection or can't
communicate, the device is dead in the water and you can't do anything.
If we just request and send information, we can at least continue on in
most instances.

Chris Podmore wrote:
How are the PPC's going to connect to the server? GPRS, GSM, ActiveSync?

Does DataFlex have an ODBC? The web service could always use this to get the
data. I think a web service would be the quickest solution, to use some other
method would probably mean reinventing the wheel somewhere along the line.

"Aaron Smith" wrote:

I never even thought of a web service... The problem though is that I
don't think that is going to be an option for us. The data that we are
accessing is in DataFlex.. I think the main goal that they wanted was to
be able to use Visual DataFlex to retrieve the data and ship it out to
the handheld through TCP/IP...

Chris Podmore wrote:

The way we did it is to have an application on the PPC that retrieves & sends
it's data to the server via a web service. Works quite well for our
applicatio n.

"Aaron Smith" wrote:

>Chris,
>
>Yea that is what I meant. I since then found out that PPC doesn't
>support databases like I had hoped. So we are going to move to a TCP/IP
>communicati on solution to communicate with a server. One idea was to
>just tell the device what form controls and text to display on the
>screen from the server. My idea is to write all the screens we need
>entry for and then just request and send data to/from the server.
>
>Anyone have any experiance with either approach and if you did, did it
>work well?
>
>Aaron
>
>Chris Podmore wrote:
>
>
>>Aaron,
>>
>>Do you mean install the PC based ODBC drivers on the Windows CE device?
>>If this is the case then I very much doubt it. For a start they will be for
>>a different processor and unless they have written something specifically for
>>Windows CE then I would think you are out of luck.
>>
>>Chris.
>>
>

--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.

--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.

Nov 21 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
1692
by: smaggi | last post by:
I have a VB.NET pocketpc application that I need to port to the desktop. What is the best way to do this? Does anyone know where there is a list of steps or checklist? Thanks -- http://www.cyranocommunicator.com
1
1679
by: Lau | last post by:
I need to synchronize data between a PocketPC application (C#) and a FileMaker database every time the PocketPC is in it’s cradle. FileMaker has a ODBC-plugin, but SQL.CE unly allow me to interact with a MS SQL Server? Should I try to establish a Serial connection? Is this possible while Active Sync is running? Could I access a file on the computer thru Active Sync? I would like to have control of how often the file is read and written...
2
3480
by: Pawan Aggarwal | last post by:
I'm having trouble with calling an exported function in a native DLL compiled with eMbedded Visual C++ in C# application in PocketPC 2002 OS. Problem Description follows: I have one exported function in the DLL: I am making an application for pocket Pc in C# using this DLL Function. whenever I execute this exe in Pocket pc it returns MissingMethod Exception.
0
1131
by: DL | last post by:
I have an existing application I'm porting to the Windows PC and PocketPC platforms. The UI will be designed from scratch using Visual Studio .NET tools and C#, but key pieces are written in C++. I've read that .NET 2003 only supports PocketPC with C# and VB, not C++. For C++ the eMbedded tools must be used. However, ideally I'd like one code base and tool chain for the PocketPC and PC platforms. Therefore, the question is this: How do...
1
1294
by: Keith Smith | last post by:
What is the process for creating setup files for a PocketPC app? (I already know how to create the PocketPC app.)
6
1749
by: db | last post by:
I need to write some basic code that will let me send messages to/from a PocketPC. In the past, when I was using VB6, I did this using the Winsock control and setting one machine as the client and the other as the server. I assume I could take a similar approach here, but wanted to see if anyone could give me any suggestions as to where to start. I'm using .NET 2003 and Windows Mobile 2003 if that helps. This is nothing really complex,...
4
1487
by: Steven Nagy | last post by:
Hi all, I have a situation at work where I need to connect a Palm to an SQL Server or Access database. I'm a bit stuck as to how to proceed. I have scoped an XML client/server architecture to deal with this, however I don't want the server side to actually have IIS so Web services are out. An alternative is to use the webservices2 dll which I have downloaded and can manage a SOAP client and SOAP server interconnection on a standard app,...
0
862
by: tirumalab | last post by:
HI there, I was trying to call a C# smartdevice dll from VC++ pocket PC console application both were developed using VS.NET 2005. i've registered the dll with the registry and created the tlb file using the utility Regasm. And i imported the tlb file into my VC++ PocketPC application . I found in many sites that to use the C# dll inVC++ PocketPC application we've to set one option Common Language Support to...
2
4773
by: ketty_ng81 | last post by:
No matter how many dial up networking entries I have, the RASWrapper.RasEnumEntries(null , null , entryNames, ref cb, out entries); always returns the right number of elelments in entryNames but only the first element has the connection name in it. Any idea why this is? Thank you for your help. Some code for your reference. let me know if you need more code: public enum RasFieldSizeConstants {
0
8283
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
8470
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8590
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6160
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5620
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4147
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2707
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1914
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1591
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.