SET ANSI OFF

2021-05-11 Thread MB Software Solutions, LLC
anged the query from using WHERE NOT EMPTY(srep) to what you see at the top of this post. I figured it was the SET ANSI and confirmed it.  I see the original developer explicitly says in the startup code SET ANSI OFF. I just can't understand why.  This is very old code so I ask those who&#x

SET ANSI OFF via the VFPOLEDB driver

2018-03-23 Thread Fred Taylor
Does anybody know how to change the ANSI setting for the VFPOLEDB driver from .NET?. An ADO connection object can set the properties (oConn.Properties.Items("set ansi").Value) in VFP code, but the OLEDB connection object in .NET doesn't seem to allow access to these properties. Any Ideas? Fred