At work, I have to SQL Server for development. I have a Mac Book Pro. I’m trying to do rails dev work in textmate and connect it to the SQL Server through VMWare (XP).

Has anyone done this before, and how have you guys done it? Any help is much appreciated!

I’m not too familiar with VMWare, but my guess is you could address just as it were on a server somewhere. The trick would be to find out what machine name VMWare has assigned to your XP image, and to make sure the SQL Server ports are open.

Then in your database.yml, use the host and database names as needed.

Try it out and post again if you have success, or if it doesn’t work. I’m also curious to know if there are any gotchas in this kind of setup.

I got it to work, thank god.

First, I had to shut the firewall off in vmware. Then I followed these instructions. http://toolmantim.com/article/2007/5/7/getting_rails_talking_to_sqlserver_on_osx_via_odbc

Make sure that you use the SQL Server Configuration Manager to figure out the port you need.