How to call functions via ODBC

[Zlatko Matiæ]

Hello.

How can I call some functions on MSDE when working in Access (.mdb) that is
connected to MSDE via ODBC linked tables ? Especially
in-line functions, that I would like to use as recordset for my forms and
reports.
Can I call in-line functions using ADO ? I tried, but it seems that only
stored procedures are allowed (adCmdStoredPro c)....

Thanks.

[Mike Epprecht \(SQL MVP\)]

Re: How to call functions via ODBC

Hi

Inline functions are not intended to be called directly. You are not using
them correctly. You can not call it via ODBC, ADO, ADO.NET or Query
Analyzer.

In Inline function should be called as part of a select statement or stored
procedure. SQL Server BOL shows how they should be used.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.n et

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Zlatko Matiæ" <zlatko.matic1@ sb.t-com.hr> wrote in message
news:d3ua9b$icu $1@ss405.t-com.hr...[color=blue]
> Hello.
>
> How can I call some functions on MSDE when working in Access (.mdb) that
> is connected to MSDE via ODBC linked tables ? Especially
> in-line functions, that I would like to use as recordset for my forms and
> reports.
> Can I call in-line functions using ADO ? I tried, but it seems that only
> stored procedures are allowed (adCmdStoredPro c)....
>
> Thanks.
>
>
>[/color]