ODBC Connection in Linux

[Gablea]

Hi everyone,

I know you can use ODBC in FreeBASIC within a windows version of FreeBASIC I was just wondering if you can use ODBC inside a Linux version of a program?

I have been reading online that you can get ODBC drivers for Linux now and I was just interested in seeing what people think or have any one actually managed to get a ODBC connection to work and if so what was the code you was using.

as this web site http://www.unixodbc.org/ is showing you can use ODBC applications and connect to MySQL , MS Server etc

Andy

[MrSwiss]

A quick look shows that: the ODBC drivers are shared libraries (.so) so, the
use in FB, would be similar, to the use of .dll on Win (.so on 'ix: UNIX/LINUX).
No code from me on that one, I'm doing Win only ...

[Gablea]

@MrSwiss

Is using ODBC easier then direct connection to the database? (Like with mysql and FreeBASIC)

I did once do one of the examples On here for using ODBC in Windows and it work great. So would it be better to design a program that uses the ODBC interface to talk to the database server or to use a direct interface to it?

[MrSwiss]

@Andy,

I'd use ODBC because, it "abstracts" from the used RDBMS (any SQL-Server).
If you ever have to use a different DB, there will be no changes to the APPL. itself,
only on the ODBC connector setup ...

[Gablea]

@MrSwiss

That sounds like a good idea and if I had a setup ini file I could just change the DNS name in there (I did use ODBC with my old VB6 Version of my software)

Is there any examples on the FreeBASIC website for using
ODBC?