Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

paradox 10 made available to users 1

Status
Not open for further replies.

agemo

Technical User
May 7, 2003
2
US
Need to know how to make Paradox 10 available to several users on the server.

 
agemo,

if you wish several users to share the same copy of Paradox, you'll need to install the software on the server (of course).

Next, you'll need to create shortcuts on the users' desktops that start Paradox in a way that gives each user a unique private directory.

In my experience, the easiest way to do this is to add the following command-line option to the Paradox shortcut:

-p C:\WINDOWS\TEMP

The -p switch controls the private directory for a given Paradox session; the specific directory should be one that's consistently available for all users.

If everyone in the organization is using the same version of Windows, you can configure this in the BDE32.CFG file (using BDE Administrator from Control Panel).

For more information regarding Paradox's command-line switches, please see
Hope this helps...

-- Lance
 
Lance--

I find your response better than anything I've heard or seen till now, I would like to further ask.....

can we set ODBC to allow the users to connect to a copy of Paradox in the server.... or the only way is the above mentioned.

I appreciate your reply!

--agemo
 
agemo,

Yes, you can use ODBC to connect to a copy of the database on the server, however, much will depend on the ODBC driver you're using. For best results, use the driver provided with WPO 2002 Office Professional instead of the one provided by Microsoft.

The MS Driver has long been known for, um, not taking full advantage of the file type's abilities. However, the driver provided with WPO is Data Direct's driver and has long been the driver of choice for Paradox tables. For example, older versions of the MS driver do not support Paradox 7 tables while Data Direct's supported them almost immediately.

The problem, though, with the ODBC driver approach is that you'll only gain access to the data. You won't be able to use any Paradox document objects (e.g. forms, reports, scripts, and so on).
You'd need to use something like Delphi, C++ Builder, or even Visual Studio to create client tools that use the data.

If you already have a Paradox application, your best best would be to package it into a Runtime application and then install the shortcut as I mentioned in my previous message. That way, you don't have to worry about license counts and everyone gets access to the data.

Hope this helps...

-- Lance
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top