Since you are talking about ODBC - Linux Apache SQL - all subjects close to my heart. May I jump in.

Where are you at in development ? Tamil, do you need help setting up a system, or are you managing one already setup. ?
Are you making a choices here, or are the choice of servers and development evniorment already been set. ?

I assume you already have apache running, and just need to get a connection to the sql server, to publish web forms. if thats correct. you are just missing one pc of the puzzle.
that is some method of scripting the sql calls to the mssql server, the scripting can be done in perl (you should like hearing that) or php, or ASP (as chili soft has an add in module for ASP on linux apache)
any of these scripting methods, can require odbc, or may not even require odbc, that depends. on what you have running. Php has a direct connection to sql server, without using odbc, and I think ASP has conneciton direct to mssql, however, if you are hosting it on an apache - linux server... well, you might have to install a plugin of sorts.

But... to wade through this quagmire. I would suggest that you at least take a look at www.codecharge.com they have a little pc of software. which writes basic web sites, in just a few hours, no matter what the datasource, and no matter what scripting method you choose. asp - php perl. whatever.

then study the code that it generates. *the asp or php code) and see exactally what they do.... its a good learning curve.

they have a free download for 30 days. and the code that it generates is quite easy to follow.

anyway, thats my thoughts for the evening.
Bob Lee



>hi michael,
>thanks for your reply,
>i have a plan to use only ODBC. And pls. let me know more about Linux ODBC
>
>
>thanks
>
>tamil