sql server reporting services: Sybase & parameters -- sql server reporting services

You're in the

sql server reporting services

group:

Sybase & parameters

Galore
8/4/2004 9:05:51 PM

sql server reporting services:

Hello,

Has anyone here used Reporting Services with Sybase ASE, through OLEBD???
I'm having trouble passing parameters values to the report, it says that the
"given type name is unrecognized", when I pass a string parameter.

Can anyone here help me about this, at least tell me if this tool fits on
Sybase.

Thanks

Re: Sybase & parameters

Brian Welcker [MSFT]
8/4/2004 10:44:01 PM

How are you parameterizing your SQL? OLE DB uses unnamed parameters, i.e.

select x from y where z = ?

--
Brian Welcker
Group Program Manager
SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Re: Sybase & parameters

Bruce Loehle-Conger
8/5/2004 8:25:58 AM

I use RS extensively with Sybase. Are you going against a stored procedure?
I have had issues with stored procedures but wasn't sure if it was because I
am using the 12.2.1 client against an 11.9 database (will be upgrading the
server shortly). Anyway, the only issue I have ever had is with stored
procedures. See other response by Brian.

Bruce L-C

[quoted text, click to view]

Re: Sybase & parameters

Galore
8/5/2004 10:59:19 PM

Yes, all queries are SP. When you used SP, did you get this error?

[quoted text, click to view]

Re: Sybase & parameters

Bruce Loehle-Conger
8/6/2004 9:43:21 AM

I don't remember the error. I tried both ODBC and Oledb plus I upgraded to
the latest client (12.5.2). I have also had trouble integrating DTS with
Sybase and passing parameters with DTS. I have considered submitting a
support call to Sybase but the direction I am going is creating a datamart
in SQL Server and once the DTS issue is resolved (which I can do at a
minimum but dynamic queries) then most of my querying will be done against
SQL Server and then I will be able to use stored procedures (SP work fine
for me with SQL Server).

Sorry I can't help more.

One option you can do is to used linked databases in SQL Server. It is
awkward because to make it usefull you need to create dynamic queries
against the linked table to it will work.

Bruce L-C

[quoted text, click to view]

Re: Sybase & parameters

Galore
8/11/2004 9:24:06 PM

Well, my problems went away when I passed to use ODBC..., that's not the way
I'd like to do, but it's worked.

[]'s

[quoted text, click to view]

Re: Sybase & parameters

Bruce Loehle-Conger
8/12/2004 9:20:10 AM

Thanks for letting me know. My 12.5.2 client was going to 11.9 server. I am
upgrading the server shortly so hopefully parameters will work for me then.
I have found the ODBC to be the best to work with.

OLEDB has a silly bug where if you have multiple connections setup it always
goes for the first one. Supposed to be a workaround for this problem but did
not work for me so I just went to ODBC instead.

Bruce L-C

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn