Question

Forms Stored Procedure Not Firing

Forms

Updated February 13, 2015

asked on February 13, 2015

I'm currently working on a form that uses a stored proc to pull data when a case number is entered.

My rule is set so that when a case number is entered, the column FormattedName should be filled into the Single Line textbox. At this point nothing is happening. I have confirmed that the data source is set up correctly and the sql login account has full access to execute the stored proc. What's confusing is if I use a standard table to pull back data, the form is populated as expected. However, views and stored procs do not work.

We are on Forms 9.1.1.1522

Thoughts?

0 0

Replies

replied on February 13, 2015

Have you tried it in a different browser?

John

0 0

replied on February 13, 2015

John,

Yes, IE, Firefox, Chrome to no avail. If I use a table rather than SP or view, it works in these browsers.

Thanks.

0 0

replied on February 13, 2015

Hi Bradley,

Have you tested to make sure one result is returning? To test through Forms, assign the retrieved value(s) to a drop down instead of a text field.

-Ben

0 0

replied on February 13, 2015 • Show version history

You would have thought my first stop would be the eventlog on the server....

Here is the error message:

2/13/2015 10:53:39 AM | Session: vlajzi04oygszemobzgkjnua
User: ADMIN
URL: /Forms/form/prepopulate
Message: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Access to the remote server is denied because no login-mapping exists.
Stack trace: at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)

Problem is, I have the sql user mapped to the database as db_datareader. Thoughts?

0 0

replied on February 13, 2015

Does it run if the ADMIN user is a DB_Owner or SysAdmin?

0 0

replied on February 13, 2015

After digging a little further, the view and stored proc were in separate schemas (not dbo). Once I moved those objects to the dbo schema everything appears to work now, albeit slowly. The account had access to execute when the objects were in the other schema and the objects showed in the data source configuration in lf forms. Anyone run across this?

0 0

You are not allowed to follow up in this post.

Question

Question

Forms Stored Procedure Not Firing

Replies

Sign in to reply to this post.