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!
|
|
Synching to remotes
Posted: 19 Aug 08 1:38 AM
|
I'm using the provider to insert an activity, it does so successfully, but it does not sync to remotes.
Is there any other table I should be writing to so that it syncs?
Is there an issue when using a parameterized query as opposed to a sql query string? I'm using Datasets and performing the insert/updates through the adapter.
Thanks. |
|
|
|
Re: Synching to remotes
Posted: 19 Aug 08 2:14 AM
|
Hi Sara
Does your INSERT populate USER_ACTIVITY as well? Have you logged in to the host db as a remote user and verified that all is well on the host?
Your parameterised query should be fine. Are you using a .NET application to perform the update? There are sometimes issues with date formats ...
Phil
|
|
|
|
Re: Synching to remotes
Posted: 19 Aug 08 9:57 PM
|
It's not adding to USER_ACTIVITY. Does it need to update INDEXUPDATES as well?
It is a .NET app. Dates are saved fine as far as I can tell. |
|
|
|
Re: Synching to remotes
Posted: 19 Aug 08 11:18 PM
|
That looks like a Speedsearch table to me - the Speedsearch service will take care of updates here - so 'no' is your answer.
Phil |
|
|
|
Re: Synching to remotes
Posted: 30 Aug 08 11:24 AM
|
| It now adds to the USER_ACTIVITY table but still, the sync doesn't happen. Anybody have the same issue? |
|
|
|
Re: Synching to remotes
Posted: 31 Aug 08 12:59 PM
|
If you are only utilizing the SLXOLEDB in a third party app: Does you connection string have logging =ON ?
c |
|
|
|
Re: Synching to remotes
Posted: 31 Aug 08 8:02 PM
|
Yes. It has LOG=ON in the extended properties. I have Extended Properties="PORT=1706;LOG=ON"
Here is what my connection string looks like:
Provider=SLXOLEDB.1;Data Source=SERVERNAME;User ID=UserId;Initial Catalog=CatalogName;Extended Properties="PORT=1706;LOG=ON"
I am really running out of things to try, any ideas? |
|
|
|
Re: Synching to remotes
Posted: 01 Sep 08 7:29 AM
|
Are you using an "INSERT" Sql statement(s) to do the work?
If so, is the format of the datetime strings exactly:
YYYYMMDD hh:mm:ss (20080901 08:27:00)
If not, chage them to be so.. In 99% of all cases where everything is right.. data goes into local db fine (main or remote) but does not sync.. it's the datetime string format that's wrong. |
|
|
|
Re: Synching to remotes
Posted: 01 Sep 08 12:36 PM
|
I'm handling that using Datasets and the insert and update through a DataAdapter. Dates are handled with DBType as DateTime with ProviderType as DBTimeStamp.
Should I treat them like strings instead and just format them that way?
The dates are displayed correctly when browsing the tables using SQL Server Management Studio. |
|
|
| |
|