Universe Connection

[system]

Trying to create an ODBC Sybase Connection Universe to bring in Stored Procedures.

In doing so I get the following error message:

This connection does not allow Stored Procedures Universe.

If I uncheck the box to choose stored procedures the connection works fine but I need to bring in SP.

Anyone?

---

toscajo (BOB member since 2002-09-04)

[system]

maybe its the .sbo file issue;
this may help;

120×120 10.4 KB

and now, ladies and gentlemen, another great news! you can use stored procedures in the universe in XI R2! (of course with dynamic SQL, temp tables and other powerfull sql features) how to proceed: just create derived table in the universe with the following SQL: SELECT * FROM OPENROWSET('SQLNCLI', 'Server=localhost;Trusted_Connection=yes','EXEC sp_myReport') (oops! forgot to tell you it will work only with MS SQL 2000 or higher, unless your DBMS has something similar to OPENROWSET) that’s…

120×120 10.4 KB

Hi guys! today I was lucky and managed to make stored procedures working in WebI. I’m glad to share this ‘know how’ and say goodby to DeskI Change parameter Force SQLExecute in odbc.sbo to Always Add parameter Force SQLExecute = Always into oledb.sbo Create query in WebI with the same structure your SP returns Change SQL to following set nocount on /*SELECT any_field FROM any_table*/ exec your_stored_procedure @prompt('enter value','A',<other prompt parameters>) you can even use tem…

---

katullus (BOB member since 2009-08-21)

[system]

Thanks katullus
but being that I don’t have a problem creating an Oracle Universe with Stored Procedures I am thinking it may be an issue with Sybase

---

toscajo (BOB member since 2002-09-04)