Help needed in a Database app !

Help needed in a Database app !

Post by Panduranga Prabh » Sat, 16 May 1998 04:00:00



Hello All,
Has anyone there encountered a problem like this ? If yes
can they help me in this.

The Problem is like this.
A database (Sybase) is being updated regularly by some applicattions.
(A large no of tables are updated)
Whenever there is an update a process (outside SQL SERVER)
should be able to catch this and do some processing. There is
a requirement that Database should not be overloaded by this
process capturing updates. Is there a way of doing this (other than
monitoring of tables by polling ).

We are also thinking of using Sybase Replication Server to replicate
this database , and work on the replicated database so that the
original database is not overloaded. Is there a better , efficient
way of doing this ?

I hava another question regarding triggers . Can the triggers
communicate
to outside SQL Server (like kicking of a process ? or writing to a file
??)

I am new to database applications , so if the questions sound too
ametaurish please excuse.

With best regards,
Prabhu

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
I started out with nothing. I still have most of it left.
                              ___     _,.--.,_
Panduranga Prabhu M        .-~   ~--"~-.   ._ "-.
Ericsson Communications   /      ./_    Y    "-. \
Pvt. Ltd ,6 th floor,    Y       :~     !         Y
Prestige Meridien 1,     lq p    |     /         .|
M.G. Road ,           _   \. .-, l    /          |j
Bangalore  -560 001  ()\___) |/   \_/";          !
                      \._____.-~\  .  ~\.      ./
Ph No : +91-80-5595707           Y_ Y_. "vr"~  T
                   708,709       (  (    |L    j
Fax   : +91-80-5095193           [nn[nn..][nn..]
Resi  : +91-80-8600693       ~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 
 
 

Help needed in a Database app !

Post by Grigory Kanevsk » Sat, 23 May 1998 04:00:00


Starting with 11.5 Sybase provides new feature called extended stored
procedure. This may be
exactly what you are looking for.
This is good place to start to learn about them:

G.



Quote:> The Problem is like this.
> A database (Sybase) is being updated regularly by some applicattions.
> (A large no of tables are updated)
> Whenever there is an update a process (outside SQL SERVER)
> should be able to catch this and do some processing. There is
> a requirement that Database should not be overloaded by this
> process capturing updates. Is there a way of doing this (other than
> monitoring of tables by polling ).


 
 
 

1. HELP - Database Setup App Help NEEDED ???

I have a problem with my Setup program.

First, I'm using InstallShield Express 2 (handles DAO, suposedly).
My app is developed using VC4.1.
My app uses DAO and an Access DB created with Access 2.0.
I'm using DAO 3.0 (if I read the dlls correctly).
I have two nearly identical workstations (system 1 and system 2).

My app compiles and executes without a hitch on my system (system 1).
I created a Setup program, which does include the DAO support and MFC
4.1 support files).  I have verified that these files are installed on
both systems.

After I run the Setup program on system 2, I get an error when I try
to run my app.  The error is:

"Cannot open database created with earlier version of the
application."

Both applications are identical on each system.  They use exactly the
same DB (it's on a network drive).

I have checked the dlls in the system32 directory and both systems
have the same dlls that relate to the DB:

msjt3032.dll, msjter32.dll, msjint32.dll, vbajet32.dll, vbdb32.dll

They have the same date.

Why is it that I can run the Setup program on both systems and yet can
only run the application on System 1.  System 2 is the only one that
produces the error?

What is wrong?  I would like to try and understand this problem, so
please don't just say try another setup program.

2. JAVA_XA errors when starting up a connection pool

3. VB5 - need help with small database app and search

4. database date

5. VB5 -need help with small database app and search

6. TDBGRID Multiselect

7. Need help with performance of Btrieve database app.

8. Entries from SQL65 in the Event Log

9. Need help choosing text database app

10. Database Tables Disappearing - HELP HELP - Need Access Database specs

11. Need help with ASP app that uses SQL for the back end

12. Need some help! - ODS Service App

13. Help needed! Real time app = problems with locks