Solved

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

Posted on 2008-10-16
2
144 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 500 total points
Comment Utility
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
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

762 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now