[freetds] db-lib: msgno 20002
Kevin Voell
kevin.voell at mac.com
Sun May 25 00:04:55 EDT 2008
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
More information about the FreeTDS
mailing list