|
How about using a trigger on the insert. As each record is inserted into one database, a similar record can be inserted into the other. 
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
|
|
|
|
|
Agreed. In my opinion, this is the best approach.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
I've done that with a Windows Service.
You could also use a Windows Scheduled Task.
|
|
|
|
|
|
Dear All,
I have a Point of sale system (Desktop application) , this system will be deployed on three different branches and one factory branch , we have also a dedicated server hosted online ,all places including the dedicated server having the same schema , i would like to replicate the new changes from branches and factory to dedicated server and vice versa , i tried to use merge replication but in vain , we could not set it up properly , we faced a problem with user account permissions , we got that message "Could not connect to distributor "DedicatedServer".
Could anyone please have a solid procedures to solve such a problem? or if there are some third party tools that could help us achieving that task ?
Your Response is highly appreciated !
Human knowledge belongs to the world.
|
|
|
|
|
What database system are you using? Oracle, MS SQL, Other?
I assume MS. It sounds like a permission problem. Might I suggest creating a SQL login with the desired permissions on all systems.
|
|
|
|
|
I'd have to know a few more details about your infrastructure to provide better feedback as to a course of action.
You may want to review this excellent series of concise articles on SQLServerCentral regarding SQL replication and how to choose the correct model for your needs:
http://www.sqlservercentral.com/stairway/72401/[^]
Best of luck!
|
|
|
|
|
can any one help me i am facing problem in writing query in my project.i am taking four link buttons in one page(test.aspx page) when i click on Test1 link it should show me the result on show page (show.aspx page) by retriving the data stored in database for Test1 table similarly if i click Test2 link it should show me the data on same show page(show.aspx page) retriving data from database for test2 table same for Test3 and Test4 link.database iam using here is sql server 2005.
|
|
|
|
|
How it's displayed and how the user interacts with it doesn't matter. What database system? What is your schema like?
|
|
|
|
|
Trap the click event from the buttons
Identify the button Test1-4 to determine the table
Create a query string to select the data based on the button clicked
Create a connection to the database
Create a command using the connection string and the query string that returns a data table
bind the datatable to the grin in your UI
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
@mycroftholmes can u plzz write query for me to retrive data from diffrent tables on a single pages.
|
|
|
|
|
Nope, I have better things to do that your work.
[edit]
I relent
Select * from TableName
there you go, just replace tableName with the table name.
[/edit]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
how to insert mathematical symbols like integration diffrenciaton symbols in database.so that it can be redable in .netframework when it is retrived from databse
|
|
|
|
|
You have not indicated what database and version you use. In simple terms, you've to use a collation that supports unicode characters. For SQL Server, this[^] will be a starting point.
|
|
|
|
|
shameel thanks for replying actually iam using sql server 2005 and sql database and i want to know how to insert signs of inegration, diffrenciation and limits in database....
|
|
|
|
|
Same answer still applies.
1. It depends on what you 'mean' by "symbol"
2. If and only if the answer to 1 means that unicode is suitable then you have the following choices
a. Set up the database to accept unicode.
b. Encode the data into the character set that the database does support (probably to base64) and live with the fact that you won't see the characters in the database itself - you will need to use your application.
|
|
|
|
|
@jschell by symbol i excatly means what we use in maths i mean symbol to represent inegration and diffrenciation i hope u can understand what i mean to say..
|
|
|
|
|
I understand what a mathematical symbol in mathematics means.
However that has nothing to do with how you represent the idea on a computer.
For example I could use a paint program to create a formula and then store it in a database.
Or, as I suggested, unicode has mathematical representations.
There are other possibilities.
It is up to you, based on your business needs, to first determine the form (the data on the computer) that your representation will take.
|
|
|
|
|
pankaj3086 wrote: how to insert mathematical symbols like integration diffrenciaton symbols in database.so that it can be redable in .netframework when it is retrived from databse
Can you post an example? Show us what it is that you want to store, 'cause as it is, you won't get much valuable answers.
All text-encodings are supported. No, text does not support all math. So, how are your users going to represent their content?
MathML[^] would be a good choice, and you can store it in a VARCHAR column.
Bastard Programmer from Hell 
|
|
|
|
|
I agree with Eddy. You don't need to store the actual symbols in the database (although you can if it makes sense). The symbols are more a matter of UI.
I second using XML or similar to persist the concept of the expression.
|
|
|
|
|
I'm interacting with a dBase III file using Microsoft's ODBC dBase driver. I can create a CRecordset object and iterate through the table just fine (populating controls on a dialog and such). When I went to count the rows/records in the table using SELECT COUNT(*) FROM ACTY, the code kept throwing exceptions. Based on the error messages in the debug window, I suspected column 1 (type Date) was at fault. I managed to insert another column into the table of type Text (Numeric type also works). The COUNTing code now works fine. My question is, why? I could iterate the table just fine when the first column was a Date, but not count the rows. Is there a rule that states what types can be in the first column and what types cannot when counting? As there are hundreds of these database files in use, injecting a "dummy" column into them just for the sake of counting is not a solution.
[edit]
I was able to create a dBase 5 table and it exhibited the same behavior. When I added the extra column, however, no exceptions and counting worked fine.
[/edit]
[edit2]
I was able to successfully count records in the table using the ODBC API (e.g., SQLDriverConnect(), SQLExecDirect(), SQLGetData()) rather than CDatabase and CRecordset.
[/edit2]
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"Show me a community that obeys the Ten Commandments and I'll show you a less crowded prison system." - Anonymous
modified 19-Mar-12 10:45am.
|
|
|
|
|
I'm surprised at your findings. The COUNT function shouldn't care what columns are on the table or what datatype they're made of. May be a bug with the driver?
If I were you, I would suspected that USER was a keyword and would have tried to rename the table and see if it worked instead of adding a new column.
|
|
|
|
|
Shameel wrote: I'm surprised at your findings. The COUNT function shouldn't care what columns are on the table or what datatype they're made of. May be a bug with the driver?
I'm not familar enough with it one way or the other. If you step through the code, however, the columns are definitely being bound (in the set's DoFieldExchange() method).
Shameel wrote: If I were you, I would suspected that USER was a keyword and would have tried to rename the table and see if it worked instead of adding a new column.
There are actually two tables: ACTY and USER. The USER table works fine with no changes, both iterating and counting.
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"Show me a community that obeys the Ten Commandments and I'll show you a less crowded prison system." - Anonymous
modified 18-Mar-12 16:58pm.
|
|
|
|
|
DavidCrow wrote: dBase III
I do hope that you have a copy of that database is a more recent format?
Bastard Programmer from Hell
|
|
|
|
|
If I can't operate on it directly, I will consider converting it. Given the constraints on the client side, that would be a last resort.
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"Show me a community that obeys the Ten Commandments and I'll show you a less crowded prison system." - Anonymous
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
