Re: Problems with Create User, DROP USER via odbc

#1

Are you using PSQLv9.5? Previous engines required the use of the GRANT
LOGIN and REVOKE LOGIN statements for these operations. Have you tried
those?

See the online manuals for the syntax of these statements if you need
it.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 03/2007 ***

seetickets wrote:

Quote:

Hi All,

We are using the ODBC to connect to Pervasive and we can query our
tables fine, however when we try to do anything with users we get
errors.

For example I can query the users table fine with

SELECT Xu$Name FROM X$User

But if I try to do anything such as

CREATE USER mark WITH PASSWORD test

I get the following errors (these may be specific to the language we
are using: DataFlex)

GENERAL ERROR 07005 Pervas--- <<Status 12289>> #564
GENERAL ERROR HY010 Micros--- <<Status 12289>> #582

And if I do something like

DROP USER mark

I get

GENERAL ERROR 24000 Micros--- <<Status 12289>> #564
GENERAL ERROR HY010 Micros--- <<Status 12289>> #582

I am logging in with the Master user, and I can do these operations
just fine via Pervasive Control Centre.

Does anyone know whats happening here?

Thanks
Glyn

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Problems with Create User, DROP USER via odbc

comp.databases.btrieve comp.databases.btrieve

Re: Problems with Create User, DROP USER via odbc - 11-30-2006 , 12:53 PM