Re: Apple xcode or objective-c example

HA!

Well that explains it, thanks Craig!  OK time to setup a MS SQL server.

I will continue my xcode journey with that, I only used mySQL because  
I had it setup already on one of my boxes.

Once I get it working with MS SQL I will share my xcode examples.

Thanks

Kevin

On May 18, 2008, at 8:39 PM, Craig A. Berry wrote:

> At 6:39 PM -0600 5/18/08, Kevin Voell wrote:
>> I'm making some progress on a getting freetds example working with an
>> xcode application.
>>
>> I have gotten apps/bsqldb.c to compile successfully with xcode, but I
>> get the following error when I run it:
>>
>> Current language:  auto; currently objective-c
>> (null): Msg 20009, Level 9
>> Unable to connect: Adaptive Server is unavailable or does not exist
>>
>> Assertion failed: (dbproc != NULL), function main, file /Users/Kevin/
>> Documents/Source/Code/cocoaSQL/main.m, line 182.
>>
>> Line 182 is:
>> dbproc = dbopen(login, options.servername);
>>
>>
>> The SQL server I'm trying to connect to is a mySQL 5.0 server running
>> on another one of my OS X boxes.  I am able to connect to the server
>> using CocoaMySql (an OS X admin tool) so I know the server is running
>> and is accessible.
>>
>> Guess my question is what is an adaptive server?
>
> Sybase Adaptive Server is one of several marketing names Sybase has
> used over the years to describe their relational database software.
> Databases from Sybase and Microsoft are the only ones that use the
> TDS protocol and to which FreeTDS client libraries and utilities can
> connect.  MySQL does not use TDS and cannot possibly be a successful
> connection target for FreeTDS, nor can Oracle, DB2, Ingres,
> PostgreSQL, or other database packages, each of which has its own
> wire-level protocol for interacting with clients.  (The exception to
> this would be any database that has server-side plug-in emulation
> specifically designed to interact with clients using TDS, but that's
> speculative and I have no idea whether such a beast actually exists).
>
> Even though FreeTDS does not seem likely to be of benefit to you
> (unless you have a Sybase or Microsoft SQL Server database elsewhere
> on your network?) I hope you will share any changes you needed to
> make to get it to compile under XCode, as they will likely be
> beneficial to others.
>
> -- 
> ________________________________________
> Craig A. Berry
> mailto:[email protected]
>
> "... getting out of a sonnet is much more
> difficult than getting in."
>                 Brad Leithauser
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds