OLEDB Connections cannot excute SP remotely

• adoggart

  Newbie

  Points: 1

  More actions

  March 12, 2003 at 3:09 am

  #357721

  I have a VB application which can connect to SQL Server 2000, but cannot execute any stored procedures on the server, is there a flag or option with Sql Server to allow this type of RPC ?

• kevina

  Grasshopper

  Points: 17

  More actions

  March 12, 2003 at 11:21 pm

  #450947

  do you get any errors when trying to execute the sp

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  March 13, 2003 at 1:42 am

  #450951

  Are you sure that the account used to connect has the permissions to execute the SP?

  --

  Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

  http://www.sql.nu

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/