pcsoft.us.windevCopyright 2026, PC SOFT24 Jul 2015 13:56:00 Z23 Jul 2015 08:10:00 ZHello, I modified the WXReplication module by Fabrice Harari to access SQL Server database. Added the following connection method, if SQL Server :m_cnxHFCSRealConnection..Provider = "SQLOLEDB" :m_cnxHFCSRealConnection..User = INIRead("DB","User","sa",:m_ccsIniFile) :m_cnxHFCSRealConnection..Password = INIRead("DB","Password","a123#",:m_ccsIniFile) :m_cnxHFCSRealConnection..Server = INIRead("DB","Server","localhost",:m_ccsIniFile) :m_cnxHFCSRealConnection..Database = INIRead("DB","DBName",cstDBName,:m_ccsIniFile) //:m_cnxHFCSRealConnection..CryptMethod = hCryptRC5_16 :m_cnxHFCSRealConnection..Access= hOReadWrite //MyConnection..ExtendedInfo = "CRYPT=RC5_16" IF HOpenConnection(:m_cnxHFCSRealConnection)=False THEN Info(HErrorInfo) :SetHError() RESULT False END It connects and works fine as far as new record (inserts) are concerned. I get error if I edit the same record, after WXREngine sends that data. ie I edit one record (tried with color file) and WXREngine sends that data and I again edit the same record, It doesn't get saved, instead the following error appears. The following error I get Error at line 23 of Method hModify Process. HModify function called. OLE DB access error. Error Number = 170147 Faiulure updating record in database System error details: Description = Query timeout expired Source = Microsoft OLE DB Provider for SQL Server SQL State = HYT00 Error Number = -2147467259 (0x800004005) Description = Multiple-step OLE DB operation generated errors.Check each OLE DB status value, if available. No work was done. Source = Microsoft OLE DB Provider for SQL Server Error Number = -2147217887 (ox80040e21) and the software quits. Hope some locking is happening on that particular record (by WXREngine) that prevents the WXReplication screen to update the record. If I edit the same record, before the WXREngine sending the packets, there is no such problem. As I'm new to WX products, I couldn't locate the error, which is causing this problem. Any suggestion to solve this problem is really appreciable. Happiness Always BKR Sivaprakash30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53248/read.awp24 Jul 2015 13:56:00 ZHello Fabrice. Two problems. 1. hAlias. It worked for color table, even after those lines are commented out. But with anot…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53248/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53248/read.awpRe: WXReplication and SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53242/read.awp24 Jul 2015 12:33:00 ZHi, Now we are going somewhere! Quote Sivaprakash Btw, I've totally forgot to mention one more changes I've made. In…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53242/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53242/read.awpRe: WXReplication and SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53228/read.awp24 Jul 2015 07:58:00 ZHello, Any parameter to set isolation level in the OLE DB Connection ? We used to set it to Read Committed in our powerbui…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53228/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53228/read.awpRe: WXReplication and SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53227/read.awp24 Jul 2015 07:57:00 ZHello Fabrice, // However, the reason why this is happening eludes me... From what you are telling me: - The errors occurs …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53227/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53227/read.awpRe: WXReplication and SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53223/read.awp23 Jul 2015 18:56:00 ZHi guys, If I remember right, record blocking is not working with OLE DB. (But I'm no expert on this subject.) I think with n…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53223/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53223/read.awpRe: WXReplication and SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53220/read.awp23 Jul 2015 17:30:00 ZHi again, your changes are logical and where they should be, so I doubt the problem is there (maybe in the parameters used fo…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53220/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53220/read.awpRe: WXReplication and SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53213/read.awp23 Jul 2015 15:14:00 ZHello Fabrice, Let me give the full detail. I"m using 1.1 version in Windev 19, with the following modifications done to acco…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53213/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53213/read.awpRe: WXReplication and SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53211/read.awp23 Jul 2015 14:19:00 ZHi again now that's mighty strange... the engine does NOT touch (read, modify or anything else) the MAIN file (color file in …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53211/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53211/read.awpRe: WXReplication and SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53208/read.awp23 Jul 2015 13:23:00 ZHello Fabrice, Btw, I'm using only your demo package, particularly color table alone for my test. Just switched the database …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53208/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53208/read.awpRe: WXReplication and SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53207/read.awp23 Jul 2015 12:57:00 ZHello Fabrice, Thanks for your time and reply. Without trying the the solution you mentioned, I'm given this reply. This p…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53207/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53207/read.awpRe: WXReplication and SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53205/read.awp23 Jul 2015 12:07:00 ZHi I haven't tested in that configuration, so everything I'm telling you here is pure speculation. I have in the past enco…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53205/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53197-wxreplication-and-sql-server-53205/read.awpRe: WXReplication and SQL Server