Virtualize files... Your idea ? TIA

[yakata]

Hi there !)

I try to explain, clear and short..

I intend to use an app which open a file when you click on an icon of the file.
But... My app knows the last path to the file (stored in a db).. and from time to time, another app is moving the files, from one server to another (logging his moves in another db).
How do i do to give to my app the right path ? At which level do i intercept the 'open a file' call ?
What is the best way to achieve this ? In VB ? In C++? on a Sql server 2000 database?

TIA for your precious opinion and success in your business !))

 

[scorpio66]

Do you have access to this 'other db' and if so, can you use this to get the location of the file?

If not, does the 'other db' have access to your database? If so, you could get the 'other db' to update the location record in your database.

chaz

 

[yakata]

Well, to be complete, the DB which logs the moves is the one of an HSM system. No problem, I can access the DB through an API with question like 'where is the file MMMMMMM.mpg?', the answer is the real path for the file on a server (or i ask the restore on server by the API).

The point is to be shure that I can 'capture' the open command, query the DB of the HSM, and give the right file in return...seamlessly...

It's seems difficult to ask to the HSM to update my first DB because this DB is used by 150 clients and I wish that all the 'processing power' is oriented to them... if possible ;-)
Thanks for your reply, hope this help, and sorry for my.. poor english ^-^

Luc