Question

Forms 9.1- SQL Table/View Lookup Not working for Views

Forms

Updated February 26, 2014

asked on January 23, 2014

I have a database configured for a FORMS 9.1 lookup, I can see the tables and that works, however I cannot see the Views to use them. I checked to see if the user could see the views within Sql and it can, and I tested and updated the connection sucessfully within FORMS setup, however I still cannot see the Views for the database in question. Any idea on why the SQL views are not showing up in FORMS?

3 0

Answer

SELECTED ANSWER

replied on January 29, 2014 • Show version history

Interesting enough, today when I went out to look at this issue again, the Views are now showing up and are usable within Forms. Not sure why, I haven't changed anything since the original post. We haven't rebooted any of the servers involved except the laserfiche server. Since neither Forms nor Sql are on that server-I am a little skeptical that would solve the issue, but it does seem to be working now. Thanks!

2/26/2014 Further note: I've had the same issue again, and I discovered FORMS will NOT see the new views without updating the sql connection and restarting the FORMS client. You have to totally go out of FORMS to get it to see new views after updating.

0 0

Replies

replied on January 24, 2014

Hi Rebecca,

Is the data source using windows authentication or sql authentication?

0 0

replied on January 24, 2014

The data source is using sql authentication.

0 0

You are not allowed to follow up in this post.

Question

Question

Forms 9.1- SQL Table/View Lookup Not working for Views

Answer

Replies

Sign in to reply to this post.