Connection to SQL Server via ODBC

[zinger]

I use Business Objects XI R2 (BOXI) to report against a SQL Server 2000 database using an ODBC connection.
When I query the database using Enterprise Manager on the server I can make use of all functions available within SQL Server, yet when I access it via the ODBC connection I only get a very small subset of SQL Server functions available.

I can use the inbuilt BOXI functions, which work on the data locally, but would like the functions processed on the server instead.

Is this constraint a property of the ODBC driver, and if so are there other drivers which would expose all of the available SQL Server functions.

Any suggestions appreciated.

 

[mrdenny]

All ODBC does is pass the commands to the database (or at least that all it's supose to do).

You might want to ask a BO person. I know that it can be done (my last company had no problems getting BO to talk to SQL) but I beleive that some tweaks to the BO system were required.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[zinger]

Hi Denny,

Thank you for your answer.

Sorry about the delay in responding to you, but I have been attending some advanced BO courses and my question, which I may not have stated correctly, was answered.

The functions I wanted to refer to (eg. max, min, stdev, stdevp, var, varp etc.) in my question, are displayed in the Business Objects sql builder interface only if they are contained in a .prm (parameter) file. This file is supplied with a frequently used subset of sql server functions, but it can be edited and added to. All that this file does is to present a list of functions to the interface.

The functions, which don't appear in the interface, can still be used in a sql statement as long as they are valid functions.

Thanks
Zinger