Connect to SQL Server via ODBC on Mac?

[Ben Rubinstein]

Stephen Barncard wrote:

> Is it possible that ODBC support is being phased out on the Mac?

No, not at all.  There's plenty of ODBC software working on the Mac - it's
just more recent versions of Rev, at least in my experience, have this broken.
  This is why I'm unable to move most of my development work off Rev 2.6.1.

> Is there a point where upgrading the server might be more cost effective?
> Or is this something that you can't control?

I need to connect to client's database servers running SQL Server; and build
tools for Mac-using clients to connect to their organisation's SQL Server servers.

> The idea of "middleware" for database access always gave me the creeps...

As far as I know there are no direct drivers on the Mac for SQL Server; only
middleware (eg ODBC, JDBC).


Roger.E.Eller wrote:

> I haven't tried accessing MS-SQL from Rev since 2.6.x, but it worked after
> installing the "Actual" driver. It costs only $29.95 and worked quite well.
> You can try it for free, but it will only return 3 lines from a query until
> you acquire a license.

I did try the Actual drivers three years ago (since they're a third of the
cost of the openlink ones - not important for one installation, but if you're
client wants a dozen, it makes a difference).   I could make it work using the
  driver with various test apps, but not with Rev 2.2 (see bug Bugzilla #1557,
which on the basis of your experience must have been fixed).

Your suggestion inspired me to downlaod and try the current Actual drivers.
Unfortunately, after installing this, the Actual driver doesn't work at all
(even just in the ODBC Administrator) - and the installation seems to have
trashed my OpenLink setup!  Aaargh.

But thanks both for taking the time to reply.

Meanwhile, is there anybody out there connecting to SQL Server over ODBC using
any version of Rev since 2.7.1, succesfully or otherwise?

TIA,

- Ben