Hi !
This should be simple but 'm having trouble with accessing all the stored procedures through Data Environment that i've in a SQL Server 7.0 db. They r about 90 but 'm only able to view 15 of them. This is happening when I use 'add stored proc' or add a command, select its type as 'stored proc' and try to access the stored proc list. I 've tried the coding approach also but it doesnt work.
've my connection setup correctly. The remaining <invisible> sps r for sure in the same db as I've checked them with Enterprise Manager, 've run them with Query Analyzer and used them in Crytals Reports.
I've even tried refreshing, re-opening vb, droping and creating new sps..
Kindly help me out..
This should be simple but 'm having trouble with accessing all the stored procedures through Data Environment that i've in a SQL Server 7.0 db. They r about 90 but 'm only able to view 15 of them. This is happening when I use 'add stored proc' or add a command, select its type as 'stored proc' and try to access the stored proc list. I 've tried the coding approach also but it doesnt work.
've my connection setup correctly. The remaining <invisible> sps r for sure in the same db as I've checked them with Enterprise Manager, 've run them with Query Analyzer and used them in Crytals Reports.
I've even tried refreshing, re-opening vb, droping and creating new sps..
Kindly help me out..
