Skip to main content
D
dtharpe1
Participant
March 31, 2010
Question

Connecting SQL Server 2008 + CF8 mac

  • March 31, 2010
  • 1 reply
  • 644 views

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

This topic has been closed for replies.

1 reply

Owainnorth
Owainnorth
Inspiring
March 31, 2010

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.

D
dtharpe1Author
Participant
March 31, 2010

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
Owainnorth
Inspiring
March 31, 2010

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.

Firefly Community Gallery
Adobe Firefly

Remix with Firefly Community Gallery

Thousands of free creations to fall in love with and remix in Firefly.

Explore now
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices