Last post Jul 24, 2012 05:01 PM by sdiazc
Jan 24, 2012 06:59 AM|harsh288|LINK
I will be having a new scanner soon where Windows OS 6.5 is installed,
So my question is whether a direct conection can be made between
a scanner and database without using any kind of webservice.
Are there any Oracle ODBC drivers provided in Windows OS 6.5
Jan 24, 2012 08:49 AM|b471code3|LINK
You can use SQL CE on the moble device and your app will have a direct connection to the database located on that device. You could create a local network connection to the database but once the connection was broken (lost wireless signal, or LAN connection)
your program would most likely break. The last Mobile 6.5 app I developed used SQL Merge Replication and had a local database on the device and performed a sync (when the user clicked a button) to the main database. As long as the user had an interent connection
the sync was able to happen and it didn't matter if they were in the office it was developed in, somewhere in the US or China, it performed a sync based on a public facing, secured URL.
Jan 25, 2012 02:43 PM|harsh288|LINK
Thanks for replying, if possible please provide links for SQL CE.
I don't want to create a local database on scanner.
Actually the scanner will performs operations like scanning and so on
and it will update accordingly on the database which will be a server.
And it will be a Oracle Database.
Jan 25, 2012 03:20 PM|b471code3|LINK
If you don't want a local database on the device then there is no reason for me to provide links to SQL CE. If you wanted to learn more about it out of curiosity, a simple google search on sql server ce would bring you a number of results.
In my opinion you have 2 options then:
As far as I know there are no mobile drivers for direct connect to Oracle dabase on WM 6.5.
Jan 27, 2012 10:57 AM|harsh288|LINK
My research is without webservice as we already had a scanner which connects to database through webservice.
I thought Windows OS 6.5 has such features like it has SDK's which provides ODBC drivers.
Also do you have any idea about Oracle database mobile lite, I guess it can be installed on scanner.
Jan 27, 2012 11:13 AM|b471code3|LINK
There is an SDK for WM but I don't know about the ODBC drivers. If that were the case then I'm guessing you might be able to do a direct connect to the Oracle database via wireless. Only downfall I see is for every write action that happens to the database
you would have to check to see there was a connection first. And what if you lose connection in the middle of a transaction? Roll it back?
I think the more robust solution would be to store the data or subset of data on the device and provide a sync feature when the user is finished or whenever they want.
You might check Oracle's website for the other option of using a mobile version of the database.
Jul 24, 2012 05:01 PM|sdiazc|LINK
I have a scenario similar to yours, i would like to develop a component that connects directly to an oracle server, did you find a solution? or which was your workaround to solve this requirement
Thanks in advance!