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.
Please clue me in!
TIA,
ScottIf all users have permissions on the objects and you fully-qualify the
object names as in ownername.objectname (instead of just objectname)
you should have no problems.
You'll also want to make sure that dbo owns the objects in question,
not the individual programmers. As far as Access or Fox goes, couldn't
say.
--Mary
On Tue, 3 May 2005 09:18:29 -0500, "Scott" <sfruhwirth@.gmail.com>
wrote:

>Hi,
>(SQL Server 2000)
>I have a database that two programmers have db_owner privilages to. At thi
s
>time each created a stored procedure and they both work fine for each via V
B
>.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.
>Please clue me in!
>TIA,
>Scott
>

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
>
>