Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I know that many database connections are possible with the Enterprise version of SharePoint Server 2007. Is it possible to make a custom solution to set up a connection? If it depends on the type of connection, could I be given a place for guidance?

Thanks.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

In relation to ODBC data sources, what the Enterprise License gives you in Excel Services is the ability to externalize your data connections so they may be reused across workbooks. With the Standard License, you do not get Excel Calculation Services, so what you end up with essentially is Excel files stored in a document library. To that end, you may do anything with ODBC data sources that you can do from your workstation, because you must open the Excel doc on your workstation to use it -- SharePoint is simply serving as a repository.

share|improve this answer
    
Thanks, you have been a big help with my ODBC quesions. –  sange Sep 10 '10 at 13:46

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.