Hello
With my sql server connection, the tables are enumerated, and I can query, but stored procedures and views are not enumerated. Why?
PrimalSQL 2011 / Windows 7 64 bit / SQL Server 2008 (on another machine)
Thanks in advance
SQL Server stored procedures are not available
Forum rules
DO NOT POST LICENSE NUMBERS, ACTIVATION KEYS OR ANY OTHER LICENSING INFORMATION IN THIS FORUM.
Only the original author and our tech personnel can reply to a topic that is created in this forum. If you find a topic that relates to an issue you are having, please create a new topic and reference the other in your post.
Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
DO NOT POST LICENSE NUMBERS, ACTIVATION KEYS OR ANY OTHER LICENSING INFORMATION IN THIS FORUM.
Only the original author and our tech personnel can reply to a topic that is created in this forum. If you find a topic that relates to an issue you are having, please create a new topic and reference the other in your post.
Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
- rgruber3@msn.com
- Posts: 2
- Last visit: Fri Dec 26, 2014 2:33 pm
SQL Server stored procedures are not available
For clarification, do you mean views and stored procedures are not showing up in the Query Builder or in the database browser? David
David
SAPIEN Technologies, Inc.
SAPIEN Technologies, Inc.
- rgruber3@msn.com
- Posts: 2
- Last visit: Fri Dec 26, 2014 2:33 pm
SQL Server stored procedures are not available
Yes. In the tree view, with the database expanded, if you click on the "+" sign for the tables then it expands and shows the table. If you do the same for the stored procs or views, nothing is displayed. Thanks for you reply.
SQL Server stored procedures are not available
We are looking into this issue. What type of connection are you using to connect to the SQLServer? SQL, OLEDB, ODBC? Note that system views and system store procedures are not displayed. David
David
SAPIEN Technologies, Inc.
SAPIEN Technologies, Inc.
SQL Server stored procedures are not available
HelloI got the
same problem I can see tables and views but not stored procedures in the tree
views.PrimalSQL 2011 / Windows 7 64 bit / SQL
Server 2008R2 on Windows 2008R2, SQL 2000 on Windows 2003
same problem I can see tables and views but not stored procedures in the tree
views.PrimalSQL 2011 / Windows 7 64 bit / SQL
Server 2008R2 on Windows 2008R2, SQL 2000 on Windows 2003
SQL Server stored procedures are not available
The Query Builder doesn't support stored procedures so it doesn't show in the metadata. We will look into displaying the procedures in the Database Browser dispite this. David
David
SAPIEN Technologies, Inc.
SAPIEN Technologies, Inc.