Errors Opening Recordset With "Create User" SQL

[GuntherKS]

I get errors while trying to open a recordset when it has a "create user...." statement in it. The error is: 3704 Operation is not allowed when the object is closed.

The create user statement works, because I have cut it and pasted it into SQL+ and it executes properly. The recordset is open and works because when I substitute a simple select statement it works perfectly, and the data connection is valid and working.

I am using Oracle. Suggestions are apreciated.

Kevin

 

[froggerIII]

does the database user you are using in your application have rights to create a new user? ray
rheindl@bju.edu