Sync with DB2
Hi,
I am using DB2 on server and SQL CE on client and we are not able to perform the sync using Microsoft Synchronization Services, though the code work fine with SQL server at server end.
We had tried with OLEDB and DB2 Data provider, with OLEDB we are able to insert one row in table but all continous insert operations are failed and no update or delete is working.
With DB2 data provider we are able to connect to database but when we are trying to provide connection to sync service provider it is throwing an exception ": Invalid connection object. Unable to create a new instance of the connection object"
Please help, if any one knows any possible solution for this problem
Sachin
[743 byte] By [
min_too] at [2008-2-11]
Hi Sachin,
Were you able to get download only to work? Basically, if you made changes on the server only, can you see the client downloading the changes.
I am trying to isolate the problem, so let's make sure that downloading changes from the server is working and then move to uploads.
Thanks
I am not in office right away, will check and share the code tomorrow
preferably if u can share ur e mail id with me will be more good
thanks
Sachin
Hi All
After working a lot We had found a solution out for the problem we were facing.
While we add parameters to table, earlier we were not providing the size of the parameter, that time it was working for 1 insert and later for all inserts it use to throw an error and today while just trying with some other thing we just provide the size and it started working for inserts, though it is still not working for updates and delete.
If you know the reason, why it work when we provided the size and any solution for updates and insert from client to server please let us know
Sachin.
