QT - SQL Server

[batrashish]

Hello,
I am trying to use QT and in that program, I need to fetch the data and upload the data from/to MS SQL server.

But by default there is no driver in raspberry pi.

Please let me know how to install QODBC Driver for QT.

This is very important for me.

Thank you in Advance for your help.

Regards,
Ashish

[FLYFISH TECHNOLOGIES]

Hi,

I am trying to use QT and in that program, I need to fetch the data and upload the data from/to MS SQL server.

You might try investigating also FreeTDS ODBC driver. I can remember some discussions about its successful usage on RasPi...
(I don't have any personal experiences with it.)


Best wishes, Ivan Zilic.

[batrashish]

Hello,
I have, successfully, installed UNIXODBC and FreeTDS on my Raspberry PI.
I want to use them for connecting to my MS SQL Server Database.

I am sure that this is done properly, since I am able to access my Datbase tables from the command prompt using :
$ tsql -S serverIP -U sql-username -P password

However, I do not know how to use this information in my QT program, so that I can access the information in my QT program.

Please let me know from where does QT get the path of ODBC drivers? And how to add the path of FreeTDS and UNIXODBC in that path?


Regards,
Ashish

[akc42]

I have had this running in the past on my 256Mb Early Model B pi. I was running a web site from it, which was contacting SQL Server 2008 R2 running on a Windows 7 Home Edition Virtual Machine (running Virtual Box under Debian Stable).

Instructions here

http://www.chandlerfamily.org.uk/2012/1 ... pache-php/