Can open database on one station only with Runtime

[Jean-P. B�dard]

Good Morning,

I tried to open a database on more than one station, but it did open only on one.I am using RunTime.

On the second station Runtime opens but I cannot open the database.

Should I compact? If so I guess I will have to close another database(clipper) application linked to my A5 application.

If compacting has to be executed on a regular basis, where can I find an Xbasic program to execute it a given time. Let say at nite.

Thanks in advance for your kind replies

JP

[whanigsberg]

RE: Can open database on one station only with Run

J-P:

Just to be clear, which is it?
-you can open it on either station but not both at the same time;
-it opens from one but not from the other.

I assume the runtime is installed on each station and *not* on the server.

The application's folder is mapped the same on both stations.

Somebody will figure out what's wrong. Don't worry about having to compact. That almost certainly has nothing to do with your current hangup.

Bill

[Jean-P. B�dard]

RE: Can open database on one station only with Run

Bill,

Thanks for your reply,

I also have Runtime on the server, should I uninstall it?

To make sure I am using the same path I open the database through the File Open, go to the server directory where the application is stored and select it.

I did not have that problem a few days ago.

As soon as I can close the linked clipper application, I will compact and retry.

Just to make sure I am doing things right, is it better to compact at the server, or from a station? As mentionned before we do not have any information on compacting in the books or on Dr.Wayne site.Do you know where I can find some.

Thanks again

JP

[Tom Cone Jr]

RE: Can open database on one station only with Run

JP,

1) Is it always the same workstation which cannot connect?

0r

2) Is it the always the second workstation to attempt the connection which fails?

-- tom

[Jean-P. B�dard]

RE: Can open database on one station only with Run

Hi Tom,

It was always the same station, but as I said I compacted the database after I close the linked Clipper Application and it works then.

May be it has something to do with indexing!

My application, as I mentionned previously to Bill, is linked different ways to our accounting system where we process the invoices and keep the customer and the suppliers tables up-to-date.

That Clipper application is DOS based and quite large (10 years of transactions). Does DOS based aplication work differently than Windows.?

For now it is working fairly well, some stations are faster than others, but once it is all loaded it works at an acceptable speed.

I will check in the morning if everything is still working OK.

Thanks to both of you for your replies, it is really comforting (I dont know if it is an english word?), you know what I mean...!

Regards

JP

P.S: Does anyone knows of an Xbasic code that will compact the application, let say at nite when nobody is working on the server?

[Tom Cone Jr]

RE: Can open database on one station only with Run

I agree with Bill and do not think compacting your database will solve your problem.

Can you tell us what kind of error message you get when you try to open the database from the workstation that is giving you the trouble?

Can you tell us whether you are logging on to the server and running Alpha Five from there, or whether you are running it from the local workstation?

If this workstation can never open the database, even when the other workstations are not using it, then I'd check your network connections between the workstation and the server. Are you certain the troubled workstation can "see" the server? Does the server permit this workstation to share its resources? i.e. does this workstation have permission to write changes to the server?

-- tom

[tlyon]

RE: Can open database on one station only with Run

This seems reminiscent of a problem I had when I first used network optimization. Being unfamiliar with its inner workings, I inadvertantly allowed one of the work stations to perform a network optimize and overwrite the source database on the server with that workstation's set of optimization files. Everything looked normal, but only that station could open the database from that point on. I was forced to restore from a backup copy. Since then, I have eliminated the chance of a workstation overwriting the source database.

Tom Lyon (seems there are a LOT of Toms around here!)

[Jean-P. B�dard]

RE: Can open database on one station only with Run

Hi Bill and Tom and Tom...

If you read my previous message, I have compact my database and it works now.

May be I am not doing things the way it should. Here is what I do to optimize from any workstation.

In order to make sure I using the right path to my application, here is how I do it by steps:

From a workstation
1-I open Runtime
2-I open my application using
-file
-open database
-select the server
-open the application "serveur_acmegestiondatabase
for registre"
3-Select Table/set tab from the control panel
4-Select file
5-Select Network optimize
6-Replace the existing Shawdow database with the new one

Is it the right way to do it???

In the server directory where my application is stored, I also have some files that seems to be duplicates such as:

Database(1) for registre .muf 0Ko
Database(1) for registre alpha five database 5Ko
Database(1) for registre .alb 1Ko
Database(1) for registre .alm 1Ko
Database(1) for registre.alx .alx 3Ko

and this repeats for(2),(3),(4), and for some other tables too.

I do not know where these come from.May be because I have opened the table independently from the database.

Concerning the problem it was on the second station I was trying to open, not always on the same one.

Thanks again for the time you take to help me. I appreciate it.

JP

[Dan Blank]

RE: Can open database on one station only with Run

Hi:

When you start your app you should be starting from the shadowed version already on your workstation.

On your C drive you have the following path (where "|" is the slash)

C:|Program Files|A5v4_Runtime|Shadow|"Folder Name"|"Your App Name".ADB

Your App Name.ADB is what you double click on to start your app and start Runtime. Better yet Right click and create a short cut to put on your desktop. Then you doubleclick on the icon, start Runtime with your app starting.

Doing this will eliminate re-Network Optimizing and allow the runtime to run on other workstations.

Hope this helps:
Dan

[Jean-P. B�dard]

RE: Can open database on one station only with Run

Dan,

I will follow your wise suggestion, and it will make things easier for everyones on the network.

Thanks for taking the time to reply.

Regards

JP