more quick actions
minimize quick actions
Hello,
I got a question from a customer, they asked could PcVue(on Windows) store data to Oracle on mimi-computer which is Unix?
In my opinion, it should work as PcVue has ODBC to connect Oracle and Unix system supports the ODBC also.
Have we had this kind of project running on site? And what about the performance?
Posted : 13/12/2013 10:06 am
ODBC is not really performant and not really secure.
Moreover it depends on how the ODBC driver is...
Posted : 13/12/2013 3:49 pm
Hi Nico,
Thanks, yes we are afraid of the performance and security as the customer said they may use the mimi-computer to store data in order to keep data more safety.
BTW, from the wikipidea: The designers of ODBC aimed to make it independent of database systems and operating systems; an application written using ODBC can be ported to other platforms, both on the client and server side, with few changes to the data access code.
Posted : 16/12/2013 1:05 pm
Security is not in a sense that you data wont be protected. It's more in the sense that, if the connection between PcVue and the database is broken then all PcVue data are thrown (no buffer like HDS).
The Wikipedia quote is OK but very theoretic. In the reality you can find in PcVue code "if Oracle then..., If SQL Server then...).
By the way, the way the driver has been implemented can influence dramatically the performances.
Posted : 16/12/2013 1:20 pm
when you say "By the way, the way the driver has been implemented can influence dramatically the performances.", do you have some info to share? 🙂
Posted : 16/12/2013 2:01 pm
No but it's logic.
If Oracle didn't implement well the driver then it wont work well isn't?
Posted : 16/12/2013 3:34 pm
Yes, that's the engineer's thinking. 🙂
Posted : 16/12/2013 3:46 pm