?
Solved

Can UNIX servers with o/s 10 work with MS SQL Server 2005  servers?

Posted on 2008-10-16
2
Medium Priority
?
164 Views
Last Modified: 2013-11-21
Expert: I am looking at installing a Cold fusion 8.0 web application on a Unix server with o/s 10 and Sun web server 7 with a back end MS SQL Serve2005  database server?  However some one mentioned that I would not be able to use  MS SQL Server 2005   as the back end database server since UNIX servers only work with Oracle database.  Is this true?  We would perfer to use MS SQL Server 2005  in lieu of Oracle database?

Please kindly advise...thanks
0
Comment
Question by:tcmmaxt
2 Comments
 
LVL 15

Accepted Solution

by:
MohammedU earned 2000 total points
ID: 22736120
You can't install SQL on unix but definitely you can connect to SQL server from UNIX...

Check the following article from one of the SQL MVP...

Connecting to MS SQL Server from Unix
http://www.sommarskog.se/mssqlperl/unix.html
0
 

Author Comment

by:tcmmaxt
ID: 22742129
Expert MohammedU: thanks for the subject link . For my 3 tier cold fusion web application on unix . Which of the drivers in the list at http://www.sommarskog.se/mssqlperl/unix.html would you suggest I use to connect my solaris 10 o/s to the back end MS SQL Serve2005  database server. I what to make sure I use the right one before I close out of this one. again, thanks
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question