Script and user

Zero-G. · Post by **Zero-G.** » Fri 26 Nov 2010 10:59

Hey

Using your latest DotConnect for MySQL Product in VB.NET 2010
I have created a user, which is allowed to change fields, SP's, Triggers,... in the database. With property = Max User Connections = 1
In my VB.NET project I have inserted a SQL File and this file is used with the Script Component of your tools.
The script itself runs without any problems, but when running the script a second time, then I get an error. After researching for the problem, I found out that the problem is, that in the Server Process the User is not killed. - When I kill the process by hand, then everything works fine.

Please give me some advise for this "bug"?
THX

Shalex · Post by **Shalex** » Mon 29 Nov 2010 12:51

As I understood, you have created an Oracle user which has a profile like:

Code: Select all

CREATE PROFILE Test_Profile LIMIT SESSIONS_PER_USER 1;

And for some reason you are getting ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit. Is it correct?
I cannot reproduce the problem with the following code:

Code: Select all

        Dim conn As New OracleConnection("server=orcl1120;uid=user_of_Test_Profile;pwd=***;")
        conn.Open()
        Dim script As New OracleScript()
        script.Connection = conn
        script.ScriptText = "select 1 from dual;"
        script.Execute()
        ' and executing again
        script.Execute()
        conn.Close()

Please give us the following info:
1) the version of your dotConnect for Oracle (x.xx.xxx);
2) the version of your Oracle Server (xx.x.x.x);
3) the mode you are using provider in (Direct or OCI). If OCI, also tell us the version of your Oracle Client;
4) have you tried enabling/disabling pooling? Does it make any difference?
5) modify the above code or send us your own small sample to reproduce the issue in our environment (also include DDL for your user and its profile).

Zero-G. · Post by **Zero-G.** » Mon 29 Nov 2010 13:33

Hey

I don't use Oracle Client - I use mySQL!
Please take a look again - THX

Shalex · Post by **Shalex** » Mon 29 Nov 2010 16:55

I have created an user in MySQL v 5.1.40:

Code: Select all

CREATE USER 'shalex'@'%';
GRANT USAGE ON *.* TO 'shalex'@'%' WITH MAX_USER_CONNECTIONS 1;

And then executed code from my above post (changed Oracle --> MySql) with dotConnect for MySQL v 6.0.46. It works.
Give us the following information:
1) the exact versions of your MySQL Server (x.x.xx) and dotConnect for MySQL (x.x.xx);
2) modify the above code or send us your own small sample to reproduce the issue in our environment (also include DDL for your user and necessary database objects).

Sorry for my previous post.