[SQLServer] OLE DB error occurs when query is executed.

Symptoms:

When performing a query in SQLGate for SQL Server, an OLE DB error may occur as shown below.

Workaround:

Beginning with version SQLGate 2010, use Microsoft SQL Server Native Client instead of MDAC as the OLE DB provider.

On some Microsoft Windows XP SP2 or earlier operating systems, Microsoft SQL Server Native Client is not installed automatically, resulting in 'OLE DB error occured. Code XXXX 'will be displayed.