Skip to Content.
Sympa Menu

freetds - Re: [freetds] db-lib: msgno 20002

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Kevin Voell <kevin.voell AT mac.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] db-lib: msgno 20002
  • Date: Sat, 24 May 2008 22:04:55 -0600

Please ignore this whole thread I finally got it working.

Had to recompile my freetds libraries, I must have compiled them incorrectly the first time.

I now have an xcode cocoa application returning data from a MS SQL database.

Once I get a good example or two I will submit them to be included with the distribution, with the hope they will be useful to someone else.

Thanks


On May 24, 2008, at 3:54 PM, Kevin Voell wrote:

D'oh I forgot to include the error and message handler functions.

So I got past that error now I'm getting:
SQLTester: Msg 20017, Level 9
Unexpected EOF from the server

SQLTester: Msg 20002, Level 9
Adaptive Server connection failed

Any thoughts on these?

Thanks


On May 24, 2008, at 2:49 PM, Kevin Voell wrote:

Trying to get freetds working under xcode and am not having any luck.

I'm currently getting this error when calling dbopen();
FreeTDS: db-lib: exiting because client error handler returned 0 for
msgno 20002


Here the code I currently have:
#import <Cocoa/Cocoa.h>
#import "sybdb.h"
#import <string.h>

char SERVER[512];

int main(int argc, char *argv[])
{
LOGINREC *login;
DBPROCESS *proc;

// attempt to initialize the db-lib engine
if (dbinit() != YES)
NSLog(@"Could not initialize the db-lib");

// allocate a LOGINREC structure
login = dblogin();

// set the login information
DBSETLPWD(login, "Test");
DBSETLUSER(login, "Test");

strcpy(SERVER, "10.0.1.8:1433");

// attempt to login
proc = dbopen(login, SERVER);

// free the LOGINREC structure
dbloginfree(login);
}

Here the code I currently have:
I've checked and dbinit is returning ok and dblogin returns a valid
pointer.
I'm trying to connect to a MS SQL server 2008.

Any ideas?

Thanks

Kevin


On May 14, 2008, at 10:10 PM, Kevin Voell wrote:

Hi

I was wondering if anyone has any examples for using freetds with
xcode or objective-c.
I just downloaded and compiled freetds and I am making my way
through the documentation. But if anyone has some objective-c code
they are willing to share, it will give me a nice head start. I
found the C examples and I will work on converting them to objC, but
I thought I would see if anyone has done that already.

Thanks

Kevin
_______________________________________________
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