Friday, February 24, 2012

access privilages via .net app to database (sql 2000)

Hi,
(SQL Server 2000)
I have a database that two programmers have db_owner privilages to. At this
time each created a stored procedure and they both work fine for each via VB
.NET 2003.
As soon as either try and access the others Stored procedures the program
says it can't find the SP.
If I use access 2000 and use either of these login's both SP's work fine.
Why is it we are having issues via .NET?
We have also had this issue with tables and Visual Fox version 8.
hopefully this is the right news group...
TIA,
ScottAre you fully qualifying the SP with the owner's name? I.e., instead of:
EXEC usp_MySP
using
EXEC dbo.usp_MySP
or
EXEC fred.usp_MySP
Where Fred is the user who created and owns this SP?
"Scott" <sfruhwirth@.gmail.com> wrote in message
news:%238mRD3AUFHA.2712@.TK2MSFTNGP09.phx.gbl...
> Hi,
> (SQL Server 2000)
> I have a database that two programmers have db_owner privilages to. At
> this
> time each created a stored procedure and they both work fine for each via
> VB
> .NET 2003.
> As soon as either try and access the others Stored procedures the program
> says it can't find the SP.
> If I use access 2000 and use either of these login's both SP's work fine.
> Why is it we are having issues via .NET?
> We have also had this issue with tables and Visual Fox version 8.
> hopefully this is the right news group...
> TIA,
> Scott
>|||Scott,
Do us a favor, query information_schema.routines from QA and tell us the
schema (owner) of the sps and also how are you calliing the sps.
select
routine_schema,
routine_name
from
information_schema.routines
where
routine_type = 'procedure'
and routine_name = 'procedure_name'
AMB
"Scott" wrote:

> Hi,
> (SQL Server 2000)
> I have a database that two programmers have db_owner privilages to. At th
is
> time each created a stored procedure and they both work fine for each via
VB
> ..NET 2003.
> As soon as either try and access the others Stored procedures the program
> says it can't find the SP.
> If I use access 2000 and use either of these login's both SP's work fine.
> Why is it we are having issues via .NET?
> We have also had this issue with tables and Visual Fox version 8.
> hopefully this is the right news group...
> TIA,
> Scott
>
>

No comments:

Post a Comment