473,503 Members | 1,705 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 1431
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
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.

--
---
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
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.

--
---
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
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.
>


--
---
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
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.
>>
>

--
---
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
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.
>


--
---
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
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.
>>
>

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

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

Nov 21 '05 #10
Aaron Smith <th**********@smithcentral.net> wrote in news:7BFqd.34343
$Q*******@newssvr33.news.prodigy.com:
Anyone have any experiance with either approach and if you did, did it
work well?


A webservice would work really well - have the webservice return data which
the PPC will parse and display.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
Nov 21 '05 #11
Aaron Smith <th**********@smithcentral.net> wrote in news:7BFqd.34343
$Q*******@newssvr33.news.prodigy.com:
Anyone have any experiance with either approach and if you did, did it
work well?


A webservice would work really well - have the webservice return data which
the PPC will parse and display.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
Nov 21 '05 #12
Aaron Smith <th**********@smithcentral.net> wrote in
news:gl*******************@newssvr33.news.prodigy. com:
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.
I think you mentioned screen scaping early right? You could write your own
screen scraper - but it'll probably cost more than just buying the ODBC
driver.
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.


Not to mention, it'll use a lot of bandwidth if you're planning on doing a
Terminal session - also it'll chew up the processors of the handhelds.

You're better off building the app specifically for the PPCs.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
Nov 21 '05 #13
Aaron Smith <th**********@smithcentral.net> wrote in
news:gl*******************@newssvr33.news.prodigy. com:
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.
I think you mentioned screen scaping early right? You could write your own
screen scraper - but it'll probably cost more than just buying the ODBC
driver.
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.


Not to mention, it'll use a lot of bandwidth if you're planning on doing a
Terminal session - also it'll chew up the processors of the handhelds.

You're better off building the app specifically for the PPCs.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
Nov 21 '05 #14

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

Similar topics

2
1683
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 --...
1
1670
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...
2
3476
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...
0
1127
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++. ...
1
1287
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
1741
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...
4
1478
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...
0
859
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...
2
4762
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...
0
7202
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7086
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...
0
7280
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7330
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6991
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...
0
7460
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...
1
5014
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...
0
3167
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...
0
3154
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

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.