Linux Mint 64 bit & MS SQL Server 2008 R2

Off-Topic
1

Recently, I made the switch from windows 7 to Linux Mint 16 Cinnamon - 64 bit in which I have found quite enjoyable; however, If I hit a snag in which a quick google search has been able to point me in the right direction.

Currently, I have a need to install ODBC on Linux Mint for me to connect to MS SQL Server 2008 R2 from Xojo. I have been searching for 2 days trying to find straight forward instructions; however, alot of them pertain to installing 64 bit ODBC drivers. here is the closest instructions I found for 32 bit… but it requests 32 bit version of Linux Mint link

I also tried to install IODBC

sudo apt-get install iodbc

but then I get an error when I try to launch iodbcadm-gtk

The program 'iodbcadm-gtk' is currently not installed. You can install it by typing: sudo apt-get install iodbc

At this point… I am not sure what direction to go any more. if any one has any pointers… i I would be eternally grateful.

thank you in advance.

2

Have you looked at the MBX Xojo SQL plugin? It may work for you as I believe that the iodbc is built into the plugin. Let us know how it goes if you decide to try it out.

3

Thank you Kevin.

I took a look at the MBS Xojo SQL plugin in which had Microsoft SQL via ODBC on Linux example project. Looking at the code, looks like it uses the FreeTDS driver in which I did installed and tested with tsql.

When I try to connect, looks like it gets stuck on:

con.Connect(cs,"","",SQLConnectionMBS.kODBCClient)

how can I check if FreeTDS is compiled for 32 bit?