Error 13059 (0x3303) general sql error when run as user

toby

unread,

Mar 16, 2004, 9:12:46 AM3/16/04

to

We have a 16 bit app running under Win 2k. As an admin it works no problem at all. If run as a standard user I get "13059 (0x3303) general sql error" error message. It is obviously a permissions related issue but I cannot find which file/folder/dll the users need access to, to allow this to work even using tools such as filemon. Can any one advise ??

Many thanks

Toby

Bill Todd (TeamB)

unread,

Mar 16, 2004, 11:40:02 AM3/16/04

to

It is very difficult to answer database questions when you do not tell
us what database and version you are using.

Try granting read/write access to everything in the BDE directory.

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

toby

unread,

Mar 16, 2004, 11:58:59 AM3/16/04

to

Thanks for the update.

We are using BDE 2.5 connecting using an Alias to a MS SQL Server.

The folder the application is installed in, users have full access to. There are a number of BDE components such as BDECONFIG etc in this folder.

It seems there are files elsewhere (not necessarily installed by BDE) which it uses to establish the ODBC connection but I cannot identify these files.

As an Admin the application works fine with no problems at all.....

Any info would be great

Thanks

Toby

John Herbster

unread,

Mar 16, 2004, 12:16:10 PM3/16/04

to

"Bill Todd (TeamB)" <n...@no.com> wrote

> ...

> Try granting read/write access to everything in the BDE directory.

Bill, Would turning *on* directory auditing help to find
*which* permissions are being denied to the user of the
program? Regards, JohnH

Bill Todd (TeamB)

unread,

Mar 16, 2004, 2:55:28 PM3/16/04

to

On 16 Mar 2004 08:58:59 -0800, "toby" <toby....@sema.co.uk> wrote:

>Any info would be great

AFAIK the only other files are the application files, the ODBC driver
DLL (I do not know the name of the file but it should be easy to find
with Google) and the SQL Server client files. If you can connect with
another application it seems reasonable to assum that the SQL Server
client is not the problem.

Bill Todd (TeamB)

unread,

Mar 16, 2004, 2:56:34 PM3/16/04

to

On Tue, 16 Mar 2004 11:16:10 -0600, "John Herbster"
<herb-sci1_AT_sbcglobal.net> wrote:

>Bill, Would turning *on* directory auditing help to find
>*which* permissions are being denied to the user of the
>program? Regards, JohnH

Very possibly. I do not know much about Windows 2k/XP security so I
can not be of much help.

John Herbster

unread,

Mar 16, 2004, 3:24:35 PM3/16/04

to

"toby" <toby....@sema.co.uk> wrote

> We have a 16 bit app running under Win 2k.
> As an admin it works no problem at all. If run

> as a standard user I get ...

> It is obviously a permissions related issue

Toby, I suggest looking in Win2K Help under
"Auditing" | "Files and Folders" | "Setting up permissions
and auditing". I have used this feature before to discover
attempts to violate file permissions. After you tell it
to log security violation attempts, it will log the
attempts to the Windows Event Log. Regards, JohnH

toby wenham

unread,

Mar 17, 2004, 8:06:48 AM3/17/04

to

Many thanks John

Using this we found that BDE requires the user has access to c:\winnt\system32\redir.exe.

Users did not have access to this file so we added them with read/execute permissions and it works fine.

Thanks once again !!

Toby