Connecting SQL Server 2008 + CF8 mac

[dtharpe1]

Hello,

I am currently porting all of our access databases to SQL Server 2008 and i am using a mac for development. If anyone can tel me how to connect sql server database from the cfadmin on mac to a virtual environment on parallels 5. In the cfadmin on mac SQL Server is listed as a kown datasource you can connect to but the only way i see to do this is thru a virtual environment or remote.

Please help

Thanks,

D

[Owainnorth]

Having not used Parallels in some time I couldn't say for sure, but essentially that SQL engine needs to be accessible from Coldfusion on an IP address somewhere. Depending on what networking mode you're using, that'll either be:

1 - Its own IP

2 - Localhost, or 127.0.0.1

As long as your ColdFusion instance has network access to the SQL box, there's no additional config required.

O.

[dtharpe1]

Yea I appreciate the reply. The main problem i have is having to have the virtual machine running all the time on my development machine. So im considering finding and old Dell box around here and rebuild it just to be used as a SQL Server because virtual environments seem to take alot of system resources.

Thanks,

D

[Owainnorth]

Well resources are a different issue to the connectivity but yes, certainly your life will be easier if you get a spare server set up.

Plus you'll have somewhere to rest your feet.

O.