11/22/2024 10:55:51 AM
|
| |
| 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!
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.
|
|
|
|
.NET -- OLEDB Provider -- and Remote Tiff files not being created
Posted: 23 Jul 09 12:48 PM
|
I was told (and have seen for myself) that there is a bug with the OLEDB provider when using Raw SQL statements to do updates.
I was told to use the "Dataset" method. So I came up with the following code to test..
It does update the main database, but the Tiff files are still not being created.
Any ideas?
Dim conString As String = "Provider=SLXOLEDB.1 assword=groteersist Security Info=False;User ID=admin;Initial Catalog=SalesLogix;Data Source=MA35;Extended Properties=PORT=1706;LOG=ON"
Dim cn As New OleDbConnection(conString)
cn.Open()
Dim strSQL As String = "Select * from c_Account_ext where accountid = 'A6UJ9A002FDT'"
Dim da As New OleDbDataAdapter(strSQL, cn)
Dim ds As New DataSet()
da.FillSchema(ds, SchemaType.Source, "c_Account_ext")
da.Fill(ds, "c_Account_ext")
Dim cmdBuilder As New OleDbCommandBuilder(da)
da.UpdateCommand = cmdBuilder.GetUpdateCommand
With ds.Tables("c_Account_ext")
.Rows(0)("Adj_Schedule") = "test2"
End With
da.Update(ds, "c_Account_ext")
cn.Close() |
|
|
|
Re: .NET -- OLEDB Provider -- and Remote Tiff files not being created
Posted: 23 Jul 09 1:46 PM
|
TEFF files get created by the Sync Server.
The way sync works (high level):
- When you make any changes, they are stored in Queue files.
- The Logging server converts those Queue files into Workgroup Logs. (which I believe have a similar format as the TEFF files, as they can be viewed with the Tranviewer).
- The Sync Server executes it process those workgroup logs and generates TEFF files for the remote users.
Now, in order for your system to generate files for synchronization it has to have a sync server configured (even if one doesn't really exist).
And, in order for the Sync server to generate TEFFs for remote users/office, there needs to be remote users and/or database created.
|
|
|
|
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!
|
|
|
|
|
|
|
|