Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SELECT statements from ADO

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-19 : 23:47:43
Bruce writes "I have a VB program that pulls data from a SQL Server DB using ADO. If I have the VB program run the SQL "SELECT * FROM Products", I get an error saying that it doesn't have SELECT permission. Changing the permissions on the table does not change this. I can, however, create a stored procedure with the same SQL and call it from the VB program. Any ideas????

Bruce Hamitlon"
   

- Advertisement -