Help Needed In Merge Replication, SQL Server 2005 Mobile Edition And VC# 2005
I have written following code in my application
I just want to display all the data of a Single table into a Data Grid, I know that we can drag and drop the table on to a form and datagrid is generated, but here I want to retrive those values through my code, how should i do that
I am getting following errors while running the program
Error 1) Error No. 28037, MS SQL Server 2005 Evrywhere Edition
Error: A request to send data to the computer running IIS has failed. For more information see HRESULT
Error 2) Error No. 0, SQL Server 2005 Evrywhere Edition ADO.Net Data Provider
Error: The specified table does not exist [ JobLists ].
Can anybody please tell me, where I went wrong ??? In this code anywhere else????
Note: While adding a Data Source of SQL Server 2005 Mobile Edition, I have added that .sdf file into my project, thats why I have written the Data Source as : .DbFile.sdf
@"Data Source = .DbDotNetCF.sdf";
The code is as follows:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlServerCe;
namespace DeviceApplication1
{
public partial class Form1 : Form
{
string filename = @".DbDotNetCF.sdf";
private DataSet dsJobLists;
public Form1()
{
InitializeComponent();
}
private void DeleteDB()
{
if (System.IO.File.Exists(filename))
{
System.IO.File.Delete(filename);
}
}
private void Sync()
{
SqlCeReplication repl = new SqlCeReplication();
repl.InternetUrl = @"http://localhost/WebsiteDotNetCF/sqlcesa30.dll";
repl.Publisher = @"RAHU";
repl.PublisherDatabase = @"DotNetCF";
repl.PublisherSecurityMode = SecurityType.NTAuthentication;
repl.Publication = @"PubDotNetCF";
repl.Subscriber = @"SubDotNetCF";
repl.SubscriberConnectionString = @"Data Source='" + filename + "';Max Database Size=128;Default Lock Escalation =100;";
try
{
if (!System.IO.File.Exists(filename))
{
repl.AddSubscription(AddOption.CreateDatabase);
}
repl.Synchronize();
}
catch (SqlCeException ex)
{
DisplaySQLCEErrors(ex);
}
finally
{
repl.Dispose();
}
// Display Same Data In Another DataGrid : dataGrid1
SqlCeConnection cn = new SqlCeConnection(@"Data Source='" + filename + "'");
SqlCeDataAdapter daJobLists = new SqlCeDataAdapter("SELECT JobListsID, JobID, PersonID FROM JobLists", cn);
if (dsJobLists == null)
{
dsJobLists = new DataSet();
}
try
{
dsJobLists.Clear();
daJobLists.Fill(dsJobLists, "JobLists");
dataGrid1.DataSource = dsJobLists.Tables["JobLists"];
}
catch (SqlCeException ex)
{
DisplaySQLCEErrors(ex);
}
}
private void DisplaySQLCEErrors(SqlCeException ex)
{
for (int i = 0; i < ex.Errors.Count; i++)
{
MessageBox.Show("Index #" + i.ToString() + "
"
+ ex.Errors.Source + "
"
+ "Error: " + ex.Errors.Message,
"Error No. " + ex.Errors.NativeError.ToString());
}
}
private void Form1_Load(object sender, EventArgs e)
{
Sync();
DeleteDB();
if (DbDotNetCFDataSetUtil.DesignerUtil.IsRunTime())
{
// TODO: Delete this line of code to remove the default AutoFill for 'dbDotNetCFDataSet.JobLists'.
this.jobListsTableAdapter.Fill(this.dbDotNetCFDataSet.JobLists);
}
}
}
}
I have created a merge replication correctlly( I suppose, there were no errros)
Please help
Your help will be appriciated
View Complete Forum Thread with Replies
Related Forum Messages:
SQL Server Mobile 2005 Merge Replication Problem On Windows Mobile 5.0
Dear ppl, I am writing an application for a device (MDA Pro T-Mobile) having Windows Mobile 5.0 using -MS .NET Compact Framework 2.0 SP-1 -SQL Mobile 2005. -VS 2005 .NET The application uses Merge Replication. The error occurs in the Synchronise() Method of the SqlCeReplication object. "SQL Server Mobile encountered problems when opening the database." repl.AddSubscription(AddOption.CreateDatabase); repl.Synchronize(); I don't understand why I am having this error. It does create the database on AddSubscription() method but it is failing opening the database on Synchronise(). I have also tried uninstalling and then reinstalling all the SQL Mobile components in the following order. -sqlce30.wce5.armv4i.cab -sqlce30.repl.wce5.armv4i.cab -sqlce30.dev.ENU.wce5.armv4i.cab However, when i run this application on a device(Dell X50 AXIM) with Pocket PC 2003, it runs fine creating the database and sysnchronising it. The target platform for the project is Windows Mobile 5.0 Pocket PC SDK. Does any one have any clue what could be the problem ? Regards Nabeel
View Replies !
How Do I Measure Bandwith Usage For Merge Replication SQL 2005 To Sql Server Mobile 2005?
Hi, Is there any way to measure bandwith usage during merge replication between sql server 2005 and sql server mobile 2005 running on a cradled wm5 mobile device. Attaching the windows performance monitor to the network connection established over usb would work although I was wondering if there was something specific for this case integrated into Sql server 2005 / sql server mobile 2005 / Sql server management studio / third party tools that i could use ? thnx, pdns.
View Replies !
Merge Replication Between SQL Server 2005 And SQL Mobile
Hi, I'm currently investigating the feasibility of having SQL Mobile on a number of devices running Windows CE. These devices will have to synchronize with the server (either using merge replication or RDA) over GPRS. The problem I have is that some of these devices will never be online. Is there are a way of synching these offline devices? The model I had in mind was using a USB key (or some other storage device) to download the latest updates from an online device and transferring this data to the offline device, and vice versa e.g. from offline to online and then merging. Is this feasible? Thanks Csharper
View Replies !
Merge Replication 32-bit IIS - 64-bit SQL Server 2005 -Windows Mobile 5 Device
We have setup a 32-bit IIS server on a 32-bit machine. Installed necessary SQL Server components (32-bit replication components). We have installed SQL Server 2005 64-bit SP1 with latest hotfixes on a 64-bit machine. On the Mobile device we installed SQL Server 2005 Mobile. When we start mergereplication the problem we have is error 28009 (An instance of the SQL Server Reconciler cannot be created) on the mobile device. I read allot about it, but still have a questetion. Should this work? I found the doc: SQL Server 2005 Upgrade Technical Resource Guide: Note: If your upgrade involves SQL Server CE subscribers, you must perform additional actions on the IIS server. You will need to install SQL Server 2005 client connectivity components along with SQL Server Mobile Edition components on the IIS server. You will also have to replace sqlcesa30.dlll, sqlcerp30.dll, and all the replication components on the IIS server. From this I conclude it should work or is the doc in error? If it does not, what can we do? 32-bit SQL Server 2005 on the 64-bit machine should work. (Can a 64-bit SQL Server 2005 run alongside 32-bit SQL Server 2005?). Beste regards, Hans Mank
View Replies !
SQL Server Mobile 2005 Merge Replication Failing Over SSL, But Can Browse Through Pocket IE.
Hi All, this system is scheduled to go live in near to a day... but i have hit an issue when switching on SSL. Any help would be greatly appreciated. Device Env: Windows Mobile 5.0 + Messaging and Security Feature Pack SQL Server Mobile 2005. Merge replication works fine without SSL. After running the Configure Web Sync wizzard to setup SSL merge replication no longer works. Note i checked using pocket IE by browsing to https://mycompany.com/pub/sqlcesa30.dll?diag and all worked fine. There was no prompt saying the cert was bad etc. The certificate is a: Equifax secure global ebusiness CA-1 cert. Signature algorithm md5RSA public key RSA(1024 bits) thumbprint algorithm sha1 Stacktrace given is: - ex {"A request to send data to the computer running IIS has failed. For more information, see HRESULT."} System.Data.SqlServerCe.SqlCeException - Errors {System.Data.SqlServerCe.SqlCeErrorCollection} System.Data.SqlServerCe.SqlCeErrorCollection Count 1 Integer Item In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user. System.Data.SqlServerCe.SqlCeError HResult -2147012858 Integer InnerException Nothing System.Exception Message "A request to send data to the computer running IIS has failed. For more information, see HRESULT." String NativeError 28037 Integer Source "Microsoft SQL Server 2005 Mobile Edition" String StackTrace "at System.Data.SqlServerCe.NativeMethods.CheckHRESULT() at System.Data.SqlServerCe.SqlCeReplication.Synchronize() at MyApp.Helper.Replication.SynchronizeInit() at MyApp.CallSynchronize() at System.Windows.Forms.Control.OnGotFocus() at System.Windows.Forms.Control.WnProc() at System.Windows.Forms.ContainerControl.WnProc() at System.Windows.Forms.Form.WnProc() at System.Windows.Forms.Control._InternalWnProc() at Microsoft.AGL.Forms.EVL.EnterMainLoop() at System.Windows.Forms.Application.Run() at MyApp.Program.Main()
View Replies !
SQL Mobile 2005 Merge Replication With SQL 2005 X64
I am having trouble with getting Merge Replication up with a new SQL 2005 x64 Server. I already have it running smoothly with SQL 2005 Mobile and SQL 2000, but I want to migrate the backend to SQL 2005. There is a front end server running IIS 6.0 on Windows 2003 x86 Standard (Server A) with SSL required and Basic Authentication set as the only authentication method (default Domain and Realm are also set). The backend server is running SQL 2005 x64 Standard on Windows 2003 x64 Standard (Server B). The mobile devices are running Windows Mobile 5.0 with SQL 2005 Mobile (Client). From both a standard Windows XP workstation (IE) and the Client (PIE) I can browse to the HTTPS site on port 444 for the sqlcesa30.dll on Server A and get a response in normal and ?diag modes. The ?diag gives success in all but the 8.0 Database Reconciler (I didn't install the SQL 2000 replication components on Server A, my understanding is they should not be needed). Sql Server Module Versions are as follows: sqloledb.dll - 2000.86.1830.0, 9.0 replrec.dll - 2005.90.1399.0, 9.0 replprov.dll - 2005.90.1399.0, 9.0 msgprox.dll - 2005.90.1399.0. The publication on Server B is enabled for Web Synchronization and the Snapshop Agent has run. There are no reported errors on that side. Since I ran into issues getting synchronization to run I have opened up permissions fairly wide in this test environment. The PAL and the Database both have the user I am attempting to sync with listed (I am using the Administrator account in the test domain). I have opened full rights on the Snapshot share on Server B to Everyone (both NTFS ACL on the directory and the Share permissions). The virtual directory on Server A containing the sqlcesa30.dll has also been opened very wide, and the Application Pool does have access to it. The Client is running a custom C#.NET 2005 application. With the exception of changes to set the application to sync with the Server A/B duo instead of the production servers, this application is identical to the code currently being used in production with SQL 2000 Standard. The persistent error that I am getting from the Client being thrown by SQL 2005 Mobile when I attempt to sync is "An instance of the SQL Server Reconciler error object cannot be created. Try reinstalling the replication components." SQL 2005 Mobile components on Server A are set to Logging Level 3 but not returning any errors that I can see to troubleshoot with. All replication components appear to be installed and operational, although I have re-installed them. Besides the obvious question of how to solve the error listed above, is there an issue with am x85 front end IIS 6.0 server talking to an x64 back end SQL 2005 server for merge replication over HTTPS with Windows Mobile 5.0 clients running SQL 2005 Mobile? Based on everything I have read off the MSDN Forums, MSDN articles, BOL, log files, and web searches it seems like I should have an operational synching topology, however clearly I have missed something because I have yet to get a successful subscription through to the publication. Any insight/enlightenment would be greatly appreciated, this seems to be a very narrow and specific area of replication and mobility and information is relatively sparse from my experience so far. Thanks!
View Replies !
Merge Replication With SQL Mobile 2005
We are using SQL 2005 (SP1) and mobile agents with SQL Mobile. We are seeing an excessive number of updates after a device's database is reinitialized. My understanding was that if I generate a new snapshot or reinitialize all subscriptions (from the server), the devices would only get what the database looks like right now (inserts only) after syncing and/or reinitializing, but they are actually getting the right number of inserts and a huge number of updates in Replication Monitor. Any ideas? Thanks! Mike
View Replies !
SQL 2005 Mobile Merge Replication Size Limits?
I am in the process of testing a SQL 2005 Std x64 server with merge replication using Windows Mobile 5.0 clients and SQL 2005 Mobile. The test DB is a copy of the currently active DB, but has been expanded to include some new tables to support planned application functionality extensions. Once the publication exceeds 97 Articles, the error is thrown that "The buffer pool is too small or there are too many open cursors". If I drop one article everything is fine. I ran a test with dummy DB that had 100 blank tables, and this initialized just fine on the client. The additional articles I am publishing (the 98th table) is also empty, but it throws the error anyway. Is there a limit on the total size/number of changes that can be sent? Since I have run tests sending over 64,000 changes to a client during initialization this does not seem to be the case (I am only attempting a little more than 9,700 changes on this initialization). Some other ideas that have been tested without success are to stop the user triggers from propagating, and toggling the AWE setting for SQL. The Replication Monitor does say the client completes replication, and it seems to choke at the very end of completing replication when it attempts to write to the tracking tables. The last successful action is sys.sp_MSadd_merge_history90, and it appears to be acting on the last table added to the publication. There does not appear to be a limit on the number or articles, since I can publish more articles in a dummy DB than I am able here, so it seems to be something to do with size. Any information would be helpful, this is a very frustrating issue. Thanks!
View Replies !
High CPU Utilization On Merge Replication With SQL 2005 Mobile
I have a question for anyone who mas some tips/pointers for optimizing SQL merge replication publications. The front end web server is running IIS 6.0 on Windows 2003 x86 Server Standard (Server A). The back end database server is running SQL 2000 Standard on Windows 2003 x86 Standard (Server B). The merge replication clients connect via HTTPS over the Internet from a custom C#.NET 2005 application using SQL 2005 Mobile running on Windows Mobile 5.0 (Client). The publication itself has several filters on it. The entry point uses the user's Windows username to start the filter. Based on the user, it then filters the records in multiple tables. There are 68 articles and 44 filter statements. The filters extend multiple layers deep, in other words they are not all filtering off the HOST_NAME() variable, some tables filter from records in tables that filter from the HOST_NAME() variable. The publication is set to minimize data sent to the clients, and considers a subscription out of date if it has not synced in the last 4 days. All the rowguids are indexed as well. There are approximately 35 clients actively using the application at any given time. On average, a client will initiate a merge replication 3-4 times per hour from 8am-5pm. Generally, a sync will take between 10 seconds and 2 minutes to complete, with most of them being around 30 seconds on average. When a client starts a sync, there is a spike to about 50% on the server's CPU graph. If multiple clients attempt to sync at the same time the CPU utilization can be pushed to 100% for extended periods (more than 30 seconds). I recently completed a project to increase the bandwidth available to the clients, and plan to reduce the number of filters significantly (although this will obviously increase the amount of data going to the clients and the storage needs on the individual devices). I also plan on changing the setting to not minimize the amount of data sent to the clients. Having said all that, does anyone have any information about how to further optimize merge publications to mobile clients? The next publication will be on SQL 2005 x64 Standard if I can solve the issues in the text environment. I would like to enhance the publication as much as possible to make the end user experience better than it currently is. Thanks!
View Replies !
Replication Between 2000, 2005, && Mobile Edition (with Identities)
Hi, I have a server "A" (which is SQL 2000), a server "B" (SQL 2005), and mobile devices running SQL mobile edition. I need to set up transactional replication between server A & B (with A as the publisher/distributor), and then B needs to be setup with merge replication between it and the mobile devices. Basically I have mostly reference data being pushed out from server A (with only one or two updateable tables) to server B. The mobile devices then connect to server B via a web service, to receive the latest data. The mobile devices can update data, but send the updated data back to server B via another web service (not via merge rep). Server B then sends this updated data back to server A, also using a service (as apposed to native replication). The problem I have is that most tables have identity columns set as their primary keys. I've read about identity management, and would like to specify identity ranges for servers A & B, but this only seems to be possible when using merge rep (or tran. with updating subscribers), not normal (i.e. one-way) transactional rep. Is there a way to get around this? I was going to just replicate without worrying about having identities on the tables on server B, but of course it needs the primary keys (and therefore the identities) for its merge replication to the mobile devices. Any assistance would be hugely appreciated. Thanks, David
View Replies !
A Little Basic Help Needed (SQLServer 2005) Merge Replication
Hi all, We are using SQL Server 2005, on Windows server 2003 R2. We Have Two Database Servers say DBServer1 and DBServer2, Now I wants to do Replication between these to servers, such that 1. The Changes at DBServer1 should be reflected at DBServer2 2. The Changes at DBServer2 should be reflected at DBServer1 3. Changes includes Data changes and Schema Changes 4. After every Synchronization Both Databases should be Identical I tried doing so, what i did was I cofigured Distribution at DBServer1, also Publisher and Publication at DBServer1 and Made a Subscription at DBServer2. What I successfully done is If Publisher means DBServer1 do some changes then it gets updated at DBServer2. But New Rows added at DBServer2 doesn't gets added at DBServer1 Thanks in Advance, Vishalgiri Goswami Kalptaru Infosoft Pvt. Ltd.
View Replies !
Merge Replication (Compact Edition - SS 2005) Does Not See Changes
I have Sql Server 2005 running, it is a publisher of a database with SQL Server Compact Edition subscribers. What I want to achieve is a central server with Pocket PCs connecting via HTTP and synchronizing data. Following MSDN tutorials I created a CE database on my disk, I subscribed to publisher - everything is fine, the data is downloaded when I run synchronization from MS SQL Server Management Studio. Rows are updated, downloaded both ways etc. Then I've created a PocketPC project and added that DB as data source. As suggested, I copied the file to local folder of the project, so now deploying my app to PocketPC also deploys the DB file. It is therefore already a subscriber to my SS2005. The data is also displayed correctly in my app. Hoping that it will be sufficient to synchronize, I've put the following code (using data read from subscription properties in Management Studio): Code Snippet SqlCeReplication repl = new SqlCeReplication(); repl.InternetUrl = @"http://<my IP here>/organetzer/sqlcesa30.dll"; repl.Subscriber = @"organetzer"; repl.Publisher = @"PINKIESQLFULL"; repl.PublisherDatabase = @"vs"; repl.Publication = @"organetzer"; repl.PublisherSecurityMode = SecurityType.NTAuthentication; repl.SubscriberConnectionString = @"Data Source='" + filename + "';Password='';Max Database Size='128';Default Lock Escalation ='100';"; try { repl.Synchronize(); } catch (SqlCeException ex) { MessageBox.Show(ex.ToString()); } When I click the button to run this code, PocketPC connects to the Internet, it doesn't throw any exceptions, the connection is even is detected by Replication Monitor. The problem is that no matter if I change rows on desktop db or on pocket, no changes are ever detected, the synchronization is just running with 0 rows added/updated/removed. Could anybody please explain what are the general steps to make it work ? Am I missing something? Can I upload to PocketPC a database already subscribed to a publication or should I subscribe programatically onyl when the file is on Pocket? Thanks in advance
View Replies !
Is 2005 Merge Replication Reliable For Compact Edition Subscribers On WinXP Tablets Over VPN?
I posted a more detailed technical question a couple of weeks ago with Subject = "Compact Edition 2005 Subscribers - Merge Agent failed after detecting that retention-based cleanup has deleted metadata" But I got no replies. Now my question is simpler: Is SQL Server 2005 Merge Replication reliable with Compact Edition subscribers on WindowsXP tablets? We deleted all users' local databases a couple of weeks ago, and republished two publications with retention = 60 days. Now we have at least one user who can't sync with the server, and replication monitor shows the error below. But if she e-mails her sdf file to a support person, they can successfully sync her database. We're sure that it's not a permissions issue, which is a normal suspicion when one user can perform a task that another can not. It doesn't seem like a retention problem, because she's well inside the retention period. She can successfully sync with the publication with upload/download tablers, but not with the publication with download only tables. Both publications were created on the same day, by the same DBA, with nearly identical properties. This problem user has operated in the past with no problem, and she's configured identically to all of the others. It just seems like random flakyness with merge replication for Compact Edition subscribers. I feel stupid saying that, because it sounds like I believe in a magical ghost in the machine. So my question is - IS MERGE REPLICATION A LITTLE BIT FLAKY FOR COMPACT EDITION SUBSCRIBERS ON XP MACHINES? We've applied SP2 to the server, but no subsequent HotFixes. We're trying to sell users and management on developing a larger occasionally connected system with the same replication scheme, so we need to know if it deserves our confidence. Error messages: The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the Publisher for changes not yet sent to the Subscriber. You must reinitialize the subscription (without upload). (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199402) Get help: http://help/MSSQL_REPL-2147199402
View Replies !
SQL Server 2005 Mobile Edition Vs. RMS
Hello, I am developing a mobile application in which i have to create a database.. My database contains relationships between its tables.. I would like to know what is the best solution for developing the database?? SQL mobile edition or RMS!!! If you say RMS, how should i create the relationships between my tables?? thnx
View Replies !
Update Sql Server 2005 Mobile Edition
I have use this guide to make a application for windows mobile 5.0. http://msdn.microsoft.com/vstudio/tour/vs2005_guided_tour/VS2005pro/Smart_Client/DataBinder.htm Everything is work. I can add, remove data in the dataset. But i can't update the sql server database. can somebody tell me whats wrong? Nitro.
View Replies !
SQL Server 2005 Mobile Edition Free?
Hello I have a question: is the SQL Server 2005 mobile edition free? or is it necessary to buy a licence when i use it combinated with a comercial program which i have delevoped by myself and i sell it? greetings stefan lederer
View Replies !
Merge Replication - SQL Server 2005, Windows Vista And MSVisual Studio 2005
Hello everybody! I hope that someone could help me. I have a problem when i start sincronyzing with the emulator of MSVS2005 to SQL2005 in Windows Vista. I have the same program in the emulator, but sincronyzing with windows XP Pro and no problem... I configure the connection to use the IUSR. The source code that i use: repl.InternetUrl = @"http://laptop/SQLMobileIIS/sqlcesa30.dll"; repl.Publisher = @"laptop"; repl.PublisherDatabase = @"database"; repl.PublisherSecurityMode = SecurityType.NTAuthentication; repl.Publication = @"Pubdatabase"; repl.Subscriber = @"SQLMobile"; repl.SubscriberConnectionString = @"Data Source='" + nomeFicheiroBD + "';Password='3409'"; The error that returns is: "Failure to connect to SQLServer with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect" Does anybody knows what i can do? HELP I NEED SOMEBODY TO HELP! Thanks!
View Replies !
Creating SQL Server 2005 Mobile Edition On Desktop
Hello Everybody I want to create SQL server 2005 mobile database on desktop programmatically with some inital data for my application and load it into device. We can create database only in VS2005 server explorer or SQL server 2005 application. Anybody having this solution for this prob. Regards Chikuu
View Replies !
Memory Usage Of SQL Server 2005 Mobile Edition
Hi forum readers, we are working on a release 2.0 mobile solution right now. In our version 1.0 we did not have to worry about memory issues as our application was the only application running on our target devices (e.g. T-Mobile MDA Compact II Pocket PCs, WM2005). Now we need to share the available memory with others. As our application relies on its SQL Server 2005 Mobile Edition database we are wondering about memory usage of that server. We know that a Pocket PC divides its memory into Storage and Program. If our application uses a 5 MB database and 1.5 MB for DLLs and it's exe-file. These files reside in the storage space when not loaded. When the application starts up it is loaded in the program memory. What happens to the 5 MB database file? Is is loaded into Program memory as well? Are only portions of that file loaded? Or is nothing loaded at all? Does anyone have a deeper insight into that server an can answer my questions. Best regards, Tobias
View Replies !
Mobile Solution With SQL Server 2005 Express Edition And Smartphone
Hi,i want to create a solution which shall consist of a sql server 2005 -data base (express edition if the following features are available byexpress edition) and a mobile windows application (running on asmartphone under windows mobile 5.0).The sql server shall be installed on a ordinary laptop using windowsxp (not professionall edition).Which would be the best way to exchange the data between mobile deviceand pc? I learned that there is a SQL Server Compact Edition for themobile device and that rda would be a way to exchange data - but theni would need internet information system and this does not run on xphome edition.Which alternatives would you suggest me?Thanx in advanceWolfgang
View Replies !
SQL CE 3.0 SQL Server 2005 Mobile Edition Database Password Problem
Hi, I was wondering if someone could help me as this is a bit of a puzzle. I have created a database using a password, the create table scripts are executed successfully using the connection string however when I try and use the same connection string to insert some data into the database an error is produced, with the following message 'The specified password does not match the database password'. I have opened the database using the SQL Server 2005 Management Studio and provide the password and I can access the database without a problem. When the connection object is first instantiated all the Connection String property, the connStr variable and the modifiedConnStr are all correct (by this I mean that the data source and the password are present). However when the connection object is accessed again the Connection String property and the connStr variable are both set incorrectly (by this I mean that the password= section of the string is missing) however the modifiedConnStr is set correctly (by this I mean that the password= section is present in the string). The connection object does not get set in between creating and accessing the connection object. I have resorted to using no password, however I really need to be able to use a password. Here is a copy of the connection string I am using (Copied directly from the quick watch window): "Data Source = '\Program Files\Application\DataBase\MyDatabase.sdf'; password="Pa55word";" I am sorry this a little long winded however I would like to provide as much information as possible. I hope someone can help me with this problem. Thank you for reading. Paul Diston
View Replies !
SqlCeConnection Failing To Open A Connection To The SQL Server 2005 Mobile Edition
Good day, I am writing an application using VB.Net 2005 for the Windows CE 5.0 device and it is connecting to a SQL Server 2005 Mobile Edition Database. The trouble I'm having is establishing a connection to a SQL Server Mobile database on the device. Here is the code I am using: Code Snippet Public gConnectionString As String = "Data Source=Program FilesMobAppMobDB.sdf;Persist Security Info=False;" Code Snippet Imports System.Data.SqlServerCe Public Class DBManager Public Shared gSQLCEConnection As SqlCeConnection Public Shared Function OpenDB() As Boolean If gSQLCEConnection IsNot Nothing Then Throw New InvalidOperationException("Connection already open.") End If gSQLCEConnection = New SqlCeConnection(gConnectionString) Try gSQLCEConnection.Open() 'Error occurs here Return True Catch ex As SqlCeException MsgBox(ex.Message & vbCrLf & ex.HResult & vbCrLf & ex.NativeError & vbCrLf & ex.Source) Return False End Try End Function In the immediate window I recieve the following messages: A first chance exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll A first chance exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll A first chance exception of type 'System.UnauthorizedAccessException' occurred in mscorlib.dll A first chance exception of type 'System.UnauthorizedAccessException' occurred in mscorlib.dll A first chance exception of type 'System.UnauthorizedAccessException' occurred in mscorlib.dll A first chance exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll A first chance exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll A first chance exception of type 'System.UnauthorizedAccessException' occurred in mscorlib.dll A first chance exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll I believe that the first few lines are caused by the icons/pictures that I have included with my app, but the SqlCeException line occurs when the connection to the .SDF file is trying to be established. Here is the exception output: Message: "" (Blank) HResult: -2147024882 NativeError: 0 Source: SQL Server 2005 Mobile Edition ADO.NET Data Provider Programs under Remove Programs on the PDA are: Microsoft .NET CF 2.0 ENU-String R... Microsoft .NET Compact Framework... Microsoft SQL Client Microsoft SQL Mobile 2005 Microsoft SQL Mobile 2005 [EN] Microsoft SQL Server 2005 Compact... Microsoft SQL Server 2005 Compact... Microsoft SQL Server 2005 Compact... Microsoft SQLCE 2.0 Microsoft SQLCE 2.0 Dev Any ideas on what could be stopping this connection from being established? It was working before but all of a sudden just stopped. I have warm booted, cold booted, and rebuilt with no luck and also checked that SQL Query Analyzer is not running on the PDA and that the connection string is valid. The call to OpenDB occurs in the form_load of the startup object. Thanks in advance, Leon
View Replies !
Query Performance Issue Of Sql Server 2005 Mobile Edition On Device
Executing a select query with left outer joins etc takes .53 seconds to execute on sqlce 2.0. Same query on sql 2005 mobile ed. takes 11 minutes . on database having same data. Sample query SELECT routes.location,routes.equipment_type, routes.contract_type, routes.maintenance_interval,routes.bank_description,routes.Unit_Des, routes.Unit_no,max(task_last_completed.date_completed)as date1,min(case when task_last_completed.due_date is NULL then getdate()-1 else due_date end) as due_date FROM routes left outer join tasks on tasks.model = routes.model and tasks.eqtyp = routes.equipment_type inner join task_by_contract_type on tasks.task_id = task_by_contract_type.task_id and task_by_contract_type.contract_type = routes.contract_type and task_by_contract_type.model = routes.model left outer join task_last_completed on routes.unit_no = task_last_completed.equipment_Id and tasks.task_Id = task_last_completed.task_Id WHERE routes.location LIKE 'S153825-01%' group by routes.location,routes.equipment_type,routes.contract_type,routes.maintenanc e_interval,routes.bank_description,routes.unit_des,routes.unit_no ORDER BY routes.location, routes.bank_description, routes.Unit_Des WHY????????????????
View Replies !
SQL Mobile 2005 Replication - SQL Mobile DLL Could Not Be Loaded - Error 28559
I am migrating a pocket PC application from VS 2003 to VS 2005 and a few weeks ago I hit the following problem when replicating A SQL Mobile DLL could not be loaded. Reinstall SQL Mobile. [ DLL Name=sqlceca30.dll] Scanning forums for help I saw that other people had had this problem and one http://www.eggheadcafe.com/aspnet_answers/NETFrameworkCompactFramework/Feb2006/post25814466.asp suggested that this problem could be circumvented by getting the replication object early and then continuously using the same object for subsequent replications. I did this and it works a lot better now but ever so often I get another error which is Native Error 28559 SQL Mobile encountered problems when opening the database My only option at this point is to stop and start the application which cures the problem.
View Replies !
SQL Mobile Server 2005 To SQL Server Developer Edition 2000
I am looking for a detailed tutorial that explains how to set-up merge replication services for a major project. I have seen all of the claims that SQL Mobile Server 2005 is able to connect to a merge publication with SQL Server 2000. However, where are the tutorials? I must have a proof of concept in a few days to quote this project. Can anybody help with this issue? Thanks!
View Replies !
SQL Server 2005 Mobile Edition Using Server Tools
I have installed SQL Server 2005 Mobile edition and also the server tools. I configured a website to sync with my mobile application. When I go t check the SQL server Mobile agent with this url: http://localhost/MobileTest/sqlcesa30.dll i get a http 500 internal error I am using remote desktop to access the machine, when I am directly on the machine there is no error I get the correct message in the browser "SQL Server Mobile Server Agent 3.0" Is access to the web site via remote desktop a problem? jawahar
View Replies !
Locking Up After SQL Server Mobile Merge Replication
Hi , I would like to get your advice in an issue that I am facing regarding merge replication. The flow is like: 1) User enter his login name and password. 2) Host_name is set as the login name that the user enters. 3) Based on the HOST_NAME property after filtering user gets the records relevent only to him (Differnet subscriber may use same mobile device). 4) He make some changes in the local sdf according to the business logic. 5) The application Syncs with server on the next login session. My issue is when I am trying to run the application in emulator exactly at the sdf updating part the application terminates. Error mess: Connection to Remote Device has been lost..... If I execute the same sql insert query it works om the local sdf and master database. Emulator used where Pocket PC 2003 SE and Windows Mobile 6 classic emulator. I have installed 1) Visual Studio 2005 SP 1 2) net compact framework SP2. When I comment all the code related to Sync ,application works witout any issue. And the same application works in my "I mate kjam". The code that I use is given below: ========================================================================== public void Sync(string hostname, int newsub) // Parameters for HOSTNAME and flag to denote new user or existing //user. { SqlCeReplication repl = new SqlCeReplication(); repl.InternetUrl = @"http://231.000.000.211/Merge/sqlcesa30.dll"; repl.Publisher = @"SERVER"; repl.PublisherDatabase = @"Merge"; repl.PublisherSecurityMode = SecurityType.DBAuthentication; repl.PublisherLogin = @"sa"; repl.PublisherPassword = @"password"; repl.Publication = @"Merge"; repl.Subscriber = @"MergeSub"; repl.HostName = hostname; repl.SubscriberConnectionString = @"Data Source=""Program FilesMerge.sdf"";Max Database Size=128;Default Lock Escalation =100;"; try { if (newsub == 0) { if (File.Exists(@"Program FilesMerge.sdf")) { File.Delete(@"Program FilesMerge.sdf"); } repl.AddSubscription(AddOption.CreateDatabase); repl.Synchronize(); repl.Dispose(); MessageBox.Show("newuser sync Done"); } else { if (!File.Exists(@"Program FilesMerge.sdf")) { repl.AddSubscription(AddOption.CreateDatabase); repl.Synchronize(); repl.Dispose(); MessageBox.Show("FirstSync Done"); } else { repl.Synchronize(); repl.Dispose(); MessageBox.Show("SameuserSync Done"); } } ================================================================================= Please advise......
View Replies !
Replication Between SQL 2005 Express Edition And SQL 2005 Standard Edition
Hello everybody, I got a problem in my development phase. I'm developing a web-application system that running merge database technology which is centralized database and distributed database. This is because my customer want a highly optimum system standby. My centralized database running SQL Server 2005 Standard Edition and the distributed database running SQL Server 2005 Express Edition (because it is free). Each of these database, the users can change the data on its database. So, every database must have the same data. from my understanding, each server must act as Publisher and Subscriber. Can SQL Server 2005 Express Edition be a Publisher? If not, what the solution you all may suggest, because cost is the first factor. If my architecture is not correct, so what you all suggest to me to resolve the problem. Thanks so much. Any suggestion and opinion is highly appreciate and I'm highly thanks to you all.
View Replies !
Help Needed In Accessing A Sqlserver 2005 Express Edition From Client Systems To The Server 2003 R2 Servermachine.
hi guys, i am having a truble in accesing the server 2005 express edition from my client systems in server 2003 domain network. i get server not accessible. whereas my domain is working perfectly. i really tried alot and i have enable tcpip and named pipes and i am still getting errors while accessing. i have also created user reights for the domain users to access sql server. still i couldn't able to access it. please guide me to over come this issue. I'm dying.My project is similar to SAP concept project and i am doing it in a production industry.so each department as to access the data from the server to update their daily production and activity. thnks in advance. Viswa
View Replies !
Merge Replication Issue SQL Server 2005
I have set up merge replication with 1 publisher and 1 subscriber. Distribution is handled by a 3rd server. I can generate a snapshot at the publisher and apply it to my subscriber. But when I insert some data (approx 30,000 rows) , the Synchronization agent gives the following error when It runs: The merge process is retrying a failed operation made to article 'xxx' - Reason: 'The Merge Agent was unable to synchronize the row due to one or more unanticipated errors in the batch of changes. When troubleshooting, increase the -OutputVerboseLevel setting, restart the agent, and check for and resolve any errors generated by the database engine. '. I have increased the OutputVerboseLevel setting and specified a file path in the -OutputMessageFile but the File is not being populated. All the references on books online say to put the file path in the -Output parameter but when I do it says it can only hold an integer value. So I cant see the errors generated by the database engine. Could anybody please assist with this issue? Thanks
View Replies !
Merge Replication Issues SQL Server 2005 X64
Hi ppl, I have installed SQL Server 2005 x64 Enterprise edition with Service Pack 2 on a Windows Server 2003 x64 Standard Edition with Service Pack 2. Now I have to configure Merge Replication that will work with SQL Server Compact Edition database on Windows Mobile devices. Distributor and the Publisher are the same server. IIS 6.0 is installed on the windows server. I have installed the SQL Server Compact Edition Server tools on the server. However the compact edition server tools are only available for 32bit servers and I have also found out from the article http://support.microsoft.com/default.aspx/kb/912430 that you cannot replicate data from SQL Server 2005 to SQL Server Compact Edition by using the 64-bit version of IIS. So if this is true does that mean I can not use merge replication on 64 bit server? Does that mean I have to get another 32 bit server with 32 bit IIS on it to make this work or is there another work around. Am i missing something here? Regards Nabeel
View Replies !
Microsoft SQL Server 2005 RTM Merge Replication Issues
We are trying to implement merge replication between 2 servers. Database size is around 11GB. When I tried to create publication, snaphot agent is failing with following errror. Error: 14151, Severity: 18, State: 1. Replication-Replication Snapshot Subsystem: agent NBTENTSQL1X-PayDirectWeb-PayDirectPub-2 failed. The replication agent had encountered an exception. Source: Replication Exception Type: Microsoft.SqlServer.Replication.ReplicationAgentSqlException Exception Message: String or binary data would be truncated. Cannot find the object 'MSmerge_sel_4D388 The table where the snapshot is breaking contains around 169 columns. Can someone please help me get through this error ?
View Replies !
Large MSMerge_History, MSMerge_genhistory,MSRepl_errors Tables In SQL Server 2005 Express Edition (Merge Push Subscriber)
SQL Server 2005 Standard Edition act as publisher and distributor. All subscribers are SQL Server 2005 Express Edition. According to 2005 book online, "MSMerge_History table exists in distribution database". Howevey I found this table in Subscriber database which is in SQL Server 2005 Express Edition. The problem is this table (MSMerge_History) and other two tables (MSMerge_genhistory, MSRepl_errors) are quite large. We want to keep SQL Server 2005 Express database as small as possible so we can put more data into it. Is there anyway (Manually or automatically) to clean those tables in SQL Server 2005 Express? Please help.
View Replies !
Help - SQL Server 2005-&>Compact Edition Replication
Hi All ...I have been following the MS on-line tutorials to get replication setup between SQL Server 2005 and SQL Server Compact Edition. I get to the point where I run the Configure Web Synchronization and it is running through the process where it is doing the automated configuration of the shared directory - assigning users etc.I have attempted this step with a user account that I expressly created for snapshots and with the Administrator account and get the following error message:* The operation completed successfully. (Exception from HRESULT: 0x80070000)At first, I thought this was a rights issue due to the fact that I was using an account that I manually created. However, by using the Administrator account (test only until I can figure this out) that should have removed any rights issues associated with accessing the shared directory where the snapshot will reside.Any help in getting this figured out will be greatly appreciated.David L. Collison Any day above ground is a good day!
View Replies !
SQL Server 2005 Everywhere Edition: Replication With MS Access?
Hello @all, does anyone know whether a SQL Server 2005 Everywhere database can be replicated with a common MS Access database? Is there any possibility to synch a database on a mobile device (SQL Everywhere) with a central database on a server computer (like MS Access or SQL Express) without having to use a full version of SQL Server? Replication is just needed for merging a small database (4-5 tables) so I think the full version of SQL Server is a little bit oversized for this issue (and too expensive, too). Thank you very much in advance, Tim
View Replies !
SQL Server 2005 Merge Replication Without A Hard Coded Password
Hi. I've looked all over MSDN, newsgroups and the web but I can't find the answer to a problem that I am having. The application that I am working on used both transactional and merge replication. I want to avoid hard coding passwords into an application that kicks off the pull replication on the client machine. The client machines are all using SQL Server 2005 Express. The other machine is running SQL Server Standard. The passwords and login details are specified in the subscription properties in the Management Studio. A fragment of the code is posted below. The transactional sychronization works fine without having to specify any passwords - however the merge replication does not work if both of the passwords are not specified. private void SynchButton_Click(object sender, EventArgs e) { // Set up the subscriber connection details. subscriberConnection = new ServerConnection(subscriberName); try { // Connect to the Subscriber. subscriberConnection.Connect(); // Do the transactional subscription synchronisation independantly of the // merge subscription replication. try { transPullSubscription = new TransPullSubscription(subscriptionDbName, publisherName, publicationDbName, transPublicationName, subscriberConnection); // If the pull subscription and the job exists, start the agent job. if (transPullSubscription.LoadProperties() && transPullSubscription.AgentJobId != null) { TransSynchronizationAgent transSyncAgent = transPullSubscription.SynchronizationAgent; transSyncAgent.Synchronize(); } else { } } catch (Exception ex) { } // Do the merge subscription synchronisation independantly of the // transactional subscription replication. try { // Set up the subscription details for the merge subscription (bi-directional data) mergePullSubscription = new MergePullSubscription(subscriptionDbName, publisherName, publicationDbName, mergePublicationName, subscriberConnection); // If the pull subscription and the job exists, start the agent job. if (mergePullSubscription.LoadProperties() && mergePullSubscription.AgentJobId != null) { MergeSynchronizationAgent mergeSyncAgent = mergePullSubscription.SynchronizationAgent; mergeSyncAgent.DistributorPassword = "<<password>>"; mergeSyncAgent.PublisherPassword = "<<password>>"; mergeSyncAgent.Synchronize(); }etc etc.. Any help or suggestions will be greatly appeciated. Thanks.
View Replies !
SQL Server 2005 Express Edition Performance And Replication
Wondering if anyone has any experience with SQL Server Express Edition (SSEXP). We're looking at a mobile sales force type model, so a local database on a laptop with no real time network connection. So the users would collect data locally, then connect up to the network every few days to replicate the data to a central server. So questions.. Has anyone tried anything similar? How stable/mature is SSEXP? Any other thoughts, alternatives or gotchas anyone can think of? Thanks for the input.
View Replies !
SQL SERVER 2005 REPLICATION (MERGE AGENT FAILING : PUSH SUBSCRIPTION)
ERROR MESSAGE: "Message: Incorrect syntax near 'NoteID'." Here is a snipet from the output file: 2006-03-27 13:01:49.820 Skipping file 'NotesHistory_21.sch' because it has already been delivered for a previous article or by a previously interrupted snapshot. 2006-03-27 13:01:49.867 OLE DB Subscriber 'LUZERNV4-PDOSQL4': SET ANSI_NULLS ON 2006-03-27 13:01:49.898 OLE DB Distributor 'LARGOS00-SDI': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} 2006-03-27 13:01:49.945 OLE DB Subscriber 'LUZERNV4-PDOSQL4': SET QUOTED_IDENTIFIER ON 2006-03-27 13:01:50.008 [17%] OLE DB Subscriber 'LUZERNV4-PDOSQL4': CREATE TABLE [dbo].[MSmerge_conflict_EFILE_MERGE_NotesHistory]( [NoteID] [int] NOT NULL, [CaseRefNum] [int] NOT NULL, [KeyField] [varchar](500) NOT NULL, [KeyValue] [varchar](500) NOT NULL, [Note] [varchar](800) NULL, [NoteField] [varchar](100) NULL, [ScanDocID] [int] NULL, [PDF_ID] [int] NULL, [RescanCode] [int] NULL, [RescanNote] [varchar](100) NULL, [AuditID] [bigint] NOT NULL, [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL ) ꜽśã¹? êœ?Å›B 27 13:01î–”Å›è›ªç —êœ?Å›é”?Ä€Percent Complete: 17 2006-03-27 13:01:50.086 OLE DB Subscriber 'LUZERNV4-PDOSQL4': SET ANSI_NULLS ON 2006-03-27 13:01:50.117 Preparing table 'NotesHistory' for merge replication 2006-03-27 13:01:50.164 OLE DB Subscriber 'LUZERNV4-PDOSQL4': SET QUOTED_IDENTIFIER ON 2006-03-27 13:01:50.195 OLE DB Distributor 'LARGOS00-SDI': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} 2006-03-27 13:01:50.258 OLE DB Subscriber 'LUZERNV4-PDOSQL4': if object_id('MSmerge_conflicts_info') is not NULL alter table [MSmerge_conflict_EFILE_MERGE_NotesHistory] add origin_datasource_id uniqueidentifier NULL 2006-03-27 13:01:50.351 OLE DB Subscriber 'LUZERNV4-PDOSQL4': if object_id('MSmerge_conflicts_info') is not NULL create nonclustered index [ncMSmerge_conflict_EFILE_MERGE_NotesHistory] on [MSmerge_conflict_EFILE_MERGE_NotesHistory] ([rowguid], origin_datasource_id) 2006-03-27 13:01:50.383 OLE DB Subscriber 'LUZERNV4-PDOSQL4': exec sp_MSsetconflicttable @article = N'NotesHistory', @conflict_table = N'MSmerge_conflict_EFILE_MERGE_NotesHistory' 2006-03-27 13:01:50.430 OLE DB Subscriber 'LUZERNV4-PDOSQL4': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} 2006-03-27 13:01:50.476 [17%] The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write.Percent Complete: 17 2006-03-27 13:01:50.50é”?Ä€ 2006-03-27 13:01:50.539 Applied script 'NotesHistory_21.cft' 2006-03-27 13:01:50.586 OLE DB Subscriber 'LUZERNV4-PDOSQL4': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} 2006-03-27 13:01:50.617 OLE DB Distributor 'LARGOS00-SDI': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} 2006-03-27 13:01:50.711 Percent Complete: 17 2006-03-27 13:01:50.742 {call sp_MSsetconflicttable (N'NotesHistory', N'MSmerge_conflict_EFILE_MERGE_NotesHistory', N'LARGOS00-SDI', N'EFILE', N'EFILE_MERGE')} 2006-03-27 13:01:50.773 OLE DB Distributor 'LARGOS00-SDI': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} 2006-03-27 13:01:50.867 Percent Complete: 0 2006-03-27 13:01:50.898 Category:COMMAND Source: Failed Command Number: 0 Message: {call sp_MSsetconflicttable (N'NotesHistory', N'MSmerge_conflict_EFILE_MERGE_NotesHistory', N'LARGOS00-SDI', N'EFILE', N'EFILE_MERGE')} 2006-03-27 13:01:50.961 Percent Complete: 0 2006-03-27 13:01:50.992 Category:SQLSERVER Source: LUZERNV4-PDOSQL4 Number: 102 Message: Incorrect syntax near 'NoteID'. 2006-03-27 13:01:51.039 Percent Complete: 0 2006-03-27 13:01:51.070 Category:NULL Source: Merge Replication Provider Number: -2147201001 Message: The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write. 2006-03-27 13:01:51.133 Disconnecting from OLE DB Subscriber 'LUZERNV4-PDOSQL4' 2006-03-27 13:01:51.180 Disconnecting from OLE DB Subscriber 'LUZERNV4-PDOSQL4' 2006-03-27 13:01:51.226 Disconnecting from OLE DB Subscriber 'LUZERNV4-PDOSQL4' 2006-03-27 13:01:51.258 Disconnecting from OLE DB Subscriber 'LUZERNV4-PDOSQL4' 2006-03-27 13:01:51.305 Disconnecting from OLE DB Publisher 'LARGOS00-SDI' 2006-03-27 13:01:51.336 Disconnecting from OLE DB Publisher 'LARGOS00-SDI' 2006-03-27 13:01:51.383 Disconnecting from OLE DB Publisher 'LARGOS00-SDI' 2006-03-27 13:01:51.414 Disconnecting from OLE DB Publisher 'LARGOS00-SDI' 2006-03-27 13:01:51.445 Disconnecting from OLE DB Distributor 'LARGOS00-SDI' 2006-03-27 13:01:51.492 Disconnecting from OLE DB Distributor 'LARGOS00-SDI' 2006-03-27 13:01:51.523 The merge process will restart after waiting 60 second(s)...
View Replies !
|
TRACKER
