Replication And Direct Updating In SQL 2000
May 3, 2006
I have taken over the support over a database in sql 2000 that has 10+ remote users that synchronise each day. However it also has 30+ users who are directly updating the data in the live database on the server.
One of these users is entering data directly upon the database on the server but the new rows are being placed in the conflict table somehow!!
Does anybody have any ideas about how this could be happening ?
Is it ok to have users directly updating on the server and users synchronising ?
I would appreciate any help!!
Thanks.
View 1 Replies
ADVERTISEMENT
Aug 10, 2007
Hello Everyone,
I'm trying to connect to Desktop SQL Server 2000 from Windows mobile PC Emulator (VS 2005). I need a direct connection using connection string to SQL Server 2000 through local wireless network without IIS.
Bellow is the code that I use. After executing this code I get an error on line Conn.Open(). Error says SQL Server does not exist or access denied.
SQL is un and running, and I can log in using SA username from the desktop. Even if I chance IP for another SQL server in my connection string I still get the same error. There is no firewall of any kind running.
Dim connectionSTR As String = "Persist Security Info=False;Integrated Security=False;Server=192.168.0.202,1433;initial catalog=MyDB;user id=sa;password=;"
Dim Conn As SqlConnection
Conn = New SqlConnection(connectionSTR)
Conn.Open()
If Conn.State = ConnectionState.Open Then
MessageBox.Show("Open")
End If
About my environment: SQL Server 2000 is running on Desktop PC with Windows XP SP2. Application which I need to connect to SQL Server is in Visual Studio 2005. I execute the application in Windows Mobile PC Emulator and try to connect to SQL Server from emulator.
Your advice and help is very appreciated
Thank you
Ika
View 3 Replies
View Related
Jun 9, 2004
I am really lost understanding using SQL Server 2000 with ASP.net Webb apps. If you are dong windows apps, the form builder wizard will either build you a page with a grid for displaying multiple records, or a single record page with text boxes.
All well and good.
With ASP.net web apps, though, you only get the option for making the gred/multiple record page.
So I try to make a page with textboxes to use to update my table in Sequel Server. I do my data binding, and fill my adapter, and viola, the data from my first row appears in the text boxes.
Here is the problem. I have a "Next" button and a "Previous" button that I want to use to move forward or backward through the rows in the table. What code do I put behind the buttons?
I created a windows app and used the dataform wizard to make a single record form. The code it puts behind the "Next" button is
Private Sub btnNavNext_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnNavNext.Click
Me.BindingContext(objDS_SclRcd, "IMA_School").Position = (Me.BindingContext(objDS_SclRcd, "IMA_School").Position + 1)
Me.objDS_SclRcd_PositionChanged()
End Sub
I tried to incorate the logic into my ASP web page, but can't figure out how to do it.
It seems like it ought to be simple, like position = position + position, but I can't figure it out.
Also, after I enter data changes, how do I save the updated data from the screen to the data set before moving on to the last record?
Last, how do I tell the dataset to go back and update the connextion server?
I really want to be able to update SQL data from a remote client usuing ASP web page, but none of my manual address how to do it.
Any help would be great.
Thanks
Jim
View 4 Replies
View Related
Jan 31, 2006
Greeetings!
I am newbie in SQL, asking help from you people.
We are using Microsoft SQL Server 2000 Service Pack 2 running on Windows 2000. We are planning to update service pack from to 2 to SP4...Is it okay? What are the requirements? Will there be side effects in our systems?
Hope to hear from you soon.
Regards,
Len
View 1 Replies
View Related
Dec 3, 2005
DateTime Updating Problem in sql?
below is the query that is a part of a sproc .All table
fields and values are ok. When the mentioned Sproc. is
called in query analyzer it executes well and update all
fields of the table used in UPDATE statement
.
UPDATE Emp_Schedule
SET IOS = 0, HoursWorked = @WorkTime, COA =getdate()
WHERE (Emp_Id = @EmpID) AND (S_Id = @ShiftId) AND (DT =@DayTime)
PROBLEM arises when i call this procedure from C# code all
fields are updated Except the COA(DateTime) field.Whats the
problem. SProc runs well both in debug mode and normal mode
in query analyzer and do updates the values. But when i
call in C# only datetime field COA is not Updated? Plz solve this.
THNX IN Advance.
View 6 Replies
View Related
Sep 30, 2004
I need to update one row in a SQL Server 6.5 DB from a row in SQL 2000 server DB. What would be the best way to do this?
I have my 2000 server defined as a Remote Server in 6.5, however I get the error message:
contains more than the maximum number of prefixes. The maximum is 2.
View 9 Replies
View Related
Oct 4, 2004
I would like to update a varchar field with an update statement that appends information to what is currently stored in the field, for example in the Statement field I may currently have a name (Mark) and I want to add a unique identifier to the end of the name so that it may look like, Markq1572, is there a way to do this in an update statement?
View 1 Replies
View Related
Jul 20, 2005
Hi All,I'm a relatively newbie to SQL Server 2000, having come from a MySQLbackground.I'm creating my first Trigger statement on a table, and I'd like toknow how I go about performing an update on the row that was changedwhen the trigger was fired.To explain, I have 2 columns, one which contains a member number, theother which contains a flag that is supposed to indicate whether ornot the member number in the row has changed since the last time thetable was processed for updates.So, whenever the value in the member number field [memnum] is updated,I want to set the flag [igproc] to true.The best I've been able to do is:CREATE TRIGGER [updateignoreprocflag] ON [dbo].[dd_testtable]FOR UPDATEASdeclare @key as intIF UPDATE (memnum)select @key = recid from insertedUPDATE dd_testtable set igproc=1 where recid=@keyThis seems to work, but I'd like to know if there's a better way ofretrieving the recid value of the changed row to pass to the UPDATEstatement? Also, I read somewhere in passing that using SELECTstatements and variable assignments within triggers can cause problemswhen called from other applications; in this case it will either be aweb site using ASP.or an application developed in FOXPRO. I can't findwhere I read this originally, so it's entirely possible I imagined itor misunderstood it, but I'd very much appreciate it if someone couldconfirm whether or not this is the case?Many, many thanks in advance!Much warmth,Murray
View 2 Replies
View Related
Jul 20, 2005
Hi allI just ranUPDATE dbo.tbl_forecastedSET update_ref = 0but it only updated the first 10000 records. I'm wondering if anyone cantell me why this is, and can I get around it.I have looked on google and found a few references, but nothing in too muchdetailsthanks in advanceAndy
View 2 Replies
View Related
Jun 27, 2006
i went through the documentation but i was not clear on following, here is the scenario :-
a Central server is having SQL Server 2000
3 Remote Locations :- Each having 4-5 no of computers, connected on a Lan, and on one of the machines MSDE 2000 will be running.
My Questions are :-
1. Can remote locations, update data locally and send changes (say in every one hour) to central server. If yes, then how ??
2. Same way they can receive updates from Central Server on whatever was updated on Centra Server or on the 3 remote locations. If yes, then How ??
any help will be highly appreciable.
View 8 Replies
View Related
Apr 12, 2006
Hello.I've read many topics about this problem but i couldn't figure it out.I use form where user must insert 2 dates using texboxes.-One is required and other is optional.Sql 2000 is inserting either '20061105' or '2006.11.05' on insert update but select query returns 05.11.2006 on my report. Question 1.How do I insert or update dates from my form where date is entered dd.mm.yyyy to sql 2000 table?question 2. What to do if user left optional texbox date empty.I'm using SP and function with arguments (byval texbox1.text as date, byval texbox2.text as date)and parameters @date1, sqldbtype date =texbox1.text
View 2 Replies
View Related
Nov 17, 2006
Hi,
I am trying to setup Trans Replication with updating subscriber on sql2000. One column on few tables got data with single quote (').
How do I handle in this case? Did any one come across such case?
Can I Change default QUOTED IDENTIFIER from ' (single quote) to something else (@@@) on SQL2000?
If yes, how to do?
Thanks
mka
View 1 Replies
View Related
Aug 27, 2007
hi guys help please. I have a column name Quantity of type int in my table table1 and it has an intial value say 5. My question is, is it posible to update that column say, i want to add 10 from its initial value for it to have a value of 15, without querying it first from my application and store it to a varibale and add 10 to it for it to have 15 and execute update to set the initial to new value (15).
View 6 Replies
View Related
Dec 4, 2007
I did a little bit of looking in the forums for something like this, but I wasn't able to find anything. In essence, I am looking to create a web form in ASP.NET which will emulate the SQL Server Query Analyzer Tool... eventually what I'd like to see:
- A dropdown of different connection strings, to connect to different databases
-A multi-line textbox where a user could type in a query (be it a SELECT, CREATE, UPDATE, or multiple queries at once)
-A gridview object for results
-A multiline textbox to contain server output ("the command completed successfully", "xxx rows returned", "syntax at line 3 not recognized", etc)
I can do the first 3 without any difficulty, but I have absolutely no idea where to start with the server output. Anyone have any ideas? It does not need to be secure, as the only databases they'll have access to will be "test" databases and the pages will not be publicly hosted (LAN only)
View 2 Replies
View Related
Jan 3, 2008
Hi,
There are certian "routine things" that need to be queried in my database. Currently we can either do:
1) SELECT * FROM myTable WHERE id = x
OR
2) We can use a stored procedure to do the above SQL for us...That way, if the table changes, or we make changes to the database etc. The calling code will remain unchanged and we just have to change the stored procedure code instead of anywhere that calls it.
What would you say are any disadvantages of doing the 2nd approach?
Thanks!
View 14 Replies
View Related
Apr 10, 2007
I am using SQL RS 2005 with VS2005 in Windows Application. I have placed Report Viewer on Windows From and then report is attached with it. Now report previews well in BIDS as well as in VS2005. Moreover it exports perfectly to pdf and excel but when I click print button on report viewer and give direct print to printer, font size, textbox, rectangle and every other thing become large, like instead of 10 font size, it prints 12, instead of 240 width of rectangle, it prints 280 or so.
There must be some solution to this thing. Some one help
View 3 Replies
View Related
May 12, 2008
hi all,
I am using SQL reporting services 2005, i like to have a parameter as optional, is there is any diresct way to set a parameter as optional without setting through the default value.
View 6 Replies
View Related
Jul 24, 2007
Hi
I have found article by Jamie T. (www.sqlis.com/26.aspx) where he explains how to use direct configuration.
I followed every step.
Before building project I made sure that CreateDeploymentUtility = True.
Once project was built I have copied files from Deployment folder to other PC to c:PackageConfiguration (I have 3 files there: environment.dtsconfig, PersonAge.dtsx and jamie.SSISDeploymentManifest)
dtsConfig file is;
<?xml version="1.0" ?>
- <DTSConfiguration>
- <DTSConfigurationHeading>
<DTSConfigurationFileInfo GeneratedBy="me" GeneratedFromPackageName="PersonAge" GeneratedFromPackageID="{2612ABDA-E4FB-43DF-A1C1-44066426A798}" GeneratedDate="7/24/2007 9:46:41 AM" />
</DTSConfigurationHeading>
- <Configuration ConfiguredType="Property" Path="Package.Connections[Destination].Properties[InitialCatalog]" ValueType="String">
<ConfiguredValue>DataStore</ConfiguredValue>
</Configuration>
- <Configuration ConfiguredType="Property" Path="Package.Connections[Destination].Properties[ServerName]" ValueType="String">
<ConfiguredValue>MyPCsql2k5local</ConfiguredValue>
</Configuration>
</DTSConfiguration>
However, I am doing something wrong as I was not able to deploy this to another PC.
I double click Manifest file and in Configuration Package - Property there are two entries: InitailCatalog and ServerName. Initial Catalog has Value=DataStore and ServerName = MyPCsql2k5local. I change ServerName to be AlexPcSQL2k5Local.
I have Validate Package after instalation so I get error saying that connection to Destination failed.
If I go to File System to installed package and say Run, package will run OK if I change all ConnectionManagers to point to AlexPcSQL2k5Local
What is it that I am doing wrong?
View 7 Replies
View Related
Jul 12, 2007
Hi There,
I have recently upgraded to report Server 2005. I used to have a webpage that loaded a number of reports into different frames to give real time statistics for an IT Service Desk.
In the new version if try and link directly to the report (By right clicking a report and taking the link) the report loads with out any of the toolbars etc at the top as i need it, however it does not refresh and seem to be cached data.
Has anyone got any ideas how to resolve this problem, in short all I need is a way to directly view the report losing all the toolbars etc on the top and just displaying the data.
This has been driving me mad so if anyone could help i would be really grateful!
Many thanks
Gerard
View 1 Replies
View Related
Aug 3, 2004
Hi
I have a SQL 2000 table in which pictures are stored as an Image column. I want to display then onto a c# aspx webpage without storing them to disk.
What is the best way to read and display the pictures?
In classic ASP I used to do this:
Response.ContentType = "image/jpeg"
Response.BinaryWrite rs.fields("ThisImage")
but I can't get this to work in c#.
View 2 Replies
View Related
Oct 8, 2007
ok i need to know the difference between inner outer , left , right joins ....
anyone know any good tutorials ?
View 3 Replies
View Related
Dec 11, 2007
I have a table from 1.5 million records.
A valued-table function with the parameters used in a SELECT.
1) If I use:
DECLARE @Par1 int
SET @Par1 = 28338;
SELECT Count (*) FROM MyTableValuedFunction (@Par1)
Running time: 2.3 min.
2) If instead:
SELECT Count (*) FROM MyTableValuedFunction (28338)
Running time: 0.02 sec.
Why?
The two solutions are not identical?
View 5 Replies
View Related
Sep 29, 2006
If your XML configuration files will be in the same location on your Development, UAT and PROD servers, is there any merit to making your configurations indirect?
I am modifying the connection string with the XML. My strategy is to set up an XML configuration for each database that we have. The Dev XML config will point to Development connection, UAT to UAT etc..
My thought is that by using the direct configuration it will eliminate the need for environment variables and also allow me to add configs without having to reboot the servers, which you would need to do in order to get server to recongize the EV.
Thanks
View 5 Replies
View Related
Aug 29, 2007
Is there a way to use trusted connections in ASP.NET and WinForm applications yet prevent users from accessing databases directly (outside of applications) ? I know the use of trusted connections are recommended for several reasons however I have a lot of applications that I need to prevent users from accessing databases directly outside of the applications themselves.
View 5 Replies
View Related
Dec 8, 2007
Hello. Does anybody knows if the are shortcuts to differrent menu items in Sql 2005 Management Studio ?For example i will to use the "Execute " button without need to use the mouse, as this case as of others.Any knows where can i find a map or a page info with the shortcuts of SQL2005 Management Studio ? Thanks
View 1 Replies
View Related
May 17, 2006
I'm just starting out here.
I created a simple formview connected to a local file copy of the database by adding the database into the project. It worked fine.
However, I noticed that this copy of the database was not synch'ing with the database with the same name in SQL express. So I created a new connections string to access the SQL database directly out of SQL express. Its just a simple Select * from column. However, this gives an error. Why?
Server Error in '/NETCatMgr' Application.
The data types ntext and nvarchar are incompatible in the equal to operator.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: The data types ntext and nvarchar are incompatible in the equal to operator.
This is the connection string
<add name="CatalogMgrConnectionString" connectionString="Data Source=mymachinesqlexpress;Initial Catalog=CatalogSQL;Integrated Security=True"
providerName="System.Data.SqlClient" />
Doesn't make sense. How can the formview work fine with the SQL integrated into the project but not working with a connection string to the SQL Express proper???
View 2 Replies
View Related
Aug 17, 2001
In SQL7 Query Analyzer we want the results of a SELECT statement not to be displayed on screen but written to a text file.
We assume that in the tons of sp_ and SET statements there should exist
one where output file can be defined.
Greetings from Mannheim, Germany
Ricardo
View 1 Replies
View Related
Jul 20, 2007
In 2000 there was a server level setting you could change in EM, to allow direct modifications to systems catalogs.
in 2005 I would like to update some sids in sysusers tables, do I also need to find and set this option first
View 6 Replies
View Related
Oct 21, 2015
Is there a way to setup a trace to show only direct TSQL statements triggered on my server? note I don't want to capture Procedure calls or the statements called within the procs.
Actually many people are firing direct SQL statements on server. And some are coming from entity framework as well. I just want to capture those.
View 1 Replies
View Related
Jul 23, 2005
From what I've read in the docs, ado.net currently supports opening sqlserver ce tables in table-direct mode and performing Seek operations on them(using SqlCeDataReader), but not on the full-blown sql server. Is this(will this be) still true with ado.net 2.0 & sql server 2005?
View 11 Replies
View Related
Sep 23, 2006
hi,
There is no direct equivalent to Oracle's rownum or row id in SQL Server
there is any possiblity are alternate thing is exist then please reply
regards
santosh
View 10 Replies
View Related
Nov 16, 2006
Hello,
I need some clarification. I am trying to utilize the XML Direct Configuration in my SSIS packages to utilize database connections in the package. I am wanting to utilize this the same way you could use UDLs in the SQL Server 2000 DTS packages.
Currently, I am creating the dtsConfig file and saving it to my desktop. I then modify it with notepad and add the following configuration where it looks like this:
<DTSConfiguration>
<Configuration ConfiguredType="Property" Path="Package.Connections[ConnectionName].Properties[ConnectionString]" ValueType="String">
<ConfiguredValue>Data Source=[ServerName];Initial Catalog=[DBName];Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;</ConfiguredValue>
</Configuration>
</DTSConfiguration>
Once this is created, I am trying to "re-use" this in SSIS packages created moving forward, where they all point to this configuration for the same database connection.
What I don't understand is when "Enabling Package Configuration" and then pointing to this dtsConfig file doesn't create a connection in "Connection Manager" NOR does it provide a way to create a blank connection and point to this configuration.
I feel like I am missing something thats so "great" about XML configuration files. Any help would be appreciated.
Thanks,
Daniel Lackey
MCSD
View 3 Replies
View Related
May 16, 2007
Is it possible to to render direct to PDF when viewing the report url?
View 7 Replies
View Related
