First, download the latest odbc manager for os x from openlink, it is free, and is better than apple's. For one thing, the apple manager will not let you use the "_" character in datasources and such, which just boggles my mind.
The ODBC driver for MS SQL is highly configurable and tunable, and openlink has pretty good docs. It performs very well.
Also, openlink has good support, and will fix a bug fairly quickly if you can report it in a way they can reproduce. Microsoft is not going to be of much help there. As you know, the single biggest performance benefit to Witango is the fastest connection possible to your dbms. I have tested JDBC vs. ODBC, and ODBC has been much faster.
You can download a 30 day trial of the MS SQL driver, it is completely functional, just time limited.
Also, Openlink will push you to license and download the multi tier version, I don't think it is neccessary. The multi tier installs a listener on the server that gets the ODBC calls from witango and the OL ODBC driver and then hands them off to the server. The single tier is just the ODBC driver that connects directly to the DBMS. I have found the single tier to perform as well as any windows ODBC driver, and there are enough bugs that can pop up in the ODBC interface, that I don't think you need another layer to worry about. Plus the single tier is cheaper.
Robert.
On Saturday, August 9, 2003, at 02:22 AM, Ian Daniel wrote:
Thanks, Robert.� I know you have quite a bit of experience doing what we are proposing in this thread.� Do you have any comments on the ODBC driver that is freely available from MS or any other part of the setup?
�
Thanks in advance ...
Ian
-----Original Message-----
From: Robert Garcia [mailto:[EMAIL PROTECTED]
There is the openlink drivers. I use them, very fast, faster than JDBC, but not free.
Robert.
On Saturday, August 9, 2003, at 12:32 AM, Ian Daniel wrote:
Ok, you've nudged us.� We're going to try it out.
�
Thanks, Phil ....
Ian
-----Original Message-----
From: Phil Wade [mailto:[EMAIL PROTECTED]
You could use the Microsoft JDBC driver. �And it is free.
�------------�
Hi Everyone:
We standardly use MS SQL Server on Win2k. �However, we have need to query a SQL Server 2000 database residing on Win2k from Witango on Mac OS X, so we're on the hunt for the best ODBC driver for this need, to reside on the Mac system.
Does anyone have any comment or experience with this scenario? �Just trying to avoid the pitfalls.
tks,
Ian Daniel
--
Robert Garcia
President - BigHead Technology
CTO - eventpix.com
2781 N Carlmont Pl
Simi Valley, Ca 93065
ph: 805.522.8577 - cell: 805.501.1390
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/ - http://theradmac.com/
--
Robert Garcia
President - BigHead Technology
CTO - eventpix.com
2781 N Carlmont Pl
Simi Valley, Ca 93065
ph: 805.522.8577 - cell: 805.501.1390
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/ - http://theradmac.com/
