Apple Mac, ODBC to SQL Server under Crossover

[Paolo F Cantoni]

<disclaimer>I'm like "Sergeant Shultz" when it comes to Macs - "I know nothink!"  </disclaimer>

We're trying to setup Sparx EA on a Mac and have got Sparx installed under Crossover on Wine.  We've got EA installed and some (very) quick preliminary tests on a local repository suggest it's working.  However, when we try to set up an ODBC connection to our SQL Server we get nowhere.  is there some "secret sauce"?

An ODBC connection IS required for connecting to a server based repository is it not?

TIA,
Paolo

[Glassboy]

<disclaimer>I'm like "Sergeant Shultz" when it comes to Macs - "I know nothink!"  </disclaimer>

You're probably using the wrong type of mustache wax :-)

[Paolo F Cantoni]

<disclaimer>I'm like "Sergeant Shultz" when it comes to Macs - "I know nothink!"  </disclaimer>

You're probably using the wrong type of moustache wax :-)

That's because I have a full beard!  (and have had since I first grew it over 45 years ago!)

Paolo

[Eve]

An ODBC connection IS required for connecting to a server based repository is it not?

No. An ODBC connection to a SQL Server database is BAD. You need to use an OLE DB connection.

I don't know if you need something more than MDAC to be installed to access SQL Server via OLE DB.

[Glassboy]

An ODBC connection IS required for connecting to a server based repository is it not?

No. An ODBC connection to a SQL Server database is BAD. You need to use an OLE DB connection.

I don't know if you need something more than MDAC to be installed to access SQL Server via OLE DB.

Well if you're going to be all puritanical about it all; strictly speaking MDAC is very 2003 and should be replaced by WDAC :-)

[Paolo F Cantoni]

OK, so when we try OLE DB direct from EA, we get a security issue come up (same as when we tried to set up an ODBC connection).

Our security infrastructure complains that we aren't on a trusted domain.  What domain are we on (presumably a default) and how can we fix it?

Paolo

[qwerty]

FWIW, I'm a native Mac user and I ever since use EA via Parallels on a VM. I also tried EA via wine, but it simply felt "strange". EA is so native Windoze that I can only stand it in its native terrain. And those ODBC-issues were never ones I had.

q.

[Sunshine]

You have a couple of options.

a) set up the SQL DB to access using a user name and password rather than single sign on AD credentials then you'll be prompted for those credentials each time you access the DB. This might well be the easiest.

b) Get your mac to join the Windows Domain. Some articles on line but not sure if they work as haven't tried.
https://www.pluralsight.com/blog/tutorials/join-mac-to-windows-domain
http://www.techrepublic.com/blog/apple-in-the-enterprise/integrate-macs-into-a-windows-active-directory-domain/
https://www.portalguard.com/blog/2016/01/29/os-x-active-directory-integration-how-to-bind-a-mac-to-ad/

Hope that gives you some leads to try.
Do let us know if you do solve using option b)

[Paolo F Cantoni]

You have a couple of options.

a) set up the SQL DB to access using a user name and password rather than single sign on AD credentials then you'll be prompted for those credentials each time you access the DB. This might well be the easiest.

b) Get your mac to join the Windows Domain. Some articles on line but not sure if they work as haven't tried.
https://www.pluralsight.com/blog/tutorials/join-mac-to-windows-domain
http://www.techrepublic.com/blog/apple-in-the-enterprise/integrate-macs-into-a-windows-active-directory-domain/
https://www.portalguard.com/blog/2016/01/29/os-x-active-directory-integration-how-to-bind-a-mac-to-ad/

Hope that gives you some leads to try.
Do let us know if you do solve using option b)

Hi Sunshine,

it's a corporate Mac and on the AD security system.  The problem appears to be Crossover itself not using the available credentials.  I've formally posted a support request with CodeWeavers to see what they say.  We are already requesting a specific user access to the DB to confirm that we can get through, but that's only really a trial to confirm what the issue is.

Paolo

[Sunshine]

Sounds like  you on top of it. Interesting to hear what crossover say.