Skip to Content
0
Former Member
Jul 15, 2016 at 02:15 PM

SNC vs OLE DB driver - SQL Warning Issue

85 Views

Using MS SQLSVR 2012 just changed drivers from OLEDB to SNC and noticed this development time difference

We have Oracle embedded SQL SQL in scripts. When connected to an SQLSVR via OLEDB profile both the script painter & the DB Painter report a SQL error when it encounters non MS compliant SQL.

But when connected via SNC only the DB Painter reports a SQL warning, Script painters no longer report warning when encountering ORA syntax

Same behavior in 12.5 and 12.6

Is this an expected feature change OR is there something we need to set in the dbprofile or INI file OR is it a bug and we need to open a case ?

Illustrated in these two screen shots

Attachments

SNC-Issue2.png (115.2 kB)
SNC-Issue1.png (124.6 kB)