I am using rhel5 and using C for development.

I have 2 PCs, I have installed RHEL5 in first pc for development and in another pc I have installed Windows XP and also SQL Server 2000 (for DB server).

I want to make a program (in rhel5) which can interact with MS SQL Server 2000.

So for tht I have downloaded and installed libiodbc, libiodbc-devel and libiodbc-admin.

And also searched with google for good tutorial abt how to make odbc connection.

I found good tutorials but no any tutorial hav cleared steps for "How to make DSN(Data Source Name)".

DSN means "Data Source Name", but wt it actually means ? (like is it kinda driver or text string or ...).

So I hav 2 questions.

1) Wt DSN actually means ?

2) How to create DSN on Linux machine ?

thnx in advance...

(if is there any good tutorial plz let me know)

> I want to make a program (in rhel5) which can interact with MS SQL
> Server 2000.
> So for tht I have downloaded and installed libiodbc, libiodbc-devel
> and libiodbc-admin.

I'd recommend unixODBC over iODBC.

> And also searched with google for good tutorial abt how to
> make odbc connection.

I can't understand how you could fail to find one. The ODBC *concepts* are the same on any platform; UNIX, Windows, or LINUX.

> DSN means "Data Source Name", but wt it actually means ?

It names a data source and the parameters required to connect like which driver to use, host name, port and possibly username/password.

> 2) How to create DSN on Linux machine ?

You use one of the provided tools or edit the appropriate INI file.

ftp://kalamazoolinux.org/pub/pdf/dbaccess.pdf

thnx whitemice

thnk u very much for replay and clarify my doubts.

I got wt I need, thnx 1s again.