IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

December Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox Forms Topic   Print This     

Multi-user and Win XP

Multi-user and Win XP in Paradox Forms topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Multi user   Multi user Win  
Leo
Civilized Africa
I'd like to use Paradox 9 with more than one developer on the same project. The user manual says this is posible but never says how. I'm brand new to Paradox though. Has any one done this before? We have one PC on Win98 and one running WinXP. Could this be part of the problem? Has anyone ever done multideveloper on an XP box before? Some one told me that XP is not compliant, but Paradox 9 does run on it. Any body got a clue? Help would probably save my job :)
Another Leo
_ _ ___________________ _ _
We are Micro$oft
You will be assimilated
Resistance is futile
 Posted 19 years ago (Thread Starter)
Comment Quote
About Leo -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #8411, 11 replies
Thread Started 11/25/2002 3:56:00 AM
View Counter=1707
Last Reply Posted 12/2/2002 9:54:00 PM)
Location=Civilized Africa  
Joined=19 years ago   MB Posts=96  
Langley McKelvy
Harris County Texas, USA
We use Paradox 9 on multiple XP/Win98/ME PCs, all accessing the same network server. Multiple users can access the same information (forms, scripts, tables, reports etc...) at the same time with no problem if the application is properly coded. There are two schools (or more) of thought about setting it up. Shared IDAPI or independent IDAPI? I use the shared IDAPI, wherein I locate the IDAPI.cfg file on the server and load it using the command line option -o from each PC. The IDAPI contains a pointer to the location of the common NET file (which must be on the server and accessible to all PCs) and the public aliases. XP can be a bit difficult because you have to set full access permissions on the client PCs in the right folders, or it gets pissed. If you need specific help, email me directly.
Mac

[i]"A king will have his way in his own hall, be it folly or wisdom."[/i] - Gandalf
 Posted 19 years ago
Comment Quote
About Langley McKelvy -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Langley McKelvy
Computer Crimes Investigator / Computer Forensics Specialist Paradox for DOS/Windows Programmer

Post ID #8418 (Level 1.1)  Reply to 8411
Thread Started 11/25/2002 9:15:00 AM
View Counter=2
Location=Harris County Texas, USA  
Joined=19 years ago   MB Posts=387  
Tony M
 (Inactive)
"user manual says this is posible but never says how."

Well, how do you mean?

Paradox can run from a workstation, opening, editing and saving files on a 'server'.

That should be all there is to it.

You just have to make sure that all systems point to the EXACT same path for the .NET file.

And by EXACT, I mean that literally. Not 'resolve' to the same path, but contain the exact same characters, other than drive letter. I believe even capitalization must match.

But it depends, I suppose, on what you mean by 'on the same project'. What makes you think it won't work?

Also, I don't believe you get a warning when opening a form/report/lib/etc on more than one machine at the same time. But I HAVE gotten a warning that the open form was changed since opened when just opening it twice from the same or second INSTANCE of Paradox on the SAME machine, and then trying to save. Not sure if you get that from 2 separate machines.
 Posted 19 years ago
Comment Quote
About Tony M -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.

Post ID #8412 (Level 1.2)  Reply to 8411
Reply Posted 11/25/2002 4:10:00 AM
Location= 
Joined=19 years ago   MB Posts=410   KB Comments=1  
Tony M
 (Inactive)
"Is there a differance between the instalation of paradox on the server and the client? "

Not really. The main issues, I think, is getting the .net file location set correctly.

On the box HOSTING the .net file, the temptation is to give Paradox the shortest path to that directory, as is the temptation on the CLIENT box. But they must be the same.

As to speed, check your virus software settings and exclude Paradox file formats. As well, shut off write-cache on both machines. In particular on the XP box turn off Opportunistic Locking (Workstation).

There have been reports that using UNC over a network, especially with multiple network protocols installed, can cause slow data transfer.

Also remember, your configuration has the data/files being transferred from a (likely) 'older' hard drive, which is slower by today's standards. AND 2 computers are sharing that drive's ability to serve up files. You may indeed have other 'issues', but configuration may be a part of the speed thing.
 Posted 19 years ago
Comment Quote
About Tony M -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.

Post ID #8434 (Level 1.3)  Reply to 8411
Reply Posted 11/26/2002 5:10:00 AM
Location= 
Joined=19 years ago   MB Posts=410   KB Comments=1  
Tony M
 (Inactive)
You've interchanged '/' and '\' in all instances here. Is that a typo? If not, that is the first thing you need to 'fix'.

Should be \\server\bde and c:\esi

But you CANNOT use c: if you are going to share the directory. Unless you map m: or something to the 'server' c: drive. Then you'd have c:\esi and m:\esi. That should work. Better than that, you might map m: to \\server\esi on BOTH machines, and have the root of M: be your subdirectory. Then, the client doesn't 'see' the 'server' c: drive root as m:.

But you could also use \\server\esi on both machines. Then no drive maps needed.

More a matter of choice than anything, I think. Although there are reports that using UNC (\\server) can cause slowdowns on SOME networks, especially NT and where multiple protocols are in use.

However, I use UNC exclusively and have not noticed any slowness at all.
 Posted 19 years ago
Comment Quote
About Tony M -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.

Post ID #8438 (Level 1.4)  Reply to 8411
Reply Posted 11/26/2002 6:21:00 AM
Location= 
Joined=19 years ago   MB Posts=410   KB Comments=1  
Tony M
 (Inactive)
"The XP client hangs".

What is the EXACT path in the alias on the XP client?

Does the path get to the whole directory?

Are both machines set up to 'see' the server directory the same?

One may have rights to the directory, or a 'share' on the server that the other (XP) system doesn't.

You need to make sure that both systems have rights to the share on the server, sounds like.
 Posted 19 years ago
Comment Quote
About Tony M -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.

Post ID #8510 (Level 1.5)  Reply to 8411
Reply Posted 12/1/2002 3:53:00 PM
Location= 
Joined=19 years ago   MB Posts=410   KB Comments=1  
Tony M
 (Inactive)

...We still have some problems but they seem to be concerned with the application framework that was used to create...

App Framework?

YIKES!

Reprogram that one as soon as possible! AF is a tool to get started learning Paradox. But there are too many problems with how it was implemented to consider it for apps that may need to be customized or ported to other systems.

But the real deal is that you have your system running.

And yes, while it WORKS, a system acting as a workstation AND server should be avoided if at all possible.

The general recommended solution is exactly what you did. Use a separate system, old but reliable if necessary, as a standalone 'server' if at ALL possible.
 Posted 19 years ago
Comment Quote
About Tony M -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.

Post ID #8515 (Level 1.6)  Reply to 8411
Reply Posted 12/2/2002 8:14:00 AM
Location= 
Joined=19 years ago   MB Posts=410   KB Comments=1  
Leo
Civilized Africa
Thanx guys this is already helping a lot Big Grin! Let me explain the setup. We're developing specialised accounting software. All the work up till now was done on Paradox 9 on Win98 completely stand alone. We've done a lot of fiddling with BDE and ODBC. We've managed to read the database from the XP box but changes to the application doesn't get saved. Plus the connection on a 100mb/s network takes forever.
Is there a differance between the instalation of paradox on the server and the client? The 98 mashine should abviously be the server here. I'll go fix up the .NET file right away and see what it does. It hasn't worked so far, we've had lots of different errors. Sometimes the directory gets locked and the second pc to open Paradox can't access it any more. I can program C++ but i have to admit i'm out of my depth here. I have never done any thing with ADAPI Big Grin! Thanx for all the help
Another Leo
_ _ ___________________ _ _
We are Micro$oft
You will be assimilated
Resistance is futile
 Posted 19 years ago (Thread Starter)
Comment Quote
About Leo -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #8432 (Level 1.7)  Reply to 8411
Reply Posted 11/25/2002 10:45:00 PM
Location=Civilized Africa  
Joined=19 years ago   MB Posts=96  
Leo
Civilized Africa
Good. I pointed the client IDAPI.cfg file location to //server/bde . In the Server IDAPI.cfg I made the .NET file location //server/bde also. I made a BDE alias on the server and it is visible on the client BUT I get an invalid path fault if I try to load it. The path in the alias is c:/esi - should I map a drive to it and point the alias to the maped drive so they'll be the same too? More importantly the Aplication [ESI] that I'm trying to link to is not diplayed in the client project viewer but it is on the server project viewer. So what am I missing?
Another Leo
_ _ ___________________ _ _
We are Micro$oft
You will be assimilated
Resistance is futile
 Posted 19 years ago (Thread Starter)
Comment Quote
About Leo -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #8436 (Level 1.8)  Reply to 8411
Reply Posted 11/26/2002 6:01:00 AM
Location=Civilized Africa  
Joined=19 years ago   MB Posts=96  
Leo
Civilized Africa
Hehe yea sorry I wasn't looking what I was typing its all \\
OK so now I've set up the shared ADAPI.CFG to use \\server\bde as a net dir. My alias in BDE points to \\server\c\esi (forgot the c before) It works well to follow the path in windows explorer through the network neighbourhood and then cut and paste the path. I can see the alias on both server and client. On the server the alias works fine, but the XP client hangs when I try to open the alias in the project viewer. Is there some setting on XP I'm missing? At the same time I'm thinking I'm up the wrong creek because in the Project Viewer under Applications I see [ESI] on the server but not on the client. How do I make the whole aplication avalable to the client? My alias only allows access to the tables in my application and not to the forms, SQL, or data modules, even on the server. This thing is getting me down arrrrr Confused Think I should change my nick to Dased-and-confused
Another Leo
_ _ ___________________ _ _
We are Micro$oft
You will be assimilated
Resistance is futile
 Posted 19 years ago (Thread Starter)
Comment Quote
About Leo -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #8493 (Level 1.9)  Reply to 8411
Reply Posted 11/28/2002 1:19:00 AM
Location=Civilized Africa  
Joined=19 years ago   MB Posts=96  
Leo
Civilized Africa
Thanks for all the help. We finally have some sort of a working set-up going. We got an old Win95 system to play server for a test drive to exclude the whole XP factor. It seems to be mostly working now. I shared the whole hard drive on the server and mapped it as g:\ on all the workstations. It seems a paradox box can't be a server and a workstation at the same time without extensive fine-tuning that doesn’t always work. We still have some problems but they seem to be concerned with the application framework that was used to create the application, a long time ago. For some reason it will allow us to edit every thing except the menus of the application. I’ll report back if we ever fix that.

Apparently XP is a bottomless pit of permissions and permutations that I don’t know enough about. We still haven’t managed to make it work on an XP workstation Banging Head On Wall but networking between a 95 server and 98 workstations are fine.

Thanks to Jedstar and Mac for solving most of my problems Big Grin!

I’ll include this set up info Mac supplied for completeness so some one coming after can know this too:

Let’s set up an example server and workstation situation. Assume your server is named SERVER and the workstations are WK1 and WK2. On SERVER, there is a drive F: and a subdirectory named: F:\PDOXSTUF. Now create a directory structure for your applications. Something like:

F:\PDOXSTUF\App1
F:\PDOXSTUF\App2
F:\PDOXSTUF\App3
F:\PDOXSTUF\IDAPI
F:\PDOXSTUF\NETFILE

STEP ONE: The first step is to map drives to the server from each workstation. Let's say that you map a drive to the root of SERVER's F: drive from each workstation, assigning drive letter G:. So from the workstation's, SERVER's F: drive is represented as G:\

STEP TWO: Load Paradox on WK1 and WK2 and apply patches.

STEP THREE: Open the BDE Administrator on WK1 (BDEADMIN.EXE in the Borland folder). You will be looking at the default configuration file (IDAPI.CFG). Click on OBJECT->SAVE AS and save a copy of the file to G:\PDOXSTUF\IDAPI\IDAPI.CFG. Now you are working with a copy.

Click on the CONFIGURATION tab and drill down to DRIVERS->NATIVE->PARADOX (click on the word PARADOX). You will see some settings in the right-hand window. The only thing we are interested in at the moment is the NET DIR value. Change this to G:\PDOXSTUF\NETFILE by double clicking the default value and browsing to the right place on SERVER (G: drive). Close the program and you will be prompted to save; choose YES. That will allow all workstations to share the same netfile.

//Comment - When you leave the program it promps you to use the ATAPI file as the default set up. I'm not sure what way works, I've tried both and it seems to work now but I'm not sure what the setting is now.

STEP FOUR: Next open the properties of your startup icon for Paradox (or Runtime) on WK1. Change the commandline argument to include: -o g:\pdoxstuf\idapi\idapi.cfg (this will load the idapi file you just created in the above step).

//Comment - When we did step 4 we weren't able to edit any menus. We returned the post fix to -b and every thing works fine now. I suspect this may have something to do with the setting I commented about above. Maybe it's not supposed to load this file twice?

STEP FIVE: Run Paradox. If you get an error that says it couldn't open the configuration file, troubleshoot by checking your drive mapping, the commandline, and XP permissions. Once Paradox is open and running with the new IDAPI file, it's time to set up your public aliases (if any). Got to TOOLS->ALIAS MANAGER and start creating your public aliases.

After the aliases are created, close the alias manager and you will be prompted to save changes to the IDAPI file; say YES.

STEP SIX: Next create an icon to run your application. Don't forget to include the load of the IDAPI file on G: drive in the commandline (as above). It's target path will look something like: "C:\Program Files\Corel\Paradox 9 Runtime\Programs\PDXRWN32.exe" -o "g:\pdoxstuf\idapi\idapi.cfg" g:\pdoxstuff\app1\Startup.sdl

//Comment - considering the other two comments we've not done step six yet but we still have to test.

Now repeat only STEP SIX for all remaining workstations.
Another Leo
_ _ ___________________ _ _
We are Micro$oft
You will be assimilated
Resistance is futile
 Posted 19 years ago (Thread Starter)
Comment Quote
About Leo -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #8512 (Level 1.10)  Reply to 8411
Reply Posted 12/2/2002 5:03:00 AM
Location=Civilized Africa  
Joined=19 years ago   MB Posts=96  
Most Recent Post
Leo
Civilized Africa
Oh yes that’s no maybe. We plan to rebuild the application in C++ Builder and use the database we developed in Paradox. We are a very young company – I’m the second programmer – and way back at the start, 1 year and 3 months of work ago, our founder started learning Paradox in order to develop this app. Big Grin!

History lesson aside, we’ve made some more progress. It seems our menus can now be edited again. I’ll post the solution by commenting my last post so read up there Big Grin! XP is still full of Bug! Bug! ses though
Another Leo
_ _ ___________________ _ _
We are Micro$oft
You will be assimilated
Resistance is futile
 Posted 19 years ago (Thread Starter)
Comment Quote
About Leo -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #8519 (Level 1.11)  Reply to 8411
Reply Posted 12/2/2002 9:54:00 PM
Location=Civilized Africa  
Joined=19 years ago   MB Posts=96  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P195A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #8411 Counter
1707
Since 4/2/2008
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2021 Prestwood IT Solutions.   [Security & Privacy]