Hello,
I have an app that uses this statement to retrieve the procedure name of an
Access database:
DataTable dbSPS = cnx.GetOleDbSchemaTable(OleDbSchemaGuid.Procedures, null);
It's working nicely. However, in a specific database, the same code throws
this exception:
System.Data.OleDb.OleDbException: The SQL statement could not be executed
because it contains ambiguous outer joins. To force one of the joins to be
performed first, create a separate query that performs the first join and
then include that query in your SQL statement.
at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbConnection.GetSchemaRowset(Guid schema, Object[]
restrictions)
at System.Data.OleDb.OleDbConnection.GetOleDbSchemaTable(Guid schema,
Object[] restrictions)
Compacting and repairing the database has not helped. I've researched a lot
in internet but I haven't found anything related.
Any ideas?
Thanks in advance,
Jos