Automatic Data Update From SERVER To All CLIENTS Connected ???

Jul 20, 2005

Hi,
i have a problem about the CLIENT-SERVER architecture procedure.
Well , i have an application in VB with ADO connection to a table in a
database on a SQLSERVER 7.0 .
Is possible to do that when a client updates a data in a field of my table ,
the SERVER communicates to all clients connected to my table that this data
are updated , without the client do anything , for example without a
client-timer to control the data in the server ???
thanks

View 2 Replies


ADVERTISEMENT

Automatic Update In Sql Server

Nov 5, 2007

I hope that a someone has answer for me.
I want create a new database in sql server and import the database tables of Dynamics CRM and of other application (Accountview) import so that I can make a link of these two databases. My question is it possible that this database update or refresh automatic and how?
The database of Dynamics CRM manages by sql server. But the database of accountview is not manages by sql server. I make a link with odbc driver for Accountview database.
Can someone help me please?

View 1 Replies View Related

Need Advice: One SQL Server 2000, One Web App, Multiple Clients With Their Own Data

Feb 29, 2008

Hello,I'm looking into offering a custom data driven web app that I wrote for an organization that I'm apart of to other similar organizations. I would be hosting the data and web application code on my dedicated server. This application is using the membership api supplied in .NET 2.0 and also has my own custom data tables within it.My question is what would be the best way to add clients to this? Should I simply create a new database for each new client like so: ACME_Database, ABC_Database, AAA_Database etc. Or should I add some sort of client "Tag" (tag meaning column within each datatable) to these databases and then update my SQL queries to process them accordingly. I imagine I could do both but I guess I need some advice from people that already had experiance with providing this kind of service. Thanks!Jason 

View 4 Replies View Related

Slow SQL Server Data Transfers When Internet Connected

Mar 18, 2008

We have an information retrieval application in which there is a single connection to a database followed by multiple table open, read, and close commands. Response time is consistantly less than 1 second on a LAN.
When Internet connected (not VPN), the first table read is typically fast, but the response time becomes slower and slower after multiple table open, read, and close commands. There seems to be a considerable amount of handshaking based on monitoring of the router's status lights.

View 7 Replies View Related

Can Not Update Or Delete Records When Connected With ODBC...

Mar 9, 2008



...not sure why, but when I create a new table in my database and connect to it using ODBC I can not update, or delete records in the table. However, I can update and delete records in all the other existing tables in the database, it's only when I create a new table that I can not. Wondering what settings I have to apply to the new table to allow updates and deletes from ODBC connections. I've tried messing with the permissions for the table, but any changes I make there do not seem to have any effect.

Thanks in advance.

TH

View 1 Replies View Related

Can Not Update Or Delete Records When Connected With ODBC...

Mar 9, 2008



...not sure why, but when I create a new table in my database and connect to it using ODBC I can not update, or delete records in the table. However, I can update and delete records in all the other existing tables in the database, it's only when I create a new table that I can not. Wondering what settings I have to apply to the new table to allow updates and deletes from ODBC connections. I've tried messing with the permissions for the table, but any changes I make there do not seem to have any effect.

Thanks in advance.

TH

View 3 Replies View Related

Automatic Update

Apr 22, 2008

hi,

i have:

create table tbl_order
(
id int
,price float
,quantity int
,product nvarchar(50)
,date_of_order smalldatetime
,date_of_change smalldatetime
)

insert into tbl_order (id, price, quantity, product, date_of_order) values (1, 23.21, 2, 'A+B', getdate())
insert into tbl_order (id, price, quantity, product, date_of_order) values (2, 22.21, 2, 'A+B+C', getdate())


and i want to make automatic update:
-if new order is made, i want to update field date_of_change with getdate().

i want to put it in a job with some trigger or something that will recognize instant new insert.

thank you in advance,

View 4 Replies View Related

Automatic Update

Nov 5, 2007


I hope that a someone has answer for me.
I want create a new database in sql server and import the database tables of Dynamics CRM and of other application (Accountview) import so that I can make a link of these two databases. My question is it possible that this database update or refresh automatic and how?
The database of Dynamics CRM manages by sql server. But the database of accountview is not manages by sql server. I make a link with odbc driver for Accountview database.
Can someone help me please?

View 4 Replies View Related

How To: Scheduled Automatic Update?

Jun 6, 2007

Hi I'm currently running a complex MSSQL query (using SqlDataSource server control) everytime a web page is loaded to display a single value.  How ever, this data only needs to be updated every 24 hours, therefor remains the same all day.  I'm trying to figure out a way where by the MSSQL query runs once a day and the value is inserted directly somehow into my aspx page, or, failing that is inserted into an MSSQL database.I also have full root access to my server.thanks  

View 4 Replies View Related

Automatic SQL Db Update At Set Time?

Jul 28, 2004

I would like to limit the number of pages a user can view on my website each day. The users logs in and I can count the number of pages viewd in a field but i want to know how i can set the page count field to reset to 0 at the end of the day (ie midnight). Is it possible to do this? and if so how? Thanks.

View 3 Replies View Related

Automatic Update Statistics

Jan 11, 2001

On a SQL 7 sp 2 server, I have a database with about about 77,000 records, with automatic update statistics on inserting 1000 records took 43 minutes. With automatic update off, it took 23 minutes to insert the same 1000 records. On the same machine, I inserted 1000 records into 2 other databases with the same database structure and automatic update statistics on. On the second database, there are about 174000 records and it took 35 minutes to insert 1000 records. On the third database, there are about 93000 records and it took 19 minutes to insert 1000 records.

Why is the time so high on the first database?

What can be done to fix the problem?

Thank you.

View 8 Replies View Related

Automatic Foreign Key Update

Apr 13, 1999

Hello to everyone:

Aside from using a trigger to automatically update a Foreign key,
is there a way you can automatically update a Foreign key when you
update its corresponding Primary key using the select statement?

Grigio

View 1 Replies View Related

Automatic Statistics Update

Mar 30, 2006

Hi. I have automatic statistic update turned on for all my databases. Isthis an overhead I can do without? Could I update them overnight when thedatabase is hardly in use?Thanks--Chris Weston

View 1 Replies View Related

Disabled The Automatic Round Of SQL SERVER 2000 On The Float Data Type

Jun 19, 2007

Hello,

I have a problem with the round of SQL Server 2K on the float data type.

In my application I do a SQL request for find a row in a table of SQL Server 2K.

This is the request :

SELECT DISTINCT N_ROW_ID FROM COMM WHERE N_ARTICLE_ID=79510 AND N_DATASOURCE_ID=1 AND N_SOURCE_ID=-102 AND N_PROVIDER_ID=-100
AND N_LEAD_TIME IS NULL AND N_UNIT_PRICE = 329.78 AND N_UNIT_PRICE_CURRENCY_ID=1



N_UNIT_PRICE is a float data type.

In the line need, the field N_UNIT_PRICE has 329.78 but with the round of SQL Server 2K I have 329.779999999999997.

So I never find the row



Do you have a solution for comparate a float flied with SQL Server round and a float send in a request as my 329.78?

I can't transform the column in decimal or numeric data type.

Is it possible to Disable the function?



Regards

View 2 Replies View Related

Pushing Data To Clients

Jun 8, 2007

I am someting of a newbie to SQL Server, but I am an experienced C++/C# programmer.

I have a SQL Server 2005 DB to which are connected 50 or so clients.
The clients are running my software, written in C# and connected to the server by an OleDBConnection.
These connections are long-lived; in some cases they remain for days or more.
Now and again, one of the clients causes a change to the DB (not structural, just normal adds, update and deletes).
But most of the time the clients are just viewing data in the DB.

What I need to happen is that when any item of information changes, the display of that information on any of the clients which are viewing it must be updated quickly.
It doesn't have to be instant, but a delay or more than, say, 5 seconds is unacceptable.

It is like a share-dealing or foreign exchange system (although that is not what it is) where the traders' screens have to have up-to-date information at all times.
Note that the information received by the clients does not have to describe the change in detail, just a hint to the client as to what change has happened so that the client can refresh its views.

I can think of a way of doing this but it is really nasty.
The hints would be recorded in a time-stamped table. Each client would poll every couple of seconds by calling a SP, which would return the hints which have been added since the last time that client polled.
But polling is horrible and I am sure that there must be a better way.

A route that looks promising is InfoMessages. But, reading around the subject, it looks like these cannot be unsolicited and spontaneous; they only arrive on a Connection as a result of some action on that Connection.

I may have missed something, or maybe InfoMessages are not the way to go.
Can anyone offer me any advice, please

TIA,
Paul

View 3 Replies View Related

Access Issue After Automatic Update

Jan 1, 2007

I finally added WinXP SP2 to my system yesterday (along with a lot of other security updates/patches through Automatic Updates) and now my backups and data exports are failing. Further, when I open my "Enterprise Manager" and try to export data ("All Tasks-Export-...") using the Import/Export Wizard, it won't let me select the "Export From" database.

View 1 Replies View Related

Select Data From Table In One Database Server While Connected To Another Database Server.

Dec 18, 2007



Hi,


Is there a way in SQL Server 2005 to use a select statement to fetch data from a table in another Server while running the query in one Server.

Like using a database Server Link in oracle...


Thanks
Pramod

View 8 Replies View Related

What Must Have Clients To Work With Mssql Data

Mar 10, 2004

reading help i know that client for working with mssql remote db must have installed oledbprovider for XXX

i always use ole db provider for ODBC
, this ole db provider is installed with mssql, but what exactly must to have the clients which are not familiar with this ole bd provider, what files ?

View 2 Replies View Related

Conecting Over The Internet For Getting Data From Clients.

Jul 23, 2005

I want to connect over the internet to get data from clients.What wouldbe the easiest method and the most stable methos to do it1.Use a Point to Point prtotcol from the client pc and then upload thedata to our sql server2.Export the data from the clint pc in XML format and then Enter it inour computer.3.Have all clienst ftp the data in a dirctory and then upload the xmlfiles from the directory?Thanking you in anticipation.Would love it if we could discuss anddistribute our thoughts on this.Ajay

View 1 Replies View Related

T-SQL (SS2K8) :: Query To Display All Data Connected To ID In One Row

Oct 23, 2014

I have a table that I am trying to query to display all data connected to a id in one row. What is the best way to achieve this?

Something like this:

ID| CRS1 | CRS2 | CRS3| CRS4 ....
1 | A101 | A102 | A103 | A104 ....

CREATE TABLE Class
(
id int,
yr int,
trm varchar(2),
crs varchar(30)

[Code] .....

View 3 Replies View Related

SQL Query Question : How To Add Data To Two Tables Connected By Third Junction-table.

May 1, 2008


Hello specialists.

Maybe this is the wrong formum but I've got a question for which you probably have the answer, i hope.


Situation
------------
John is member of Group_A and Group_B
Bill is member of Group_B and Group_C
Allison is member of Group_A and Group_E

How can I create a query to input Allisons username into table 1 and groupmembership into table 2. Also updating the relationship within junction-table3 must be done automaticaly. I want to avoid duplicate records.
The final situation I want is given in red text.

The relationships between the tables are as follows
-------------------------------------------------------------
Table1 (PK)ID-Userinfo [ONE] <------------> [MANY] Table3 ID-Userinfo
Table3 (PK)ID-GroupInfo [MANY] <------------> [ONE] Table2 (PK)ID-GroupInfo

Table1: UserInfo
------------------------------
(PK)ID-Userinfo UserName
1 John
2 Bill
3 Allison

Table2: GroupInfo
------------------------------
(PK)ID-GroupInfo GroupName
1 Group_A
2 Group_B
3 Group_C

4 Group_E

Table3: MemberOf
------------------------------
(PK)ID-MemberOf ID-UserInfo ID-GroupInfo
1 1 1
2 1 2
3 2 2
4 2 3
5 3 1
6 3 4


I hope you can help me cracking this nut.

Thx in advance. Greetings Fred

View 7 Replies View Related

Cannot Get Connected To My SQL Server

Mar 23, 1999

When I try to connect to my SQL server I get the following error.

Microsoft SQL Enterprise Manager
A connection could not be established to MLM1-[SQL Server] Cant allocate space for object 'Syslogs' in database 'tempdb' because the 'logsegment' segment is full. If you ran space in syslogs dump the transaction log. Otherwise use ALTER DATABASE or sp_extendsegment to increase the size of the segment.

Ok, I am not up on SQL so I'm not sure how to dump my tempdb database. I have a coworker that has only done this sort of thing in the Enterprise Manager and we can't get there. So how do I do this and make sure that I don't blow away any data? Also if I do dump my tempdb will this cure my problems and how do I avoid having this happen again?

Any help would be greatly appreciated,
Jeb

View 1 Replies View Related

Setting Up SQL Server For Remote Clients

Jul 20, 2005

Hi,I am having a hard time setting up an SQL Server 2000 DeveloperEdition instance for remote clients. The instance is running well andI can connect to it on the local computer. When I try connecting fromanother computer using Enterprise Manager with the server's IP as theinstance name, I always get the usual "Specified SQL Server not found"error. I have used Enterprise Manager many times to connect to localand remote servers (which were set up by someone else obviously).I used the client network utility on the client to make an alias forthis server and have it use the TCP/IP library for port 1433.I understand that SQL Server listens on port 1433 for connections. Ihave a firewall on the server and setup 1433 forwarding. But when Iuse Enterprise Manager to try to register the server, the firewalldoesn't even show a connection attempt on port 1433 (it logs allconnection attempts).When I use telnet to port 1433, the firewall logs the attempt butthere is still no connection, as if the server isn't actuallylistening on 1433 at all. I can't seem to find any help on getting theserver listening, as if it supposed to be easy to set up so I don'tknow what I'm missing. I guess I have the following questions:1) Does anything have to be done on the server side to set it up tolisten for remote client connections?2) How do I set the port on which the server listens in case I want tochange from 1433?3) Does anything have to be set up on the client side other than usingthe client network utility?4) Why does Enterprise Manager not seem to even attempt a connectionon port 1433 when I try to register this server?Any help is appreciated.

View 2 Replies View Related

Setting Up A SQL Server For Remote C# Clients

Apr 25, 2008



Hello, I know that this has been asked several times, but none of the answers that I've found seem to help me.
I've been programming a C# client app that helps netadmins at my school file and solve tickets. I use an SQL 2005 backend; it works just fine on my dev computer (with C# express installed) which doubles as the SQL server. Now, when I move to a different computer, w/o Visual C# or SQL installed, I get.
"Request for the permission of type 'System.Data.SqlClientPermission, System.Data, Version=2.0.0.0,Culture=neutral,PublicKeyToken=(RANDOMVALUE)' failed."

my connection string

@"Server=FLHS7T-39312914SQLEXPRESS;Integrated Security=True;Database=msdb"


I've previously been able to get it to run both on client and server, but this error cropped up after a bit of a hiatus...

View 1 Replies View Related

Can ASP.net 2.0 Be Connected With SQL Server 2000?

Jan 7, 2006

using  vs2005 to build  web pages of asp.net 2.0, The database is SQL  Server 2000,.But I always fail to connect.
using the following  configuration in web.config:
<appSettings>  <add key="DSN_student" value="server=(local);uid=admin;pwd=123456;database=network_course"/>   </appSettings>
I also failed to connect using  the following configuration in web.config:
<add name="network_courseConnectionString1" connectionString="Data Source=(local);Initial Catalog=network_course;User ID=admin;Password=123456;"   providerName="System.Data.SqlClient" />
I am a beginner from  China  and eager to get answers! Thank you!
 

View 2 Replies View Related

SQL Server 2014 :: Run Same Script For Multiple Clients

Jul 30, 2014

I have a script that needs to be run for 50 different @ClientID. I dont want to run this script individually for each clientid. Would 'SET @clientID in (111, 222, 333) work? I've been told that it wouldn't. Short version of the script is.....

DECLARE @ClientID varchar (MAX)
DECLARE @UserID varchar (MAX)

SET @ClientID = 111 -- Replace with Client ID
SET @UserID = 5656 -- Replace with your ID

[Code] .....

View 9 Replies View Related

My Exchange Server Stops Responding To Clients.

Dec 15, 2007


Hi All,
I am having exchange server 2003.
With following details.

1.Operating System 2003 standerd with sp2.
2.Exchange server 2003. Service pack don't know ( How to check)

From last 2 months, every two days my exchange server stops responding to clients.

When I check the services, all the Exchange related services are ON. ( they are running fine).

Then I use to Restart All excahnge related services, i.e Microsoft Exchange Information Store & Ms Exchange System Attended service and things starts working fine again.

This I have to do every 2 days.

I don't know why this is happening.

Can anyone assist me to resolve as it is getting critical day-by-day.
Also How can I check which service pack of exchange is installed.

Many Thanks

Muzaffar
Network Admin.
Carrier - Saudi Arabia.

View 2 Replies View Related

Automatic Data Fill-up

Oct 28, 2006

Hello guys! I am relavtively new to ASP.NET programming ang was just starting out on my first project. I am using ASP.NET2.0 technology by using Visual Web Developer 2005 Express Edition and of course with SQL 2005 Express Edition. I would like to develop a database for our IP addresses, so one field of my table in a SQL data is the field for IP addresses.I would like to write a program wherein after clicking the button, that field will be automatically filled up with IP addresses (e.g, from 192.168.0.0 to 192.168.0.255).How do I accomplish this kind of dynamic filling up of fields? Thanks a lot! 

View 1 Replies View Related

Automatic Data Import

Oct 17, 2006

I just got sql 2005. Can someone point me in the right direction on getting started importing data. I need to be able to load ascii data into SQL 2005 on a weekly basis. This ascii file will have the same data structure but data will change weekly.

I have heard to do this automatically (basically with a click of a button) you should use a DTS package. I also see this SSIS. I am trying to understand what to use for this import process. I would really appreciate any help on this. Thanks.

View 1 Replies View Related

How Many Users Are Connected To My Aspnetdb (SQL SERVER)?

Jan 18, 2008

I have uploaded my site on localhost and sharing on intranethow can i answer these question? Q1) How many users have loggedin? and using my database?Q2) Which table has lots of load?Q3) how can i immediately close particularly connection?  

View 4 Replies View Related

Maintaining A Log For The Users Connected To Sql Server Db.

Dec 8, 2005

Hi !

I need to maintain a record such as how many time any user (e.g, sa) connects to the sql server. Means whenever any person is connecting to the database through application or directly, then i need to know that through which sql user(e.g sa), any body connected.

Regards,
Shabber Abbas Rizvi.

View 1 Replies View Related

View Users Connected To SLQ Server?

Jul 20, 2005

Is there a utility that will allow me to see what users on my network areconnected/active on SQL server?Ryan

View 4 Replies View Related

When Windows Firewall Is ON, SQL Server Does Not Get Connected Thru TCP

Jul 27, 2006

I am using SQL Server 2005 Express + SP1 on a Windows Small Business Server(SBS) box. The SBS is connected to a client thru LAN.

Following are what I gave as IP address and DNS on the server:

IP: 192.168.16.2, subnet mask : 255.255.255.0, Preferred DNS server: 192.168.16.2, Default gateway and Alternate DNS Server blank

On the client, I have,

IP: 192.168.16.4, subnet mask : 255.255.255.0, Preferred DNS server, Default gateway and Alternate DNS Server blank

I can ping and connect to either of the machines.

If I do a sqlcmd -S "tcp:servernameINSTANCE,port", I get the following error message:
HResult 0x80090304, Level 16, State 1
SQL Network Interfaces: The Local Security Authority cannot be contacted

Sqlcmd: Error: Microsoft SQL Native Client : Cannot generate SSPI context

If I do a sqlcmd -S "tcp:192.168.16.2INSTANCE,port", it connects to SQL Server.

I have the Windows Firewall ON. If I Off the firewall, I do not have any problem at all.

I included File and Printer Sharing, sqlsvr.exe in the Exception list of the Windows Firewall.

Any help to solve the issue is appreciated.

Thanks.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved