Kbase P61272: Simple queries return no errors and no data using OpenEdge 10.0A Wired Protocol MS SQL server Driver
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.0A
MS SQL 2000
MS SQL DataServer
SYMPTOM(s):
Simple queries return no errors and no data
Using OpenEdge 10.0A SQL Server Wired Protocol Driver
CAUSE:
The default setting on the OpenEdge 10.0A SQL Server Wired Protocol Driver does not match the SQL statement generated by SQL server dataserver
FIX:
Select "Enable Quoted Identifies" option for the Advanced tab when configuring OpenEdge 10.0A SQL Server Wired Protocol Driver in ODBC Configuration.