Re: SQL Server connectivity failure.

Please read http://www.freetds.org/userguide/odbcconnattr.htm, the
correct parameter you want to use is server, not servername!

freddy77

2011/6/7 Gopi Chand Telukoti <[email protected]>:
> That resolved by changing the servername to ipaddress.
>
> Regards
> Gopi
>
> On Tue, Jun 7, 2011 at 4:04 PM, Igor Korot <[email protected]> wrote:
>
>> Gopi,
>> What parameters you're passing to isql?
>>
>> Thank you.
>>
>> On Mon, Jun 6, 2011 at 9:10 PM, Gopi Chand Telukoti
>> <[email protected]> wrote:
>> > SQL Server connectivity failing with below info. Testing using isql
>> > EngineRoom username  password getting this error message
>> >
>> > "[ISQL]ERROR: Could not SQLConnect"
>> > Where's the error?
>> >
>> > cat /etc/unixODBC/odbc.ini
>> > [ODBC Data Sources]
>> > MarketResearch = SQL Server
>> > EngineRoom = SQL Server
>> > [MarketResearch]
>> > Driver = TDS
>> > Description = Market Research
>> > Trace = Yes
>> > TraceFile = /tmp/mstest.log
>> > Servername = mi
>> >
>> > [EngineRoom]
>> > Driver = TDS
>> > Description = Engine Room
>> > Trace = Yes
>> > TraceFile = /tmp/mstest.log
>> > Database = Engine_Room
>> > Servername = WSDB0515V
>> > Port = 1433
>> >
>> > [Default]
>> > Driver = /wa01/aamie/app/src/freetds/lib/libtdsodbc.so
>> > _______________________________________________
>> > FreeTDS mailing list
>> > [email protected]
>> > http://lists.ibiblio.org/mailman/listinfo/freetds
>> >
>> _______________________________________________
>> FreeTDS mailing list
>> [email protected]
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds