SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?


share|improve this question
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


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.