Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Access via Mac ODBC...

Author  Topic 

mikebird
Aged Yak Warrior

529 Posts

Posted - 2011-07-16 : 12:25:42
SQL Server 2008 running beautifully on WinXP on vmware on my 64-bit Mac Pro
Everything is accessible directly, with SSMS

Trying to achieve this from my Mac ODBC app, and also something called Cellica on the iPad... let's look at the first one for now.

Mac Pro has two ethernet ports, one assigned to the Mac, the other one for Windows. Both surf fine. I've rebooted the router a few times to confirm IP addresses
sqlservr is running with TCP enabled, default 1344. Mac pings the IP OK.
Windows Firewall is off
SSMS is fine with WinAuth, and sa login/pasword, and I don't want to mess with Win domains using Mac software

Aahhhh... can't ping the Mac from command prompt in Windows. ???

Testing ODBC just sits waiting to timeout.

Exactly all the same trouble when I try setting up an ODBC connection on Windows too!

What do I need to do? Enable ODBC?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-07-16 : 15:51:19
If the Network settings for your VM are set to NAT then it can't access the Mac host. I've never tried it but someone I know has gotten it to work with a bridged network connection.
Go to Top of Page
   

- Advertisement -