web enabled accessing vfp database

[omar nustafa]

I really need help to access my foxpro .dbc database files reside in TSPLUS server
(share folder) while my application in my client computers , just like the test performed by TSPLUS teem,
could you provide me procedure to achieve this

[dcipher]

Hi

You can simply create a share on the TSPlus server for the folder which contains the database. Then on the client computer you can open the database as follows:

Open Database \\ServerIPAddress\ShareName\yourDatabase.dbc

You will have to replace the ServerIPAddress, ShareName and yourDatabase with the values for you actual situation.

This really has nothing to do with TSPlus it is simply using the networking capabilities of VFP. I do this all the time and it works just fine.

Simon

[omar nustafa]

Thanks for your response Ms dcipher
One more question , if it has nothing to do with TSPlus, how can I make benefit of high speed access when using the UNC . I test similar access using UNC with rented website server , the connection established after 6 minutes , hireable

[admin]

Hello,

Thank you Dcipher for this precision.
Network sharing can be fast and effective if all of your network resources are located on the same network. You can also choose to use the subst command to create a logical drive on the TSplus where your applications are installed and published to provide an access to local resources.

Below some common knowledge regarding the redirection of a folder within a TSplus session :

If your goal is to publish the content of a folder with an exclusive access to each users then follow this procedure :

tsplus.net/support/kb/faq.php?id=25
and in the generated script type in the path of your application subst Y: C:\Users\%USERNAME%\your folder

Doing so your user will be able to have access to this drive letter Y:, which will be pointing to their exclusive profile folder. Of course this is only an example.
If you would prefer to redirect their local "My documents" folder or any other specific folder then type in :

subst Y: \\tsclient\c\Users\%USERNAME%\Documents

The final step is to publish an application that will secure the Y: of each users, preventing them from accessing the whole server. To do so, open an admin tool, go to the application tile and click on "Application publishing". Add the folder application located in C:\Program Files (x86)\TSplus\UserDesktop\files.
In the command line option, set the path of your application (Y: in the example above). The last step is to publish this application to your users / groups. Doing so your users will only have access to the content of this folder.

[omar nustafa]

Hi Admin.
Sorry for disturbing you again ,
I follow up all the steps you have mentioned in your pre. Post
Actually , I published only the database shared folder which I need to be accessed
By all users and map it from network resource as Z:
I don’t want to publish my clients desktop Vfp application since I prefer to access
It from the client local desktop. (clients needs more speed)
Unfortunately ,on client, Z: recognized only in the remote box not in my local desktop,
It’s Unknown to my application
I always use to have this param. In my icon target to access my desktop application
C:\applictation\mayvfpappl.exe \\sharefolder\database
Where \\sharefolder\database point to database folder in my LAN
Or
C:\applictation\mayvfpappl.exe D:\database
I need to replace \\sharefolder\database to access the remote database in TSplus server,
In fact, Z: not a valid driver on local desktop or windows explorer
Is there any other way to target the remote database folder this way ?
I only need direct Access to database remotely .
Thanks a lot ,

[dcipher]

Hi

If you are simply using your application on the client's workstation then you are not using Remote Desktop. If you do not use Remote Desktop then it has nothing to do with TSPlus. It is merely a networking situation. Like "admin" said it is simple if the computers are all on the same network. That is they all share the the same sub-net. For example the client work station is 192.168.1.35 and the TSPlus server is 192.168.1.40. If however the TSPlus server is on a different IP Address or sub-net then everything gets more difficult. To me it is much better to run the application on the TSPlus server and access it via Remote Desktop/Portable Client. This way the data does not have travel over the network. The result is better performance of the application and less chance for data corruption. This was the whole reason I moved all my VFP applications onto servers accessed via remote desktop. The applications work faster and are more secure and I am not hindered by poor network performance.

Simon

[admin]

Hello,

Make sure your users have sufficient right access on this Z: resource. This can be tested easily by assigning a remote desktop to your users and open a session, open a windows explorer and click on your Z: resource.

Once you cleared this, you will be able to assign this application as a unique application or assign the remote taskbar or floating panel to provide a secured environment for your users.

terminalserviceplus.com/docs/remote-taskbar-and-floating-panel

[omar nustafa]

Thanks again Dcipher , for your quick reply,
I well take your advice , publishing vfp application on the TSPlus server
And let my clients access them from TSplus server , soon will start testing speed of database manipulations , if they have convinced with the good speed , the TSplus should be our choice for web enable to all of our products , re engineering my existing 6 products
Is really hard and costly , we have more than 7 companies insisting on Web-based solution, each company must purchase their own 10 users licenses at least .
again Many thanks

[dcipher]

Web access is also why I moved my applications to remote desktop and TSPlus in particular. I do not have to re-write my applications they just simply run in the browser. There was one change I had to make because the data application allows user's to export data to their local workstation. I had to be sure to generate the entire export file on the server and then copy it to the workstation if they are using the Remote Desktop. In the past I was using Windows 2003 server and I could generate the export on the client drive, but with changes in security settings on the newer operating systems this did not work. The file could only be copied in its entirety to the client drive. So this required a minor change in the application but other than that everything else works just fine. If they use a web browser then they can simply use the web download function once the file has been created.

Simon