[mapserver-users] - SQL Server 2008

[scott159 at free.fr]

Hi,

I would like connect MapServer 6.0.1 to MS SQL Server 2008. To use OGR driver with FreeTDS I try :

- to install FreeTDS from .\freetds-0.91 :

./configure --with-tdsver=7.2
sudo make
make install
make clean

Configure with only --with-tdsver ?

- to edit freetds.conf to configure MS Sql Server 2008 :

[servername1]
host = XX.XX.XX.XX
port = 1433

Only 2 variables to configure ?

- to try to connect MS SQL Server 2008 with ogrinfo : 

ogrinfo -al "MSSQL:server=servername1;driver=FreeTDS;database=EXAMPLE;trusted_connection=yes"

How ogrinfo can find freetds.conf file ?
servername1 must be found in freetds.conf ?
gdal 1.8 is it necessary to specify driver=FreeTDS ? 

But it's doesn't work, so I can't try with mapfile ;-(
What's wrong ?

scott