Question

Forms Error when Updating Data Source - Ambiguous Name

Updated March 23, 2016

asked on March 23, 2016

We have a DB with over 90 tables. When I tried to refresh the source in Forms I get the error "Ambiguous Name" Is there any way to tell what this is referring to? Even a table name it is referring to? Better Error Reporting might be a future update?

I verified permissions and such with the associated user and password connects with.

0 0

Replies

replied on March 23, 2016

Hi Kip,

Were you able to use this data source before? If so, what changes had you made to the data source prior to receiving this message on refresh?

If you are using Forms 10, on the Forms server you can check the Windows Event Viewer for the LFForms log under "Applications and Services". If you are on a version prior to 10, you can check the Windows Application event log. There may be more details to the message there.

Hope this helps!

0 0

replied on March 23, 2016

Yes I was and am still able to use the DB on associated forms. The changes made is the problem, it is a shared resource between 4 system support techs and it is our Utility DB and gets all sorts of temp tables in it at times. I am literally having to go each table to see if it contains a column named Name. The actual Error in the little red strip is: Ambiguous column name 'name'. If just seems silly to me that sense it is checking that at least it could tell you the table it found it in as well.

0 0

replied on March 23, 2016

Check whether the SQL databse is running at Compatibility Level of SQL 2000. Depending on your version of Forms, it may be a compatibility issue and need to be at least SQL 2008. Another Answers thread encountered the same issue before.

You can check this in SQL Management Studio by right-clicking on the Forms database, going to Properties > Options. There will be a field for Compatibility Level. Set it to "SQL Server 2008" or higher.

0 0

You are not allowed to follow up in this post.

Question

Question

Forms Error when Updating Data Source - Ambiguous Name

Replies

Sign in to reply to this post.