I am developing a application on PDA using c# compact framework. I would like to do synchornisation of sql mobile 2005 database with sql server 2005 database using web service.
The reason for going to webservice is based on the client request.
Will anybody help me on this, how to perform conflict management etc.
Hi everyone,
I am attempting to drag the SQLDataSource control to my webpage to initiate a connection to my SQLServer Express instance on the same system. The control will drop correctly, but when I click on the "Configure Data Source" in the SQLDataSource Tasks popup panel, I get the following error message:
Following error occured while getting connection string information from configuration."Cannot get web application service"
It then sends me to the configure data source window where it asks me to choose my data connection. However, there is nothing in the pulldown, and the "New Connection" button does nothing.
I have the SSE data connection defined and visible in the Server Explorer, and there is a connection string defined in the web.config file that points to the server and database I wish to access.
I'm on day 2 of my excursions with VS2005 Pro, so I feel that I'm missing something huge, but otherwise obvious that's different in the configuration of VS2005 as opposed to VS2003, which I have no issues with.
Thanks!Chris
Dear friends,
I am working in .net windows application with sql server 2000. My problem is like some times sql server service automatically stoped when restart my machine.Then i start the service manually.after that if i restart my machine it not affect the service.I mean only at first time restart the machine make this problem. Anybody know any solution for this problerm?.
Also how can i anable TCP/IP through application.
Thanks & Regards
Jesseja
Some of my receiving service side applications usually work offline, andthey only are supposed to get connected to the network once/few times a day,to send/receive Service Broker messages.Will my sending service side application (permanent connected to thenetwork) keep retrying repeatedly to connect to the receiver?- Is retrying like that time consuming?.- I don't like it keeping trying over and over. Is retrying behaviorconfigurable?thx
View 2 Replies View Relatedi am new for SQL server report service, i have a project that need to generate report and integrate or shown on my window application,
so i have a few questions as follows:
1) do i need to add web reference ( report ) to my window application?.
2) how can i preview and print .rdl report within my window application?
3) how to automatically printer report? can this be done by within a store procedure or trigger or in window application?
ps: view reprot manager, ---- http://localhost/reportserver$SQLEXPRESS
ask me name & password? what name should i type in sa? or Administrator or ?
many thanks,
C
Hi,
Please excuse me if I get some terms wrong - I am not a developer!!
I am working for a company who has a requirement to interface to a customer to query for work. The customer has an established Web Services that it uses for external interfacing, these services are passive at their end, in that it will be my clients who initiate all the communications using SOAP, receiving responses in XML.
There are, as I see it, seven conversations.
Receiving Datasets
1. Requests All new Jobs - This will be a post to a HTP with a list of job numbers sent back, These jobs will then need to be polled from the same webservice.
2. Job Changes - existing jobs that have changed definitions (costs etc..)- simular to above
3. Job Changes - Appointment Times
Sending Datasets
1. Completed Jobs - one at a time
2. Cancelled Jobs
3. Appointments (I believe this is responses to 1 and 3 above)
4. Subsequent Jobs - new work derived from initial Job.
I believe the sending datasets will be one way only (ie POST).
I have suggested using Service Broker for this application, with a custom App sitting inbetween ServiceBroker and the Web Service to deal with the HTTP POSTS and GETS, and communicating with the Service Broker, posting to queues and reading from them.
Is this viable??
Many Thaks
Lawrenso
hi all,
i want to create a service broker application between two different instances.
can i achieve the dialog security and transport security with out using certificate?
like we can achieve the transport security using windows authentication (both the instances are in same domain).
so how to achieve the dialog security with out using certificates.
if any body has any link plz provide me.
Thanks a lot!!!!!!!!!!!!!!!!!!!!!!!!!!
In SQL 2005, is this an acceptable (prefered) way to give an application account EXEC permissions for sprocs and funcs in a specific database?
CREATE ROLE db_executor
GRANT EXECUTE TO db_executor
And then of course assign my user to this role on the database level.
I am trying to get away from adding exec to every sproc "manually" and then of course also having to add exec for any new sprocs that get added into the database.
Hi all,
I use SQL Express 2005 with my application that is deployed to the customers with the ClickOnce technology.
Now I want to upgrade automatically the SQL Express to che customers deployed with the Service Pack1.
How can I automated this process?
Thanks,
Bonato Pierantonio
Hi
I have been giving myself a headache over deploying and synchronising sql databases.
Can anybody point me in the right direction of a tool that can help me to synchronise changes of structure / data between two databases. I have used the demo version of SQL compare, but I think its way too expensive. Does Microsoft produce a tool that can perform similar functions? If not can anybody point mew in the way of a tutorial that can help me with migration / deployment / synchronisations of SAL Databases.
Many thanks
Hi
For our application we want two Publisher models:
1) running SQL Server 2005 standard on Windows Server 2003
2) running SQL Server 2005 standard (or workgroup) on Windows XP pro
The reaseon is simply cost. The first for clients that may have 10s / 100s of SQLce subscribers, the second for just 1-5 SQLce subscribers.
We want to use Web syncronisation. Problem is when setting up on the XP box I get to the final bits of Microsoft's setup document and it starts to tell you to set up an application pool. As far as I can tell this is only available on IIS6 on Windows Server 2003.
Searching the Internet I don't seem to be able to find a definative 'don't be a pratt' you can't run Web Synchronisation from a XP pro box.
Could someone let me know if it is or is not possible. If I could get SQL Express to be a publisher (to SQLce subscribers) I would have prefered not to have the cost of a full verision of SQL Server for our smaller clients.
Many thanks in advance
Alistair
hi every body please help me out on this issue , since i am at final stage in finishing up the module.
Previously i had done web synchronisation using RMO it is working fine at my office where i have an 2003 server which is an domain controller , publisher i have configured on the 2003 server , and i had subscribers on xp Machines where it was well working fine, clients were not on the domain , it is an independent Machine. we had an security error which was resolve by this same forum, ie the client windows login id should exists on the server too. only then synchronisation is happening at our office,
Now the problem is i have an same setup , but the server 2003 is hosted at a remote place , which is not an domain controller, now if i try to synchronise from our office i am getting "A Security Erorr Occured" , is it so that the publisher should be configured as an domain controller please any body resolve this issue
Thanks
iam able to open the web sync diagnostic information using URL https://itneersrv.abitta.com:443/Synchronise/replisapi.dll in the internet explorer but while running throuth the c# code to run Merge agent i am gettin the following error ,
[0%] InProgress The Merge Agent could not connect to the URL 'https://itneersrv.
abitta.com:443/Synchronise/replisapi.dll' during Web synchronization. Please ver
ify that the URL, Internet login credentials and proxy server settings are corre
ct and that the Web server is reachable.
A security error occurred
I am trying the synchronise through Internet where i have an publisher is at different country and subscriber at my office in India , i have given all privileges but then too i am getting same error , can any body help out on this..i have posted serveral times , few people responed but i could'nt resolve this issue
We have a central server, with offices from other country's synchronising with our main DB. Some are fine, but many for some reason keep getting the same error message time after time:-
"The process could not log conflict information"
You then go into the problem and it says it can not read the file of a particular table due to Error 53.
I have no idea what this means. If anyone can help, I'd be very appreciative!
Thanks in advance,
Greg
We have a fair number of databases in different countries and we synchronise with them everyday. Apart from all the problems we have, recently it has gone well. In HQ, we have local database and also 1 which the countries synch with. Therefore, the local database needs to synch with the synch database. That is successful every time. The only problem we have is that after synchronisation is complete, there are differences in data in the 2 databases and we don't understand why - after all, synchronisation is meant to keep the databases the same. If anyone has any ideas why this is happening, I would be very grateful if you could get back to me. Thanks.
View 3 Replies View RelatedHi Guys, my first post here for quite a while.
I have a question regarding replication and or database synchronisation:
I am doing some work on a SCADA control system in .Net - (SCADA=[S]upervision, [C]ontrol And [D]ata [A]quisition)
Obviously, these are mission critical systems that must have uptimes of greater 99%.
Tradiotionally, we have used custom written database in assembler or C, but these are getting rather long in the tooth, and, in my opinion, represent a massive man-time investment developing something that already exists 'off the shelf' (for example, our custom written database, the first version of which roled out nearly 20 years ago doesn't support SQL)
So, I'm looking to see if there is an off the shelf DB that can do what we need it to do. I lean towards Microsoft because of it's integration with the .Net platform.
However, probably the most important criteria for us is that of database synchronisation - as data from the plant arrives it is stored in a database (obviously) - however, at the SAME TIME, it is sent to a back up (standby) database which is identical in every respect, except it does not 'answer' queries, it only listens and keeps it's database up to date. Then, should the 'primary' database server fall over, the standby will become active, and it is up-to-date ready to run.
Does SQL server offer such a facility that changes to a database can be immediately and automatically 'echoed' to a standby database? Automatic promotion from standby to main is not an issue, as this decision would be taken by the application software 'in front' of the database - if it cannot contact the main DB server, it will elect to start talking to the standby, thus, philisophically (sp?) the standby is now the main server.
Hope I haven't confused anyone here with my rambling?
The problem is my hunch (not being a DB guru) is that replication is NOT what I am looking for - I *think* replication does sync data and schema (correct me if i'm wrong) but not immediately - it is scheduled? Yes?
I am looking more for synchronisation - but it has to be 'on the fly' - not every 15 minutes or 8 hours etc...
If SQL server cannot do it, then it's not a major problem, since the DB access layers of the applications themselves can simply write their data to two DB's, and queue writes in a buffer if one of the partners is offline, such that they will be written to the partner when it comes online - however, I'm all for an easy life, and if the boys at Microsoft have already settled this issue, then i'm all for that!
Your advice would be appreciated.
Regards
Mark Wills
Hi
I am using a sql server database for storing gps data from a remote location. The average data stored in the db is around 2 GB/day. For security reasons, my application is working on another server which has same db. I need to update data in the second database within an interval of 2 seconds. The user entry in the application server has to be synchronised with first server also. Is replication is possible in such a small interval?. Anybody have any suggestion?
Thanks in advance
Kuttan
We have a SQL Server 2005 database supporting our main ecommerce site. It is hosted remotely by our ISP. We currently maintain a local copy of this database by running daily stored procedures to keep the local copy up to date. However we'd like to explore the use of replication over HTTPS as an alternative means of keeping the local copy in sync with the ISP database.
Could anyone comment on the technical feasibility of doing this, given that transaction throughput on the ISP server can be several hundred hits per hour? Is web-based synchronisation likely to suffer from poor performance, or to adversely affect users of our ecommerce site?
Hi,I'm working with two databases on to physicaly separated servers: #1is on a local machine en I can only connect to #2 via an ADSLconnection.I need to syncrhonise the data. This works fine via the wizard fromthe Enterprise Manager. But I want to get this done via a script formthe Query Analyzer that I can run whenever I want to. Something like:insert into srv1.database.dbo.table1select * from srv2.database.dbo.table1When I do this I get an error about "linked servers". That surprisesme, because I have no linked servers configured and yet the wizardworks fine?Can anyone tell me how to accomplish this?tavJan Willems
View 1 Replies View Related hi,
i have done Web Synchronisation Using RMO , where i have an remote server at a remote place, where the Virtual Directory is Configured With SSL, for testing purpose if i access from the Client Computer entering http://72.17.246.214/SyncAbita/replisapi.dll?diag " in the address of IE giving an errormessage "Unable to Reach Remote Host", if i remove SSL on the Server , i am able to access "SQL Websync diagnostic information" Page from the Client Machine, is it not possible to get perform Web Synchronisation With SSL, then i have inStalled 7 days Trial Version SSL on the Sever. Can any body help me out on this Issue
How can i synchronise (wireless) data from desktop to ppc?
View 1 Replies View RelatedHi..
I hope this is the right forum for my question. I am very new in Databases. I have such a problem:
There is a Database on SQL-Server in a country X. This database has tables like
Table 1,Table 2 ,.....Table 10;
I develope an Application with Visual C#.NET 2.0. I use a local SQLExpress database, which has tables like
Table1,Table 2..Table 6,Table A,Table B.
As you see Table 1-Table 6 are same in both databases (not the whole database ). And these tables must always have the same information (Server database changes->local database must read the changes). Because of that there must be a Synchronisation between them.
How can I solve this Problem? Do I need to write code or is there any simple solution?
Thank you.
Hi
I am using a sql server database for storing gps data from a remote location. The average data stored in the db is around 2 GB/day. For security reasons, my application is working on another server which has same db. I need to update data in the second database within an interval of 2 seconds. The user entry in the application server has to be synchronised with first server also. Is replication is possible in such a small interval?. Anybody have any suggestion?
Thanks in advance
Kuttan
Im looking for some recommendations on tools I can use to keeo my dev/test/prod databases in synch. Im tired of doing this manually. I use SQLSever 99% of the time but if there is a tool that can manage other database also I would be interested in hearing about it also.
View 1 Replies View RelatedHello,
Can anyone guide me. which is the best method for real time synchronisation of my production server. Is it Transactional Replication or Stand By Server?
Thanks In Advance
Sejal
Yes, I know synchronisation to alternate partners is deprecated in SQL2005 but....
In SQL2000 there is a Sync Partners tab in the publication properties dialog that allows you tick a checkbox for each co-publisher to be enabled as an alternate synchronisation partner. What is the equivalent in SQL2005?
I've set up replication in SQL2000 following these instructions http://support.microsoft.com/?kbid=321176 and it works. Now I'm trying to do the same thing in SQL2005 but I can't find a substitute for steps 10 & 11 in the section "Set Up the Alternate Synchronisation Partner". What's the answer?
Thanks in advance.
HI
We are using HTTPS anonymous merge subscriptions....
Sometimes when trying to synchonise, we will get the following error messages returned to the subscriber....
The upload message to be sent to Publisher '**thewebserver**' is being generated
The merge process is using Exchange ID '0F65CFCB-AF17-47DC-8D98-493A44C243E0' for this web synchronization session.
The Merge Agent could not connect to the URL 'https://**thewebserver**/client/replisapi.dll' during Web synchronization. Please verify that the URL, Internet login credentials and proxy server settings are correct and that the Web server is reachable.
The Merge Agent could not connect to the URL 'https://**thewebserver**/client/replisapi.dll' during Web synchronization. Please verify that the URL, Internet login credentials and proxy server settings are correct and that the Web server is reachable.
The Merge Agent received the following error status and message from the Internet Information Services (IIS) server during Web synchronization: [401 :'Unauthorized']. When troubleshooting, ensure that the Web synchronization settings for the subscription are correct, and increase the internet timeout setting at the Subscriber and the connection timeout at the Web server.
If I then go to a web brower, put in the HTTPS address, it brings up the logon dialog - I put in the admin username and password to confirm the connection and that's fine.
We try and synchronise again, and this time it works - it's as though I have 'woken' it up again and it's happy to play.
Is increasing the timeouts as suggested by the error message the way to go ? If so, where does one set the 'internet timeout setting at the subscriber', and the 'connection timeout at the webserver' ?
thanks
hi ,
i am creating a service broker application between two different instance.when i am initiating a dialog from the source my message remain in the sys.transmission_queue.but its transmission_status column is empty.
i attached the profiler with both source and target by including all the service broker event.
in my source profiler i am getting the error like -- Connection attempt failed with error: '10061(No connection could be made because the target machine actively refused it.)'. with event Broker:connection
and in the target profiler error is --This message could not be delivered because the security context could not be retrieved. with event Broker:Message Undelivarible.
i have checked my port also using telnet with remotely and localy both working fine. i am using port no. 4001
and i have mentioned the port no. in the address of the route.
bt still getiing the error.
please help!!!!!!!!!!!
I am attempting to write a Windows service that watches a database for uploaded files to import. When a new file is found, the corresponding SSIS package is run from the file system with variables passed through. I started development as a Windows app and copied the functionality to a service.
The app runs fine. The service does not. I get a "Failure" each time a package is executed. Everything is identical behind the scenes with the obvious exceptions that OnStart and OnStop handlers are buttons in the app. I added a script task at the beginning of one of the SSIS packages to notify me that it is even running at all. It doesn't even hit that initial task.
Again, the app will run all packages just fine. The data is imported and the results return as "Success."
The following is the code executing the package. Any help is appreciated. I've been banging my head on this one for a few days now. (Is there a tag to format a code sample?)
Dim pkgLocation As String
Dim pkg As New Package
Dim app As New Application
Dim pkgResults As DTSExecResult
pkgLocation = sPackageFolder & PackageName & ".dtsx"
pkg = app.LoadPackage(pkgLocation, Nothing)
Dim vars As Variables = pkg.Variables
vars("ImportId").Value = ImportId
vars("ProductionServer").Value = ProductionServer
vars("ProductionDatabase").Value = ProductionDatabase
vars("SourceFileName").Value = FileName
vars("SourceFilePath").Value = FilePath
pkgResults = pkg.Execute()
Hi,
I downloaded orcas and created an application which also has sql server synchronisation, now if i wish to run it on another m/c, where can i get the runtime for 3.5, I searched but could not find it.
Thanks
arnab
If my application updates a SQL Express database at the same time as my service is performing synchronisation of the same database via RMO, intermittently some of the rows updated will not be included the next time synchronisation is performed.
Does anyone know what's happening and what I can do about it?
Hi
We have about 70 clients, each with their own databases synching to a copy of their database on a remote webserver. They synchronise using a Windows Service which we wrote using RMO.
For completeness, our setup is as follows:
subscription.CreateSyncAgentByDefault = False -- I wrote a windows service to synchronise
subscription.UseWebSynchronization = True
subscription.InternetSecurityMode = AuthenticationMethod.BasicAuthentication
subscription.SubscriberType = MergeSubscriberType.Anonymous
Sometimes, one of our clients synchronisation goes up the spout - it might take hours to synchronise - despite their internet connection being fine. And once this starts to happen, nothing will fix it. We've restarted their server, rebooted their router etc etc.
Well, the only way of fixing it is to recreate the publication, copy the backup, reinitialise and start again, which costs us a days work and inconveniences the client greatly.
What would be the likely trigger for this. How can we stop this happening again.
If it helps we could create a trace to help resolve this.....
Regards
Bruce
Hi all,
I am in the position where I have to transfer data from an old database
schema to a new database schema. During the transfer process alot of
logic has to be performed so that the old data gets inserted into the
new tables and are efficiently done so that all foreign keys are
remained and newly created keys (as the new schema is Normalised alot
more) are correct.
Is it best if I perform all this logic in a Stored Procedure or in C# code (where the queries will also be run)?
Tryst