database programming from linux

vdx · 09-24-2007, 04:55 AM

helo frnds,

I wanna make an application tht can interact with ms sql database.

I am using rhel5 and doing program in C (gcc).

So I have downloaded the libiodbc rpm and installed it on my system.

So the problem I havnt any good tutorial on libiodbc, which can explain libiodbc functionalities, and I can make a program in C for database operations.

If any one finds good tutorial on libiodbc then plz replay me.

thnx in advance.

tronayne · 09-26-2007, 06:04 AM

You may want to start with the C API section of the MySQL manual; see http://dev.mysql.com/doc/refman/5.0/en/c.html (you don't need ODBC to embed SQL in a C program).

vdx · 09-27-2007, 01:32 AM

thnx tronayne

the page "http://dev.mysql.com/doc/refman/5.0/en/c.html" is really a good for me.

just like this, is there any good tutorial on ms sql server ??

tronayne · 09-27-2007, 09:05 AM

Quote:

just like this, is there any good tutorial on ms sql server ?

This is where Google is your friend; querying "sql tutorial" turns up 577,000+ hits.

In addition, http://dev.mysql.com/books/mysqlpress/index.html shows useful publications.

indienick · 09-27-2007, 03:16 PM

MSSQL are to generic SQL as J++ is to Java - Microsoft's *inferior* take on a successful thing.

My work uses an MSSQL database - and while I've never had to have to interact with the database, I've been informed that it's quite a pain in the butt. Our software engineer grumbles about it a little - (not (equalp 'SQL 'MSSQL)).

hob · 09-29-2007, 03:57 AM

The FreeTDS project provides libraries specifically for interfacing with MS SQL Server, which may be better than the generic ODBC stuff:

http://www.freetds.org/

vdx · 10-01-2007, 01:27 AM

thnx tronayne, indienick, hob and all LQ frnds.

I am very much thnkful to LQ.

Support of LQ frnds is really a backbone for me.

thnx 1s again

indienick · 10-02-2007, 07:10 AM

You're very welcome.