|
Home > Archive > Programming with dBASE > March 2006 > Installing 5.7 APP properly on network environment
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Installing 5.7 APP properly on network environment
|
|
| Eddie Muniz 2006-03-16, 8:23 pm |
| *** Sorry I posted this in getting started by accident ***
This post relates to my previos LOCKING error post
By the kind help of another individual here, he gave me some advise on how
to perhaps resolve a problem with my File Locking issues that I cannot seem
to find a solution for.
My application that is having the problem is installed in a network
environment. The application has been installed, BDE included, on each
workstation and on the SERVER/WORKSTATION, i have Set LOCAL SHARE = .t. on
each stations BDE
This kind fellow tells me that instead I should only have one copy of the
application on the server/station, and on the workstations I should have
nothing more than a shortcut to the EXE on the C drive on the server/station
no BDE components installed what so ever. I have done it this way for
10 years now by installing a separate copy of the application on each
workstation, have I been doing this wrong all these years ??
Now I tried what he said to me and I made some modification to my WIN.INI
per his suggestions, as follows
********************
********************
[visual dbase install]
userName=Eddie Muniz
companyName=Powersof
t Technologies, Inc.
location=Y:\VISUALDB
Runtime55=Y:\IDAPI
[idapi]
dllPath=Y:\IDAPI
configFile01=Y:\IDAP
I\IDAPI.CFG
[Borland Language Drivers]
LDPath=Y:\IDAPI\LANG
DRV
********************
********************
****
The Y drive being the mapped drive both on the SERVER/STATION and on the
WORKSTATIONS..
Is this the better way performance and file handling wise to do this ?
Can someone shed some clear light on how they handle this type of setup
Is there any good KNOWLEDGEBASE Doc that cna help me with this, I
have looked and cannot find anything.
THANKS !!
Eddie Muniz
| |
| *Lysander* 2006-03-17, 3:24 am |
| Eddie Muniz schrieb:
> I have done it this way for
> 10 years now by installing a separate copy of the application on each
> workstation, have I been doing this wrong all these years ??
I have never been doing this differently and never experienced any
problem.
One hint again: with BDE-applications in P2P networks make sure:
The "Server" must be on the newest system. People in the Borland
newsgroups are complaining all the time about various problems when
they have mixed types of systems (ME,98 mixed with XP/2000).
In such scenario, the server must be on the XP-station to assure
correct locking of the tables.
ciao,
André
| |
| Eddie Muniz 2006-03-17, 11:23 am |
| Andre so you do the same as I ? Im not sure I understand you response, you
install BDE and application on all stations ?
The network is all XP Professional machines so that is not an issue.
Eddie
"*Lysander*" <nobody@nowhere.com> wrote in message
news:eOcPs8ZSGHA.1488@news-server...
> Eddie Muniz schrieb:
>
>
> I have never been doing this differently and never experienced any
> problem.
>
> One hint again: with BDE-applications in P2P networks make sure:
> The "Server" must be on the newest system. People in the Borland
> newsgroups are complaining all the time about various problems when they
> have mixed types of systems (ME,98 mixed with XP/2000).
> In such scenario, the server must be on the XP-station to assure correct
> locking of the tables.
>
> ciao,
> André
| |
| *Lysander* 2006-03-17, 1:23 pm |
| Eddie Muniz schrieb:
> Andre so you do the same as I ? Im not sure I understand you response, you
> install BDE and application on all stations ?
Yes,
I have been doing so in times of 5.5 and now for 8 years am doing so
with VdB 7.01
No problems ever.
Right now network with about 40 concurrent users.
ciao,
André
| |
| Eddie Muniz 2006-03-17, 8:23 pm |
| Can anyone else share how they are doing this ?? Or better yet what is the
most efficient way of doing this ??
Eddie
| |
| Eddie Muniz 2006-03-21, 3:25 am |
| I cant imagine no one else here has any additional feedback on this. PLEASE
help guys, I have a serious issue going on need to come up with a solution
relatively fast.
Eddie
| |
| Robert Bravery 2006-03-21, 3:25 am |
| HI Eddie.
I have done it tow ways.
1) App and BDE on workstation. Data on server.
2) App on worstation BDE and data on server
So far I havent had any file locking issues.
But all depends on the server that you have. Is it Novel or NT because they
behave differently.
Also make sure you are not using code that could generate a file lock, which
woul lock everythibng. Also, without seeingt the code, not the code where
the lock occurs, but perhaps somewhere else you locking the record. But this
I mean dbase does automatic locking. if another is editing the record, then
the record or file can be locked.
Couple of things to check
Is the table being used exclusively, in a report, or global replace, any
ctivities that affect the entire table, etc.
Are you using sessions
Check you set lock options,
You might have to set lock off nad then manually control record lockingh
You need to check how your other users are working with the data. OLH
Certain activities do not require an exclusive lock, but do require a lock
on the table that prevents other users from changing the data. If you start
one of these activities, a table lock is applied (this is the level of
locking provided by the dBASE FLOCK() function).
In addition to table-level locking, Visual dBASE applies a record lock to an
individual record as soon as a user types a keystroke or begins any other
activity that will change the record.
Robert
"Eddie Muniz" <eddie0605@bellsouth.net> wrote in message
news:aW4sRjVSGHA.1148@news-server...
> *** Sorry I posted this in getting started by accident ***
>
> This post relates to my previos LOCKING error post
>
> By the kind help of another individual here, he gave me some advise on
how
> to perhaps resolve a problem with my File Locking issues that I cannot
seem
> to find a solution for.
>
> My application that is having the problem is installed in a network
> environment. The application has been installed, BDE included, on each
> workstation and on the SERVER/WORKSTATION, i have Set LOCAL SHARE = .t.
on
> each stations BDE
>
> This kind fellow tells me that instead I should only have one copy of the
> application on the server/station, and on the workstations I should have
> nothing more than a shortcut to the EXE on the C drive on the
server/ station
> no BDE components installed what so ever. I have done it this way for
> 10 years now by installing a separate copy of the application on each
> workstation, have I been doing this wrong all these years ??
>
> Now I tried what he said to me and I made some modification to my WIN.INI
> per his suggestions, as follows
>
> ********************
********************
> [visual dbase install]
> userName=Eddie Muniz
> companyName=Powersof
t Technologies, Inc.
> location=Y:\VISUALDB
> Runtime55=Y:\IDAPI
> [idapi]
> dllPath=Y:\IDAPI
> configFile01=Y:\IDAP
I\IDAPI.CFG
> [Borland Language Drivers]
> LDPath=Y:\IDAPI\LANG
DRV
> ********************
********************
****
>
> The Y drive being the mapped drive both on the SERVER/STATION and on the
> WORKSTATIONS..
>
> Is this the better way performance and file handling wise to do this ?
> Can someone shed some clear light on how they handle this type of setup
> Is there any good KNOWLEDGEBASE Doc that cna help me with this, I
> have looked and cannot find anything.
>
> THANKS !!
>
> Eddie Muniz
>
>
>
| |
| Eddie Muniz 2006-03-21, 11:24 am |
| Robert Thanks for the response.
I am aware of all the things that you mentioned below. The problem is that
Dbase somehow is locking Record number 1 of a particular table, which record
I do not lock manually nor is there any place where editing of that record
occurs.
I am using sessions, I am going to check what I have LOCK set to. That
should be set to TRUE, im not sure I have ever set it or looked at it. I
do manually control RLOCK in the application and unlocks. I use
beginappend() and saverecord(). I am going to try the INI setting and see
how that works, I am also doing some rewriting for the sake of trying
something.
Eddie
"Robert Bravery" <me@u.com> wrote in message
news:heOJh9LTGHA.1152@news-server...
> HI Eddie.
> I have done it tow ways.
> 1) App and BDE on workstation. Data on server.
> 2) App on worstation BDE and data on server
>
> So far I havent had any file locking issues.
> But all depends on the server that you have. Is it Novel or NT because
> they
> behave differently.
> Also make sure you are not using code that could generate a file lock,
> which
> woul lock everythibng. Also, without seeingt the code, not the code where
> the lock occurs, but perhaps somewhere else you locking the record. But
> this
> I mean dbase does automatic locking. if another is editing the record,
> then
> the record or file can be locked.
> Couple of things to check
> Is the table being used exclusively, in a report, or global replace, any
> ctivities that affect the entire table, etc.
> Are you using sessions
> Check you set lock options,
> You might have to set lock off nad then manually control record lockingh
>
> You need to check how your other users are working with the data. OLH
> Certain activities do not require an exclusive lock, but do require a lock
> on the table that prevents other users from changing the data. If you
> start
> one of these activities, a table lock is applied (this is the level of
> locking provided by the dBASE FLOCK() function).
> In addition to table-level locking, Visual dBASE applies a record lock to
> an
> individual record as soon as a user types a keystroke or begins any other
> activity that will change the record.
>
> Robert
>
>
>
> "Eddie Muniz" <eddie0605@bellsouth.net> wrote in message
> news:aW4sRjVSGHA.1148@news-server...
> how
> seem
> on
> server/station
>
>
| |
| Frank J. Polan 2006-03-21, 11:24 am |
| Eddie
I may not have this correct but I seem to recall something like this
happening a long time back. When you open the table, move off the
first record with a next() or goto and then go back to it.
If that's not it I can blame a failing memory <g>
Frank Polan
On Tue, 21 Mar 2006 06:40:11 -0800, "Eddie Muniz"
<eddie0605@bellsouth.net> wrote:
>
>Robert Thanks for the response.
>
>I am aware of all the things that you mentioned below. The problem is that
>Dbase somehow is locking Record number 1 of a particular table, which record
>I do not lock manually nor is there any place where editing of that record
>occurs.
>
>I am using sessions, I am going to check what I have LOCK set to. That
>should be set to TRUE, im not sure I have ever set it or looked at it. I
>do manually control RLOCK in the application and unlocks. I use
>beginappend() and saverecord(). I am going to try the INI setting and see
>how that works, I am also doing some rewriting for the sake of trying
>something.
>
>Eddie
>
>"Robert Bravery" <me@u.com> wrote in message
>news:heOJh9LTGHA.1152@news-server...
>
>
| |
| *Lysander* 2006-03-22, 3:23 am |
| Eddie Muniz schrieb:
> do manually control RLOCK in the application and unlocks. I use
I can again only advise to turn all this OFF and make a test run again.
If the network is XP then probably an UNLOCK does not get executed by
the server (... if the LOCKING/UNLOCKING is done by _old_ applications)
|
|
|
|
|