Using stored procedures

Results 1 to 2 of 2

Thread: Using stored procedures

  1. #1
    Ali Guest

    Default Using stored procedures

    I have used stored procedures and my app works fine from my machine, but user tests get ODBC error: cannot find stored procedure [procedure name]. Any other database function works fine (if I run a query from ASP it runs great). Any suggestions?<BR><BR>Here is my connection code:<BR> CurrentDSN = "CircuitDatabase"<BR> <BR> Set dbConnection = Server.CreateObject("ADODB.Connection")<BR> dbConnection.Open "DSN=" & CurrentDSN<BR><BR>Here is my stored proc call:<BR> SearchField = request.form("txtLocID")<BR> StoredProc = "SearchByLocationID"<BR> sSql = StoredProc & "&#039;" & SearchField & "&#039;"<BR> Set rs = dbConnection.Execute(sSql) &#039;execute sql call <BR><BR>

  2. #2
    Ali Guest

    Default Found it myself: Using stored procedures

    But if anyone wants to know, the problem was that I am not the SQL Server admin, and apparently the stored procedures&#039; names are prefixed with my SQLServer Owner name. The call was looking for that, but I wasn&#039;t passing it. I had the SQL Server admin recreate my stored procedures; that worked. Go figure.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts