[freetds] [unixODBC][FreeTDS][SQL Server]Only one between SERVER, SERVERNAME and DSN can be specified

Discussion:

venkata krishna Thaluru

2014-09-19 18:00:19 UTC

Hi All,
I am getting below error and while connecting to mssql.

[unixODBC][FreeTDS][SQL Server]Only one between SERVER, SERVERNAME and DSN
can be specified

I have checked the code in freeTDs ,We are checking whether we have
configured one ,then we are throwing this error.

Could you please let me know ,if i missed any configuration in any file.

Thanks in advance

Thanks
Venkata Krishna

Frediano Ziglio

2014-09-19 18:18:55 UTC

Permalink

2014-09-19 19:00 GMT+01:00 venkata krishna Thaluru <

Post by venkata krishna Thaluru
Hi All,
I am getting below error and while connecting to mssql.
[unixODBC][FreeTDS][SQL Server]Only one between SERVER, SERVERNAME and DSN
can be specified
I have checked the code in freeTDs ,We are checking whether we have
configured one ,then we are throwing this error.
Could you please let me know ,if i missed any configuration in any file.
Thanks in advance
Thanks
Venkata Krishna

No missing configuration, only there are conflicting options.

Frediano

venkata krishna Thaluru

2014-09-20 12:23:20 UTC

Permalink

Thanks for reply Frediano,
Could you please let me know ,what are the conflicting options.

Thanks in advance .

Thanks
Venkata Krishna

On Fri, Sep 19, 2014 at 11:48 PM, Frediano Ziglio <freddy77 at gmail.com>

Post by Frediano Ziglio
2014-09-19 19:00 GMT+01:00 venkata krishna Thaluru <

Post by venkata krishna Thaluru
Hi All,
I am getting below error and while connecting to mssql.
[unixODBC][FreeTDS][SQL Server]Only one between SERVER, SERVERNAME and

DSN

Post by venkata krishna Thaluru
can be specified
I have checked the code in freeTDs ,We are checking whether we have
configured one ,then we are throwing this error.
Could you please let me know ,if i missed any configuration in any file.
Thanks in advance
Thanks
Venkata Krishna

No missing configuration, only there are conflicting options.
Frediano
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

--
*Thanks&RegardsVenkatakrishna.T*

*HCL TECHNOLOGIES Ltd.09600185503/09908611807*

Frediano Ziglio

2014-09-20 12:30:28 UTC

Permalink

You can have only one between SERVERNAME, SERVER and DSN.

If you post your configurations files surely the configuration you are
trying to use has such mistake.

Frediano

Frediano

2014-09-20 13:23 GMT+01:00 venkata krishna Thaluru <

Post by venkata krishna Thaluru
Thanks for reply Frediano,
Could you please let me know ,what are the conflicting options.
Thanks in advance .
Thanks
Venkata Krishna
On Fri, Sep 19, 2014 at 11:48 PM, Frediano Ziglio <freddy77 at gmail.com>

Post by Frediano Ziglio
2014-09-19 19:00 GMT+01:00 venkata krishna Thaluru <

Post by venkata krishna Thaluru
Hi All,
I am getting below error and while connecting to mssql.
[unixODBC][FreeTDS][SQL Server]Only one between SERVER, SERVERNAME and

DSN

file.

Post by Frediano Ziglio

Post by venkata krishna Thaluru
Thanks in advance
Thanks
Venkata Krishna

--
*Thanks&RegardsVenkatakrishna.T*
*HCL TECHNOLOGIES Ltd.09600185503/09908611807*
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

venkata krishna Thaluru

2014-09-20 14:16:18 UTC

Permalink

Thanks for reply Frediano,
I am done below steps.if i missed or done wrong please correct me .
1)I have downloaded 0.91 from freetds location.
2)copied to 64 bit dev machine OS is linux
3)i have the run following commands ./configure ,make ,make install
4)then copied following binaries.
./src/odbc/.libs/libtdsodbc.so
./src/dblib/.libs/libsybdb.so
./src/ctlib/.libs/libct.so

5)odbc.ini
[DSNNAME]
driver = <location of libtdsodbc.so>
ServerName = RemoteServer

6)freetds.conf
<RemoteServer>
host=IP address
port =1433
tds version =8.0

Could you please let me know if i missed any thing .
Thanks in advance.

Thanks
Venkata Krishna

Post by Frediano Ziglio
You can have only one between SERVERNAME, SERVER and DSN.
If you post your configurations files surely the configuration you are
trying to use has such mistake.
Frediano
Frediano
2014-09-20 13:23 GMT+01:00 venkata krishna Thaluru <

Post by Frediano Ziglio
2014-09-19 19:00 GMT+01:00 venkata krishna Thaluru <

Post by venkata krishna Thaluru
Hi All,
I am getting below error and while connecting to mssql.
[unixODBC][FreeTDS][SQL Server]Only one between SERVER, SERVERNAME

and