"Eric" <Eric@discussions.microsoft.com> wrote in message
news:835BBEE3-DDA7-4FC0-867F-D95C4DE9DC19@microsoft.com...
> hi,
>
> Im using an ODBC datasource linked to a Sybase database.
>
> In the dataset designer, I can access data in a table using the following
> syntax :
> SELECT * FROM "exp"."PROJ"
>
> However I can't seem to find the proper syntax to call a stored procedure.
> I
> select Stored Procedure as the Command Type and type Get_Project_Title (a
> stored procedure). But when I execute it, it displays the following error
> message after asking for the parameters :
>
> "An error occured while executing the query. [ErrorS0002][SYBASE][ODBC
> DRIVER][ADAPTIVE ANYWHERE] The table or view cannot be found. The
> procedure
> Get_Title_Project cannot be found."
>
> However I find it extremely difficult to believe that the procedure cannot
> be found, when it asks for the parameter of the stored proc just before
> ....
> :s
>
> Any ideas on what is the problem?
>
> Thx
>
> Eric

"Bruce L-C [MVP]" wrote:

> I don't know. There is the 15 client which I am using against 12.5.2
> database. Seems to be a good client and quite fast. You might be OK with
> OLEDB now. I say just give it a try but go to ODBC if you have any problems.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Reeves Smith" <ReevesSmith@discussions.microsoft.com> wrote in message
> news:8D8B99DC-72C7-442F-9A6C-A131ED501D22@microsoft.com...
> > Bruce,
> >
> > You posted this over a year ago and I was wondering Is this still the case
> > today?
> >
> > Unfortunately I work against Sybase quite a bit. I see you are already
> > using
> > ODBC. Stay with that. I had problems with OleDB and found ODBC to be best.
> >
> > We are working with Sybase IQ 12.6 soon to be 12.7 and ASE 12.5 heading to
> > 15.0 soon.
> >
> > Reeves
> >
>
>