<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"><channel><category>pcsoft.us.windev</category><copyright>Copyright 2026, PC SOFT</copyright><lastBuildDate>10 Jun 2015 18:40:00 Z</lastBuildDate><pubDate>4 Jun 2015 00:27:00 Z</pubDate><description>Hi,&#13;
&#13;
I have an app running on WD 19 on SQL Server 2008.&#13;
&#13;
I purchased a copy of Native Access for SQL server and configured my app to use it.&#13;
&#13;
I opened the application and everything seemed fine. So far so good.&#13;
&#13;
However, in running some routine test all kinds of really weird and disturbing behavior started happening,&#13;
&#13;
*multiple rows being created where only one should be (using HADD)&#13;
*query's gathering data that should be outside their scope.&#13;
* Basic queries failing that have no reason to fail.&#13;
&#13;
All this worked perfectly connecting via OLEDB.&#13;
&#13;
It's basically a tire fire and I don't know where to start.&#13;
&#13;
Anyone else make this jump and experience anything similar, any advice?&#13;
&#13;
Thanks!</description><ttl>30</ttl><generator>WEBDEV</generator><language>en_US</language><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access/read.awp</link><title>Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</title><managingEditor>moderateur@pcsoft.fr (El moderador)</managingEditor><webMaster>webmaster@pcsoft.fr (El webmaster)</webMaster><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52660/read.awp</comments><pubDate>10 Jun 2015 18:40:00 Z</pubDate><description>I've solved my issue. Apparently somewhere deep in the bowels of my projects analysis Windev though one of my tables (pretty muc…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52660/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52660/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access/read.awp">Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</source><title>Re: Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008:SOLVED</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52592/read.awp</comments><pubDate>8 Jun 2015 13:17:00 Z</pubDate><description>Steve&#13;
&#13;
Why don't you try to use v29 native Sql on wd19 as your native wd20 drivers come with all&lt;= v20 and if it works, it's t…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52592/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52592/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access/read.awp">Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</source><title>Re: Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52555/read.awp</comments><pubDate>4 Jun 2015 17:50:00 Z</pubDate><description>Thanks! I appreciate all the help.</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52555/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52555/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access/read.awp">Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</source><title>Re: Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52554/read.awp</comments><pubDate>4 Jun 2015 17:35:00 Z</pubDate><description>Steve,&#13;
You can run the profiler or in the case of the express version just download expressprofiler or some other tool like tha…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52554/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52554/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access/read.awp">Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</source><title>Re: Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52551/read.awp</comments><pubDate>4 Jun 2015 17:16:00 Z</pubDate><description>something like:&#13;
HDescribeConnection("mssql",G_USERDB,G_PASSWORDDB,G_SERVERDB,G_DB,hNativeAccessSQLServer,hOReadWrite,"WD Connec…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52551/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52551/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access/read.awp">Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</source><title>Re: Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52549/read.awp</comments><pubDate>4 Jun 2015 16:43:00 Z</pubDate><description>Quote&#13;
Paulo Oliveira&#13;
&#13;
if you want to have the same behavior as the oledb use WD CLIENT VERSION=2000&#13;
&#13;
&#13;
&#13;
Thanks Paulo, how …</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52549/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52549/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access/read.awp">Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</source><title>Re: Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52548/read.awp</comments><pubDate>4 Jun 2015 16:35:00 Z</pubDate><description>if you want to have the same behavior as the oledb use WD CLIENT VERSION=2000</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52548/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52548/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access/read.awp">Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</source><title>Re: Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52543/read.awp</comments><pubDate>4 Jun 2015 16:18:00 Z</pubDate><description>I'm using 32 bit and sqlncli 2008.</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52543/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52543/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access/read.awp">Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</source><title>Re: Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52538/read.awp</comments><pubDate>4 Jun 2015 15:04:00 Z</pubDate><description>Steve,&#13;
Are you using 32/64 bits?&#13;
If in 32 bits did you test with sqlncli or dbnetlib?&#13;
If you are using sqlncli what is the ve…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52538/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52538/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access/read.awp">Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</source><title>Re: Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52527/read.awp</comments><pubDate>4 Jun 2015 07:58:00 Z</pubDate><description>I'm wondering if the pre-release SQL Server Native Access for WD 20 is wanky.</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52527/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52527/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access/read.awp">Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</source><title>Re: Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52525/read.awp</comments><pubDate>4 Jun 2015 06:58:00 Z</pubDate><description>Jorge, the application was originally written in Postgres with native access and then migrated to MS SQL when we took it to mark…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52525/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52525/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access/read.awp">Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</source><title>Re: Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52524/read.awp</comments><pubDate>4 Jun 2015 03:56:00 Z</pubDate><description>Hi,&#13;
&#13;
We use WD + MS SQL several years, with connection with OLEDB provider.&#13;
&#13;
Why Native Access for MS SQL?&#13;
&#13;
If for ompatib…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52524/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52524/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access/read.awp">Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</source><title>Re: Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52523/read.awp</comments><pubDate>4 Jun 2015 02:31:00 Z</pubDate><description>Hi&#13;
&#13;
I've been running sqlServer12 (64-bit on Windows764-bit)&#13;
from wb/wd17-19 with a charm.&#13;
&#13;
Pls check if your installations…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52523/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access-52523/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52522-weird-behavior-moving-from-oledb-windev-native-access/read.awp">Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</source><title>Re: Weird behavior moving from OLEDB to Windev Native Access on SQL Server 2008</title></item></channel></rss>
