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