I've written a VOD program using VB & VFP. It works okay, however, I want it to be database driven not have to use work-arounds just to make it work. I perfer to program in VFP, however, VB ran the MPEG ActiveX player better: didn't work quite as well in VFP.
I have a NT server with 10 to 20 workstations requesting videos. The VB program runs on a Windows 98 workstation whick interfaces with the user making the video request. We've had to use text files in order to get VB & VFP to communicate. Text files were used becuase we couldn't get VB to R/W to VFP database. Really want the whole system to be database driven.
From what I've read on some of the threads ...
I could write a COM object, load and run the COM object on a server, then VB (running on a workstation) could use the COM object to R/W to a VFP database(existing on a server).
Is this, basicly, how it works? Can all my VB programs use the one COM Object at once (muti user)?
I would appreciate any advice.
Thank you.