Re: MSSQL
Re: MSSQL
- Subject: Re: MSSQL
- From: Ted Thibodeau Jr <email@hidden>
- Date: Mon, 5 Feb 2007 19:32:56 -0500
* Finlay Dobbie [2007/02/05 10:58 PM +0000] wrote:
> Blimey. Last I looked at this, I don't think there were any available
> drivers. Admittedly, that was probably about 6 years ago...
Ahh, imperfect memory, how do I love thee...? Not much, I'm afraid.
Finlay, you were in contact with OpenLink Software in Feburary 2002
(confirmed in my email archives), when you had conversations with
both our CEO, Kingsley Idehen, and our Data Access Product Manager,
Hugh Williams, touching on both ODBC and our Virtuoso Universal
Server. I am pretty sure that contact started a year or more before
then, but that's when I was first CCed into the thread.
OpenLink has been shipping ODBC drivers and the iODBC driver manager
for Mac OS X since late 2000. Apple added iODBC to Darwin about six
months before Jaguar, in which iODBC was also included.
Sadly, Apple *still* doesn't ship the iODBC Frameworks which we have
been producing since the same time, and which better align with the
ADC docs on dynamic libraries for Cocoa and Mac OS X.
OpenLink's drivers have supported connection to MS SQL Server, Sybase,
Oracle, Informix, Ingres, PostgreSQL, MySQL, Progress, DB2, and others,
for a rather long time, since before first shipment on Mac OS X, also
covering client applications on Mac OS 9, Windows, Linux, Solaris,
HP-UX, and many other Unix-alikes.
In addition to ODBC, we also support JDBC, OLE DB, and ADO.NET/Mono
client applications, running on all those OS, wherever there's a JVM
or Mono port.
Much of which takes us beyond Cocoa.
As to Cocoa -- the iODBC Frameworks are available for Cocoa use, as
any C libraries are. (For best results, download and install the
full iODBC SDK, available precompiled from OpenLink, or as source
from Sourceforge. This brings bug-fixes not included in the Apple-
shipped libraries.)
http://www.iodbc.org/
http://sourceforge.net/projects/iodbc
'http://download.openlinksw.com/download/product_matrix.vsp?p=f_os&fm=1&fam=7&df=15'
The already mentioned ODBCKit framework is the only Obj-C wrapper
I'm currently aware of.
These frameworks enable the use of any iODBC-linked ODBC drivers,
including those from Actual and OpenLink.
In selecting the best driver for your needs, you may wish to spend
some time with OpenLink ODBC Bench (or its sister, JDBC Bench), both
available through Sourceforge. These open source tools simulate the
TPC-A and TPC-C benchmark suites on your own local infrastructure,
allowing apples-to-apples comparison of data source configurations
and connection options, drivers, driver managers, target DBMS, OS
and/or JVM versions, and more.
Tests are fully inspectable and extensible, to ensure that there is
no unfair favoring of one driver or database over another, and to
allow you to create more tests covering any needed API calls or
sequences not covered by the existing tests.
http://sourceforge.net/projects/odbc-bench
Hopefully this is helpful.
Be seeing you,
Ted
--
A: Yes. http://www.guckes.net/faq/attribution.html
| Q: Are you sure?
| | A: Because it reverses the logical flow of conversation.
| | | Q: Why is top posting frowned upon?
Ted Thibodeau, Jr. // voice +1-781-273-0900 x32
Evangelism & Support // mailto:email@hidden
OpenLink Software, Inc. // http://www.openlinksw.com/
http://www.openlinksw.com/weblogs/uda/
OpenLink Blogs http://www.openlinksw.com/weblogs/virtuoso/
http://www.openlinksw.com/blog/~kidehen/
Universal Data Access and Virtual Database Technology Providers
_______________________________________________
Cocoa-dev mailing list (email@hidden)
Do not post admin requests or moderator comments to the list.
Contact the moderators at cocoa-dev-admins(at)lists.apple.com
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
| References: | |
| | >MSSQL (From: Benjamin Gereon Bailey <email@hidden>) |
| | >Re: MSSQL (From: "Finlay Dobbie" <email@hidden>) |
| | >Re: MSSQL (From: Derek Chesterfield <email@hidden>) |
| | >Re: MSSQL (From: "Finlay Dobbie" <email@hidden>) |