|
I was thinking that last night.
Mycroft Holmes wrote: having a local database that is communicating with the remote server implies WAY too many fracture points.
Why fracture points? I see it as a second, local copy/backup if you will. I'd love to hear your thoughts.
If the post was helpful, please vote, eh!
Current activities:
Book: Devils by Fyodor Dostoyevsky
Project: Hospital Automation, final stage
Learning: Image analysis, LINQ
Now and forever, defiant to the end.
What is Multiple Sclerosis[ ^]?
|
|
|
|
|
I see something like a sql express copy locally where you write the graphic to it. Then you need to have the local DB copy/replicate to the server. How were you going to get the local database to move the record to the server.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: I see something like a sql express copy locally where you write the graphic to it. Then you need to have the local DB copy/replicate to the server.
That's exactly what I was thinking of.
Mycroft Holmes wrote: How were you going to get the local database to move the record to the server.
Most likely a trigger. Once insertion is complete, then the DBs can take their time sending it over the wire.
If the post was helpful, please vote, eh!
Current activities:
Book: Devils by Fyodor Dostoyevsky
Project: Hospital Automation, final stage
Learning: Image analysis, LINQ
Now and forever, defiant to the end.
What is Multiple Sclerosis[ ^]?
|
|
|
|
|
Trigger is how you initiate it, how are you goung to get local db to talk to server db, this is the crucial question as I think your options break down to the following or some kludge connection.
Linked server
SSIS
Web service
I'm not sure express supports this tech
I would consider installing and maintaining a local db to be an outrageous cost for this requiremment. What happend when you move from Dev/UAT to production servers etc.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I was considering a Linked Server but the more I think about it, the less appealing the idea becomes.
If the post was helpful, please vote, eh!
Current activities:
Book: Devils by Fyodor Dostoyevsky
Project: Hospital Automation, final stage
Learning: Image analysis, LINQ
Now and forever, defiant to the end.
What is Multiple Sclerosis[ ^]?
|
|
|
|
|
Mustafa Ismail Mustafa wrote: appealing
Appealing AAAaahhhh runs screaming from the room
Appart from the fact that I don't think express supports linked servers, maitaining and deploying the solution would be plain nasty. Go for the addition thread doing the write back.
|
|
|
|
|
hi
i want save a picture from a picture box in dataset,and then update Access DataBase with this dataset.
how i do?
plz help me
Have a nice day
|
|
|
|
|
Plz Help me
Have a nice day
|
|
|
|
|
If you Google/Bing for something like c# save image to database or vb.net save image to database, depending on your language, you will get loads of help.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Thank You
Have a nice day
|
|
|
|
|
Hello,
I'm having this error during installation.I've tried a bunch of things like
copying to hard drive and installing, but to no avail.
The error:
cabinet File 'sql.cab' required for this installation is corrupt and cannot
be used. This could indicate a network error, an error reading from the CD-ROM, or a problem with this package.
Any solution would be greatly appreciated.
TIA
|
|
|
|
|
Clearly the installation is Corrupted.
Download SQL SERVER 2005 directly from internet or call Microsoft help desk for help.
|
|
|
|
|
Im trying install SQL Server on windows XP.
I can install SQL Server on other machines but I can install it on my machine !!!
Where should the sql.cab file be on the installation disk? I can't find it anywhere...
So what shuld be cause and how can I overcome this error for proper installation into my machine .
|
|
|
|
|
Which version of XP?
"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering
|
|
|
|
|
Try a different cd/dvd unit - I had exactly the same problem over the weekend. Used an external USB dvd and no problems.
|
|
|
|
|
I want to learn how to design database ,i want some solved examples, samples,case studies,step by step solutions ,or some one has some materials etc ,
please guide me how to design DB,i have much problems in creating relationships.
you can send me any helpful material at waqarnaeem2@hotmail.com
|
|
|
|
|
|
Please, I'd like to know how to delete a member's related information(user name, pasword,....) which are stored in ASPNETDB database created in Visual Studio 2005 either by using a specefic wizard like the wizard used to create users or by code.
Any suggestions please??
|
|
|
|
|
Try typing "delete user ASPNETDB" into Google.
|
|
|
|
|
call dbo.aspnet_Users_DeleteUser to delete the user account.
Hope this helps.
|
|
|
|
|
hi
i am currently using vs.net 2005 c# window application and using ms sql as the database.
usually when i create database it is good practice to separate our database to such as below:
table: dad
table: child
where by when inserting data we have to add the dad data first then the child.
insert data into dad table
insert data ,max(index) from dad into child table
my question is there a more effective way to do this like inserting the data in one sql command while inserting the newest index from the dad table to the child table as a reference.
and thus if there are any error during the adding of data to any of the table both table will be then unaffected.
modified on Saturday, August 15, 2009 1:01 PM
|
|
|
|
|
neodeaths wrote: and thus if there are any error during the adding of data to any of the table both table will be then unaffected.
There is a mechanism built into SqlServer to take care of situations like that. It is called Transactions this article on transactions[^] covers the basics. I found it by Googling for sqlserver transactions c# which gives loads of hits.
Explore for yourself, experiment, have fun.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
As Henry suggested transactions are the way to control this process. However I have trouble with you using max(index). You should be using an identity field for your primary key and then get the scope_identity() value from the dad insert to apply to the child record.
I rarely use transactions but I consider them valid for processing related DATA, while the dad/child data is related I don't think a transaction is warranted. I would have a proc that inserts dad and returns the scope_identity() as DadID and then insert the child in a separate proc.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: while the dad/child data is related I don't think a transaction is warranted
A bit of a sweeping staement there. It all depends, if you need to have both records inserted or niether of them then it should be a done in a transaction, but if orphan records are acceptable then there is no need.
Mycroft Holmes wrote: I would have a proc that inserts dad and returns the scope_identity() as DadID and then insert the child in a separate proc.
Fine, unless you must have them both inserted. In your senario it would be possible to have Dad records with no Child records - maybe, depending on the application, this could be an invalid case.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Ashfield wrote: A bit of a sweeping staement there
That's why I stated it as a personal view, and yes it must be driven by the business requirements every time. I generally work with batch processing and rarely need trans.
Ashfield wrote: Dad records with no Child records
I would assume that unless the business required the relationship - dad does imply it I must admit.
|
|
|
|