slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

External Development Forums - SalesLogix OLEDB Provider
Forum to discuss using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix OLEDB Provider | New Thread

View: Search:

Author

Thread: Data inserted in hostdatabase throught SLX Provider but no TEF created

Chris
Posts: 18

Data inserted in hostdatabase throught SLX Provider but no TEF created Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Jun 06 9:44 AM

Hello,

I made a program with C# .Net using SLX OLEDB Provider (SLXOLEDB.1).
The connectstring is :
string cs_slx="Provider=SLXOLEDB.1

assword=XXX

ersist Security Info=True;User ID=admin;Initial Catalog=SALSAT;Data Source=XXX;Extended Properties=" + '"' + "PORT=1706;LOG=ON" + '"';
I use the ExecuteNonQuery method.
The program updates one record in the ACCOUNT table. It works on the hostdatabase (I can view the updated Account on SLX (6.2 SP1)).
But the synchronization server doesn't create any TEF in the oufiles directory !!!
Help !

[Reply][Quote]

Jason McCormack
Posts: 8

Re: Data inserted in hostdatabase throught SLX Provider but no TEF created Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Jun 06 12:44 AM

Chris,

I think you need to upgrade to 6.2.1 HF8. Here is the description of the HF from the SLX website. I had a client experiencing this issue as well, and it solved it once applied. I you are already on HF 8, well then, not sure what to say

.

From the SLX Support site -

SalesLogix Service Pack 1 Hot Fix 8 (v6.2.1) corrects a condition where queue files are not consistently generated when a small amount of data is updated in an external application that is using the SalesLogix provider.

Jason

[Reply][Quote]

Chris
Posts: 18

Re: Data inserted in hostdatabase throught SLX Provider but no TEF created Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Jun 06 4:20 AM

lexapro and pregnancy risks

lexapro pregnancy risk category avonotakaronetwork.co.nz

Hello Jason,

Thank you for your answer, but I need more informations :
* Where can I find the full description of HF8 ? (upload of a .pdf ? URL ?) ? Which programs are modified by this HF ? Is the HF8 a bundle (sxb) or an executable ? There is only the SLX Provider and the Administrative Tools on the server where my program runs.
* This program updates or inserts very small amount of data (1, 2 or 3 records !!!) (it is a test...), and the TEF are created sometimes only (one or twice a day, but I launch at least 10 synchronizations per day !). But when the synchronization works, "old" modifications don't seem to be taken into account at all. Has your client exactly the same problem ?

Thanks a lot

Chris

[Reply][Quote]

Frank Chaffin
Posts: 475

Re: Data inserted in hostdatabase throught SLX Provider but no TEF created Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Jun 06 7:17 AM

You should be able to get HotFix information from your SalesLogix Business Partner, or directly from Sage ( http://www.sagesoftware.com ) if you have a support contract.

[Reply][Quote]

Jason McCormack
Posts: 8

Re: Data inserted in hostdatabase throught SLX Provider but no TEF created Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Jun 06 11:32 AM

buy abortion pill espana

buy abortion pill espana go

Chris,

As Franks said, you get it from support.saleslogix.com and it does require a current maintenance contract. The HF overwrites SLXLoggingObj2.dll to resolve the issue which is part of the provider.

Jason

[Reply][Quote]

Chris
Posts: 18

Re: Data inserted in hostdatabase throught SLX Provider but no TEF created Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 23 Jun 06 3:34 AM

Thank you, Jason and Frank !
We have installed HF8 on our server and now, the syncserver generates a TEF systematically, even if there is only one insert in the host database.
However, I have another problem ! Sometimes the Synchronisation Client doesn't work : it stops during the "Applying transaction # of #" and the "SyncErrors.txt" on the "remote" computer shows "Erreur OLE 800A0E7F". Why ?

Chris

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/22/2024 3:41:23 PM