Native Btrieve calls are not a relic of days past -- in fact, they
provide an ultra-fast interface directly into a transactional database
that can ALSO be used as a relational database from SQL/ODBC (and ADO).
You should be able to run your old DOS applications directly on any
newer Win32 environment if you are using Pervasive.SQL with no extra
steps.
As for your "new" ADO application -- why are the users creating
databases? The users should be accessing databases created by the
developers and/or database administrator, and they should not be
creating new ones.
Creating a database is an administrative task that does require
administrative rights. As such, even if you used the DTI or DTO
interfaces to create a new database in the envirnment, you would either
need to provide an administrative login inside the application (which
is a security risk), or you'd have to prompt for a login name at the
time the code runs, and users would still need it.
Can you be more specific about your actual versions and provide a
reason why the users need to keep creating new databases?
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach@[EMAIL PROTECTED]
Chicago: Pervasive Service & Sup****t Class - March 2008 ***
Axel Potthoff wrote:
> Hello,
>
> we want to migrate our applications to SQL. Until now we use as a
> relict of DOS times native Btrieve calls.
>
> We work in this way now:
> * LogIn as Administrator
> * Start Pervasive Control-Center
> * create an new database
> * LogOut as Administrator an LogIn as User
> * Work with our application.
>
> This is noch acceptable for our users in two points:
> * They have no Administrator rights.
> * They don't want to be bored with the Controlcenter.
>
> How can we create and use a dateabase at runtime of our Application.
> It can be done easily with Firebird/Interbase by the ZEOS components
> we uses.
> How can we do this with Pervasive.SQL e.g. via ADO protocol.
>
> Axel
--
|
