Post reply

Stored Procedure Called Through Access w/Error 3146

  • August 17, 2010 at 9:18 am

    #72932

    I have a stored procedure that is a series of statements (if - select).

    If all comeback as True (Okay), I insert Rows from one SQL table to another.

    But I am getting a Error 3146 on the Access Front End. I can run the code from the Sql Console but not the Front End. It has been working. Now, it just bombs on the front end though nothing has change except some additional records???

    Can anyone help me. I kinda need this.

    P.S. I raised the Time Out to 4 minutes in Access.

  • August 17, 2010 at 11:14 am

    #1208052

    Also, I use this connection string

    "ODBC;Driver={Sql Server};Server=SQLServer;Database=TPrj;Trusted_Connection=Yes" for my Pass-Though queries.

    I have read there is a better, more stable, driver.

    Can someone point me to one or is this okay?

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

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