Skip to Content.
Sympa Menu

freetds - Re: [freetds] Problem with connection.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: ikorot AT earthlink.net
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>, freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] Problem with connection.
  • Date: Tue, 5 Jan 2010 15:43:09 -0500 (EST)

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





Archive powered by MHonArc 2.6.24.

Top of Page