Skip to Content.
Sympa Menu

freetds - Re: [freetds] SQL Server connectivity failure.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] SQL Server connectivity failure.
  • Date: Tue, 7 Jun 2011 09:27:15 +0200

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 <gopichandt AT gmail.com>:
> That resolved by changing the servername to ipaddress.
>
> Regards
> Gopi
>
> On Tue, Jun 7, 2011 at 4:04 PM, Igor Korot <ikorot01 AT gmail.com> wrote:
>
>> Gopi,
>> What parameters you're passing to isql?
>>
>> Thank you.
>>
>> On Mon, Jun 6, 2011 at 9:10 PM, Gopi Chand Telukoti
>> <gopichandt AT gmail.com> 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
>> > FreeTDS AT lists.ibiblio.org
>> > http://lists.ibiblio.org/mailman/listinfo/freetds
>> >
>> _______________________________________________
>> FreeTDS mailing list
>> FreeTDS AT lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>




Archive powered by MHonArc 2.6.24.

Top of Page