FreeTDS Development Group

[ikorot AT earthlink.net]

Fernando,


-----Original Message-----
>From: Fernando <fer.pantaneiro AT gmail.com>
>Sent: Jan 5, 2010 3:54 PM
>To: ikorot AT earthlink.net, FreeTDS Development Group 
><freetds AT lists.ibiblio.org>
>Subject: Re: [freetds] Problem with connection.
>
>Thanks for reply, and sorry not mention it.
>
>I'm trying to connect with a MS SqlServer 2008 using the freetds v0.82.
>
>Here are the result of my ./tsql -C
>
>Compile-time settings (established with the "configure" script)
>                                    Version: freetds v0.82
>                freetds.conf directory: /usr/local/freetds/etc
>   MS db-lib source compatibility: no
>       Sybase binary compatibility: no
>                           Thread safety: yes
>                              iconv library: yes
>                              TDS version: 5.0
>                                     iODBC: no
>                                  unixodbc: no
>
>And I successfuly connected with tsql, by the commnad: >./tsql -S
>sqlserver -U xxxxx -P xxxxx (using the freetds.conf file, not
>bypassing it)

That helps a lot. ;-)

>Here is my freetds.conf file:
>
># My SqlServer 2008 Microsoft server
>[sqlserver]
>        host = xxx.xxx.xxx.xxx
>        port = 1433
>        tds version = 8.0
>        timeout = 15
>        connect timeout = 20
>        dump file = /tmp/freetds.log
>        debug flags = 0x4fff

>>>/* works fine until here, then I got the error here, not even enter in
>>>the if statement */
>>>if ((dbconn = dbopen(login, DBSERVER)) == NULL)
>>>{
>>>       fprintf(stderr, "ERROR! dbopen() page1.c.\n");
>>>       return FALSE;
>>>}
>

According to the http://www.sybase.com/detail?id=897, one of the problem that
can result in the error 20009 is "The Server Name is not set correctly...".
Are you sure you have all login information correct?

Thank you.

>
>Thanks again.
>Fernando
>
>On Tue, Jan 5, 2010 at 5:43 PM,  <ikorot AT earthlink.net> wrote:
>> Hi, Fernando,
>>
>>
>> -----Original Message-----
>>>From: Fernando <fer.pantaneiro AT gmail.com>
>>>Sent: Jan 5, 2010 3:00 PM
>>>To: freetds AT lists.ibiblio.org
>>>Subject: [freetds] Problem with connection.
>>>
>>>Hi folks,
>>>
>>>I'm new in the FreeTDS world, and I'm building my first app with it.
>>>But I'm having a problem whit the "dbopen" function. When the app call
>>>it, the function return an error and the message: "FreeTDS: db-lib:
>>>exiting because client error handler returned 0 for msgno 20009".
>>>
>>>Does anyone knows what this error message mean??
>>>
>>>Regards,
>>>Fernando Castro
>>>Using openSUSE 11.2 "Emerald" and kernel 2.6.31.5-0.1-default.
>>
>> You didn't mention FreeTDS version and the server you are trying to
>> connect to...
>> It is also helpful to see the freetds.conf file content.
>>
>> But as usual try to do this:
>> 1. Try to connect using telnet.
>> 2. Try to connect using tsql.
>> 3. Try to connect using FreeTDS scripts.
>>
>> Thank you.
>>
>>>
>>>---------------------------------- My code -------------------------
>>>
>>>if (dbinit() == FAIL)
>>>{
>>>       fprintf(stderr, "page1.c %d: dbinit() failed\n",  __LINE__);
>>>       exit(1);
>>>}
>>>
>>>if ((login = dblogin()) == FAIL)
>>>{
>>>       fprintf(stderr, "ERROR! dblogin() page1.c.\n");
>>>       return FALSE;
>>>}
>>>
>>>DBSETLUSER(login, login_t.username);
>>>DBSETLPWD(login, login_t.password);
>>>
>>>if (gethostname(hostname, max_len) == 0)
>>>       DBSETLHOST(login, hostname);
>>>
>>>/* works fine until here, then I got the error here, not even enter in
>>>the if statement */
>>>if ((dbconn = dbopen(login, DBSERVER)) == NULL)
>>>{
>>>       fprintf(stderr, "ERROR! dbopen() page1.c.\n");
>>>       return FALSE;
>>>}
>>>_______________________________________________
>>>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
>>