How to connect MS SQLServer using ODBC on the arm-linux platform?

sczhengyabin

Hi,
I'm using a board with a S3C6410 chip, running a linux 2.6 and Qt4.7 GUI.

  I've been trying to build a toolkit to develop a program that envolves connection to a MS SQLServer.

  I've searched a lot materials and blogs, many says it needs the "unixODBC" and the "FreeTDS".

  I'm kind of new to Qt embedded development, so could anyone tell what exactly I should do to achieve this one.

SGaist

Hi and welcome to devnet,

Are you going to deploy your devices so that they have to connect to the server from several unrelated places ?

If so, I would recommend using a web service to access the database, otherwise you will have to open in over internet and that's really not recommended.

Hope it helps

AGBrasil

Hi SGaist,

I have the same situation.
I need to develop one application in ARM9 embedded linux, with QT, and this connect with database in server (Have many possibilities of databases - Ex: Oracle, MS SQL, MySQL, Postgress, ...).
I've searched in internet, and many says "unixODBC" or "FreeTDS".

My application run just in the LAN (local) not in the internet.
My conclusion is ODBC or JDBC is more fast with web services.

What's options have for connect with the database in Server ?
If I not have defined the database vendor (server side), I believe is ODBC is correct choice ??

I develop in UBUNTU and I've created the OCI Oracle drive to connect to o Oracle Database (in QT)... But OCI drivers for ARM I belive not possible to compile, because Instant Client of Oracle not have for ARM ... Correct ??

What's the best database client for ARM I use with QT... ???
And this have unixODBC drive ??

If I use MySQL in server side, MySQL in ARM and use unixODBC... It's possible to compile ??
Thanks,

Adio

SGaist

Hi and welcome to devnet,

What distribution are you running on your device ?

AGBrasil

My Board is MINI6935 - Atmel ARM9 AT91SAM9x35 based Single Board Computer

Atmel ARM926EJ-S™ 32-bit processor running at up to 400MHz
Linux2.6.39 operating system
Linux QT graphic
Supporting multiple filesystems such as ROM/CRAM/EXT2/EXT3/FAT/NFS/JFFS2/YAFFS2/UBIFS

In my desktop - Development:

UBUNTU 12.04 with QT OPENSOURCE 5.2.1
My server is Oracle 11G 11.2.0.1

I have sucesfully compiled the OCI Oracle drive for desktop (with SDK / Instant Client Oracle). I my desktop I connect use OCI with database.

But I need connect my ARM device (in local network) direct with the database.

And is possibilities in future I change the database vendor (server - other databases).

AGBrasil

Linux 2.6.39 is BSP

SGaist

AFAIK, you will need to first cross-compile the needed libraries e.g. unixODBC. You might find some libraries implementing OCI (AFAIK, Oracle doesn't provide any) but then again, you'll have to cross-compile it yourself.

Once you have them you will be able to compile the corresponding Qt plugins

ealltech

My Board is MINI6935 - Atmel ARM9 AT91SAM9x35 based Single Board Computer Quad Core
Atmel ARM926EJ-S™ 32-bit processor running at up to 400MHz
Linux2.6.39 operating system
Linux QT graphic
Supporting multiple filesystems such as ROM/CRAM/EXT2/EXT3/FAT/NFS/JFFS2/YAFFS2/UBIFS