Delphi Apps And Novell Netware 
Author Message
 Delphi Apps And Novell Netware

Hello!

A Delphi application using paradox tables should run in a Netware
environment. How does Delphi (the application) react when accessing
the database? What's to do for correct installation? How to detect
which user uses a table? Or which users are logged in? Where to
install usually the BDE, the database and the EXE? What to do to make
my app a mulit-user-app?

Yours
Frank



Sun, 21 Feb 1999 03:00:00 GMT
 Delphi Apps And Novell Netware

Hello!

A Delphi application using paradox tables should run in a Netware
environment. How does Delphi (the application) react when accessing
the database? What's to do for correct installation? How to detect
which user uses a table? Or which users are logged in? Where to
install usually the BDE, the database and the EXE? What to do to make
my app a mulit-user-app?

Yours
Frank



Sun, 21 Feb 1999 03:00:00 GMT
 Delphi Apps And Novell Netware



Quote:
> Hello!

> A Delphi application using paradox tables should run in a Netware
> environment. How does Delphi (the application) react when accessing
> the database? What's to do for correct installation? How to detect
> which user uses a table? Or which users are logged in? Where to
> install usually the BDE, the database and the EXE? What to do to make
> my app a mulit-user-app?

Here's what I do in Delphi 1.02.  

In my applications, I explicitly use a TDatabase component on my main
form with it's connect property set to false at application startup.  All
tables and query objects point to this TDatabase object.

I store the network data path in an external ini file and then on
startup, read this path name and open the database connection and all
tables with something like the following:

...
MyDatabase.Params.Clear;
MyDatabase.Params.Add('path='+RetrievedPath);
MyDatabase.Open;
Table1.Open;
Table2.Open;
...

Then to install, copy the program files to the new user's machine.  
Install the BDE.  
Create a data directory on the network server machine and copy all tables
to the new directory and note the path in the ini file.  
Run BDECFG and select Paradox Driver and change the directory path entry
to point to the newly created data directory.  
Run the program.
--

|| Vice-President,         Real Estate Software Concepts, Inc. ||
||   "What a good thing Adam had - when he said a good thing,  ||
||    he knew nobody had said it before."  -- Mark Twain       ||
[]================= http://www.america.net/~mlang/mlang.html ==[]



Sun, 21 Feb 1999 03:00:00 GMT
 Delphi Apps And Novell Netware

Quote:

>A Delphi application using paradox tables should run in a Netware
>environment. How does Delphi (the application) react when accessing
>the database? What's to do for correct installation? How to detect
>which user uses a table? Or which users are logged in? Where to
>install usually the BDE, the database and the EXE? What to do to make
>my app a mulit-user-app?

You could conceivably just leave your app as is and it would act
multi-user (try running several instances of your application on the
same machine and updating records, you will see the record locking
occur), just make sure your TTables are open with the "Exclusive" set
to False. You could also add business rules and advanced locking to
your table by using event handlers on the TTables like the
"BeforePost" and "BeforeInsert".

If you are using Delphi 2, you also enjoy the benefit of the
DataModules, which are basically hidden forms that contain all your
tables. You can access your tables on the datamodule like regular
tables on all your forms (there is also a shareware component that
does this in Delphi 1 called DataSorcerer). That way you can reuse the
same datamodule in several application by several people, and the
business/locking rules would remain the same (great way of setting
data-access standards in your company!).

To know netware-specific things (which user uses a table and the
such), you need to add a Novell library to your Delphi arsenal. There
are several good ones like NWLib and NovLib. Just be aware that, to
know which users are using a table (or any file) on a Novell server,
you need supervisor rights, so you might want to take another approach
(maybe a user database). A Novell library will allow you to see which
users are logged in,

For the BDE, you have two choices: you can install the BDE on each
client (speed), or you can leave the BDE DLLs on the server, and just
modify the .ini files on the clients. The exe is always better to
install it on the server (I think), since you will change that as you
improve the software.

Let me know if you have any further questions

Hope this helps,

David Martinez



Mon, 22 Feb 1999 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Connection Oracle7.2 Novell Netware and Delphi 1.0 C/S

2. Delphi/Paradox app on a NT netware

3. share a paradox file between a delphi app and another app

4. Windows Authentication in Novell Netware Environment?

5. PERL DBI and Novell Netware

6. Problem accessing ( .mdb ) files on Novell Netware Server 3.12 , using DAO from VB 5.0

7. SQL Server super slow when Novell Client For Netware is installed on client PC

8. OLAP Services Authentication and Novell Netware

9. Novell Netware Password

10. Locking records with D2 & Novell Netware

11. SQL Server super slow when Novell Client For Netware is installed on client PC

12. replicate sql2000 to access2002 on novell netware box.


 
Powered by phpBB® Forum Software