Post reply

remote call MSACCESS - ODBC - SP - DTS PACKAGE

  • August 2, 2005 at 5:41 am

    #164532

    Dear All,

    I'm using MS ACCESS as a frontend connected through ODBC to MSSQL tables.

    One of these connections is a call to a SP which runs a DTS package saved on the server.

    (I've adapated this from a solution that comes here: http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS)

     

    Logging as the sa, (on server local) i can execute the dts package through ms access using the odbc conn.

    The Problem:

    If i try to run the dts packg from other machine, with a user who already has db_owner permissions i get an error msg, saying that i dont have privileges to create a package object (as defined on the sp that calls the dts package).

    Any ideas?

    thanks a million,

  • August 2, 2005 at 9:17 am

    #578880

    Check to make sure that the logged user has execute permissions on the sp_OACreate objects in the master database (there are a couple of other sp that start with the OA that they may need access to.

    Good luck,

    Darrell

  • August 2, 2005 at 4:39 pm

    #578992

    Thanks for replying.

    I solve the problem like that giving "Grant Execute on sp_XXXX to public" for now

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply