Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Benji
Starting Member
4 Posts |
 Posted - 2012-01-30 : 19:03:12
|
| Hi all,I am very new to SQL and databases and am wondering if what i am trying to do is possible.I work with a piece of software that relies on an MSDE, i believe this functions similarly to a SQL database? What i would like to do is remotely add entries to the database, which i can do using Microsoft SQL Server Management Studio. My problem however, is that these entries are not displayed in the software we use unless we exit the software and go back in. I hopefully would like the new entries or amendments to appear live. Would this be possible?Thanks |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-01-30 : 19:22:36
|
| If the data is getting inserted into the database tables, but are not showing up in the software front end, it could be that the software front end (and/or middle tier if there is one) is caching the data and not getting refreshed.You may want to ask the software vendor if that indeed is the case, and if so, how you can force the software to retrieve your new data from the database. It may be that there is some type of "refresh cache" or "send notification" feature built into the software. |
 |
|
|
Benji
Starting Member
4 Posts |
Posted - 2012-01-31 : 11:43:41
|
| The original software vendors unfortunately are no longer around. Is it not possible to get SQL server management to run a procedure to update and applications currently connected to the database? Much like the command that must be run at the start when the software is opened up?Thanks |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-01-31 : 12:18:34
|
quote:
Originally posted by Benji
The original software vendors unfortunately are no longer around. Is it not possible to get SQL server management to run a procedure to update and applications currently connected to the database? Much like the command that must be run at the start when the software is opened up?Thanks
That may or may not be possible - if I had to venture a guess, I would guess "not possible". When the software starts up, it is querying the database, receiving the data, and doing something with it. If you were to run the same queries from outside the software, for example, from an SSMS window, that SSMS window rather than the software would be receiving the data. That is why I am not very hopeful about that approach. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Benji
Starting Member
4 Posts |
Posted - 2012-01-31 : 12:33:24
|
| Thanks for the responses. Strangely enough, when i run certain Stored Procedures from SSMS whilst the front end application is open, the changes are reflected inside the front end application however, other Stored Procedures, like the ones i am interested in do not. The fact that i have had some progress executing procedures and seeing their changes reflected live in the software makes me think it would be possible? |
|
|
|
Benji
Starting Member
4 Posts |
Posted - 2012-01-31 : 12:35:44
|
| X002548 is that a suggestion towards me or a question towards sunitabeck? I did think about using access but figured as i am directly making changes into the DB, going through access is just complicating matters further. Could you elaborate more on your AutoExec comment please :)Thanks |
|
|
|
|
|
|
|
|
Remotely input SQL entry