开发者

Postgres odbc connection not showing stored procedures

开发者 https://www.devze.com 2023-03-24 11:49 出处:网络
I\'m working on postgres database application in C#. I have a problem with ODBC connection(PostgreSQL ODBC driver 8.04.0200-1). It\'s not showing stored procedures in VS Server Explore开发者_开发知识库

I'm working on postgres database application in C#. I have a problem with ODBC connection(PostgreSQL ODBC driver 8.04.0200-1). It's not showing stored procedures in VS Server Explore开发者_开发知识库r, while showing tables and views. I plan to use a stored procedure in Crystal Reports. I administer the database, so I tried to grant execute privilage on the stored procedure to the role, but that didn't help. Anyone can help what might be the reason?


PostgreSQL doesn't have stored procedures. It does have user-defined functions though. Does "VS Server Explorer" know how to display these? Have you turned logging on your ODBC connection / at the server to see what queries it's using to find them?

0

精彩评论

暂无评论...
验证码 换一张
取 消