Cant' connect to MSSQL remotely

[Anon]

HI,

I have some problem connect to a remote MSSQL(running on Window200 Advance server) from my LInux(Redhat7.2) machine, in LAN environment.

when i do odbc_connect, it gimme this error:

Warning: SQL error: [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded, SQL state IM002 in SQLConnect in /usr/local/apache/htdocs/index2.php on line 8

I have install iodbc which download from www.iodbc.org. I try to do 'odbctest' to list the available DNS, but failed.

Can anyone give me a guidline what should I do after I ./configure the iodbc to my LInux machine. And also how to configure the odbc.ini and odbcinsta.ini? I belive I

Thanks
Louis
[e-mail]
(welcome to email me if you have any suggestion/advise).

[eklee]

Here is the way i recompile my PHP4.1.2 to support odbc_ funtion:

'./configure' '--enable-track-vars' '--with-zlib' '--with-mysql=/usr/local/mysql' '--disable-debug' '--enable-ftp' '--with-apache=../apache_1.3.23' '--enable-inline-optimization' '--with-xml' '--with-dom' '--with-swf=/usr/local' '--with-mhash' '--with-mcrypt' '--with-imap' '--with-mnogosearch' '--with-gd=/home/users/siteadm/src/gd-1.8.4' '--enable-dbx' '--with-mssql=/usr/local/freetds' '--with-iodbc=/usr/local/iodbc'.

THanks