mabaomsi

Ok thanks for your great help. I try to use php config.

Aham... but vb.net knows its too. So i think i can create sqlconn.close, so the close property is available here too.

Okay, so need to close all the connections, all the time. Thanks for your great help! Nave a nice day! 😀

Okay, but is really possible to connect to a database from another IP-s in the same time with one "Cpanel" account?

I see, its for my sqlconnection. SQLconn.ClearAllPools. But it isnt maked any changes, i cant connect to my database in the same time with the same account from different IP asresses.

Ok i try it.

Yeah, my code seem like perfectly this. And from this Open/query/Close statement have i really a lot. But all connection with one maba_user. So and this is the error query, the account maba_user dont allow to have more connections from another computers with another IP-s. I think that is the problem.

vb.net (basic) in Visual Studio

Huh,so i need to close all the connection all the time? Or what? 😆😆 But i maked so my script before the error comes, i had 10-20 different connections (but, with the same, admin account, and database), that i forever closed(/conn.). So the essence is, that i can't have more active connections for my database FROM DIFFERENT IP addresses? (Sorry, but dont really understand, how i need to change my scripts...)

Aham, so can I open endless connections? But i dont thik so. When I used ONLY the app, the error didn`t happend, BUT when we (I and my friends, for example) open a "table" / connection in the same time, the error comes... So I cant have more than 2 connections in the same time, with my ONLY, one Cpanel (MySQL accesed) account, for ex. a (primary) "admin" account.

Hi, no, i think no. I open one connection again, when a new action is coming. Like: new command, reader... ("Mysqlconn.open") So, i have more win. forms, in there i open another connnevtions, and when i use a sqlreader, the system saids you have soon opened a reader, you need one another connection to open a new again.

Hi, i'm Balázs form Hungary, and i have a question for YOU ALL! I have a application with a HeliHost MySQL ONLINE database. I created a table in my database for users (username, pass, join date etc...), that can register for my program (in my program). After register, the user become a new line with all the data, which there has entered under the registration (username, pass, join date etc...) in my user database. The users can login in to my program, using this "user". The user enter there username and pass, and if this datas are correct, "READING data from user table", than the user can sucess login. So, the login was sucessfully, the user entered my program. And now it's coming the problem. This program is for it, to have datas (veichles, objects, addons, and for all donwload links etc...) about a simulator game (OMSI 2), and to help the users, finding fastest a component form this simulator game, that he/she wants. So i have more tables, in my ONLINE database. BUT, i use all the time one, my account (admin) to handle, manage, read etc... the database. When MORE (!!!) users, IN THE SAME TIME want to recive, change datas for example: login, account making, searching/looking for component in a table, coming my problem: ..."user already has more than 'max_user_connections' active connections!" So, the problem can be, that i make all the requests with my ONLY one MySQL account: admin? I need to make users in the Cpanel, when a user register in my program, i need to make all the time a new user in my Cpanel too? And when yes, HOW? It is possible to acces Cpnael with vb.net code, form source, like the MySQL databases? Thanks, and a good afternoon for all! Balázs Lengyel Sorry for my REALLY bad english!

Aham, okey. Then, when i use one connection ("for all") then more then tausend of poeopls can see (read) my database in the same time?

OK. Then i need only ONE connection for all commands, and reading?

Hi! But why? I really need it, i have / maked an WinForm applikation, who users can see the components from a simulation game (OMSI2), and the value 1 for max_conn. is nothing, min 10-30 poeople will used my app (i hope) in the same time from one/this database. And this wanna bee really shit, when the another 9-29 users cant connect, becuse one is now seen the database... You understand me? I really need to change it I my app, will all connections closed, when the command is runned sucesfully (f.e: SELECT * FROM blabla WHERE blabblabla = blabblabla) Can you help me, can we solved my problem? Thanks all!