Re: Pervasive SQL Help

Hi Glyn,

You're right, this is pretty obscure, but let's try a couple things.

Security is implemented on a database-by-database basis, so removing
security would be as well. Since the PCC is failing, I think that the
reason that you have to log in to some databases and not to others is
because PCC started failing part way through your process of removing
security from the databases.

I think that fixing the PCC will allow you to finish removing security.
Before I suggest anything, I have to ask, does PCC behave this way on
all the workstations you run it from?

seetickets ha scritto:

Hi Wayne,

Post titled Pervasive SQL 9.5 Security Problems, the original post is
below. I'll take note about the Java errors probably being misleading.

Thanks
Glyn


---------------
Hi people,

We are currently in the process of setting up pervasive sql v9.5 on
Netware 5.1, we tried to set up security in the form of a Master user &
password using Pervasive control centre, we then however disabled it.

Now when we try to access some of our databases we need to login as
Master and for some others we do not.

When we try to go to the properties for one of the databases in the
Control centre, and go to security there is nothing displayed, ant
theres a java log saying that some of the widgets could not be created
(I guess because the configuration file it is trying to read is
corrupt?). If we then try to save anything we get the following error:

"Could not accept changes - the currently displayed page contains
invalid values"


Any ideas on what my be causing this?

Thanks in advance

Wayne wrote:
You're absolutely right. I looked up "went tits up" in the PSQL Status
Code list and even in the Pervasive Knowledge Base and couldn't find
any references to it anywhere.

At any rate, I think you're looking at two different issues. If you'd
describe exactly what your security symptoms are, I or someone else
here might be able to help out. Really.

As for the PCC errors, it sounds to me as if the JRE might be corrupt
or the PCC needs to be reinstalled. Thankfully, only the PCC uses
Java, not the Pervasive Microkernel Engine or the Relational Engine, so
the PCC errors are probably a red herring.

What errors is PCC throwing up?

As for why use Pervasive.SQL? Well, from 2000 to 2004 I was the PSQL
"DBA" for a retail chain with 350+ stores, each of which had a PSQL
v2000i server managing a 1.5 gb store database with 3 - 15 users.
Administering them all took probably .1% (that's point 1 percent) of my
time. If that. Try that with MSSQL. Oh, and I've been gone two years
now and they're still running all of that and they haven't had to
replace me.

Wayne
Analytica Business Systems
A Pervasive Software Premier Partner
www.analyticabiz.com

seetickets wrote:
From my experience so far, people selling Pervasive SQL seem to know
everything about it until they have sold it to you, then they suddenly
know squat.

The security went tits up on one of our databases in version of v9.5
for Novell and pervasive control centre just kept throwing up errors as
if some sort of configuration file had got corrupted (the Java log had
loads of null pointer exceptions in it, so I assume something is
failing to get set on loading the data).

With absolutely no information about the workings of PSQL we are having
trouble tracking down the source of the fault.

It's not as if we can go and get a book and read up on pervasive
either, there are none, and I've failed to locate any consultants in
the UK.

So why go with Pervasive when you have the choice of switching to
something that has tons and tons of good documentation, like MySQL or
infact anything other than PSQL?

If anyone has any direction for us (sorry to take the focus of the
problem in hand here) let me know.

Wayne wrote:
Hi Samson,

If the new project is intended to use data from the existing PSQL ERP
database, then I would strongly recommend staying with Pervasive.SQL.

I would recommend upgrading to version 9, primarily to gain a higher
level of SQL compliance, but also to gain access to better tools and
greater SQL performance than you get with v2000i. Here's a link to a
summary of why you might want to upgrade:
http://www.analyticabiz.com/psqlv9sp2partner.php

You haven't mentioned what your development platform is going to be
(Linux/Apache/PHP, .NET, Java) but it doesn't matter really.
Pervasive.SQL is cross-platform (Windows, Linux, Netware) and is
accessible by all access methods, including ADO, ADOdb and JDBC, just
to name a few.

If you are intending to expose the data to the internet rather than
just to an intranet, you'll need to purchase an internet license. It
doesn't sound like you intend to do that, though.

In short, PSQL will serve your needs perfectly well, and will save you
the conversion costs of going to MSSQL.

Having said all that, if the project is not intended to use the
existing database, your options are more open. While PSQL would still
serve the new project's needs just fine, the advantages of using it
specifically for this project diminish, along these lines: If the new
database is going to reside on the current server, then it would be
better to stay with PSQL; if the new database will reside on a new,
dedicated server, then PSQL, MSSQL, MySQL or PostgreSQL would do
probably equally well, depending, again, on your platform. All of the
above would work on Linux, for example, except for MSSQL.

HTH.

Wayne
Analytica Business Systems, Inc.
A Premier Pervasive Partner

To subscribe to our Pervasive news feed:
www.analyticabiz.com/rss20.php

Samson wrote:
Hi All,

Thanks in advance for the help.

We are considering a new Project. This project is going to be totally
web based.

Currently my company is using Pervasive SQL 2000i for there ERP needs.
Will the existing Pervasive SQL 2000i itself serve the purpose OR
should I consider moving to MS SQL Server.

Do assist me in terms of development also i.e. Is it easier to code
with Pervasive SQL 2000i or with MS SQL Server.

Regards
Samson

.

Relevant Pages

  • Re: Pervasive SQL Help
    ... Post titled Pervasive SQL 9.5 Security Problems, ... I'll take note about the Java errors probably being misleading. ... we tried to set up security in the form of a Master user & ... "DBA" for a retail chain with 350+ stores, each of which had a PSQL ...
    (comp.databases.btrieve)
  • Pervasive SQL 9.5 Security problems
    ... We are currently in the process of setting up pervasive sql v9.5 on ... we tried to set up security in the form of a Master user & ... Now when we try to access some of our databases we need to login as ... Master and for some others we do not. ...
    (comp.databases.btrieve)
  • Re: How to remove Security from Access 2002
    ... Just back in the office today, your advice worked perfectly, thanks very ... databases, and vba but not much more advanced than that. ... "Joan Wild" wrote: ... Open Access and go to Tools, Security, Workgroup ...
    (microsoft.public.access.security)
  • Re: How to remove Security from Access 2002
    ... However, since you are joined by default to your secure mdw, that is what ... set up on my home MS Access databases so this one should be ... Open Access and go to Tools, Security, Workgroup ... Rejoin the standard system.mdw workgroup file. ...
    (microsoft.public.access.security)
  • Re: Job Appraisal database setup
    ... Security from hackers and other ill intentioned people. ... "ngan" wrote: ... The simplicity vs. sophistication question at each level of use is always a ... person) technical companies for 26 years (getting deeper in on databases is ...
    (microsoft.public.access.tablesdbdesign)