Unity Editor freeze (698456)

Unity Engine
1

Hi guys, I have an issue with my editor.
I work on a project with SQL management. the problem is:
When i use my local Database there is no problem but as soon as i link my online DB, i can connect it to my game but every time i modify the script when i go back to the editor it freeze. it’s boring cause i have to force unity stop and re-open it every time.

The strange thing is when i work on another SQL project with the same database there is no issues.
do you have any idea or lead i can look to ?
thanks so much.

2

How do you connect to your online database? Please show the connection string.

3

3464232--274886--qsdqsdqsdq.jpg
3464232--274886--qsdqsdqsdq.jpg2100×565 65.4 KB
here it is :

 string cmd = "Server=mysql-*********.alwaysdata.net; Database = ***********; Uid = ******; Pwd = **********;Pooling = true ";

and here the full connection fonction :

4

You might try an IP address instead of the URI. When you say “another SQL project”, do you mean another Unity application? And when you say “Go back to the Editor”, can you elaborate ? Is this for a standalone PC application?

5

I work on two projects in unity ( 2 apps) both on standalone pc.
Both use the same connexion string and the same database.
but on the one i have an issue, everytime i modify the script in visual and i open the editor again the editor freeze.
You know when the editor compile the new script you have in the right bottom corner a litle “loading icon” turning around. well while the compilation running all stop and nothing is working.
otherwise sometimes i have the same problem when i play play then stop and play again, on the second play i active, the editor go in play mode ( darker skin) but the game never run and the editor freeze
How should i connect with the IP adress?

6

As mentioned, use the IP address instead of your URI (server=10.1…)

7

Also, you would want to confirm that it is your DB code that is causing the editor behavior.

8

I’m sorry buti don’t know where to find that IP adress in my DB

9

Ping the URL mysql-*********.alwaysdata.net to get the IP address. When I ping alwaysdata.net, I get 185.31.40.5, so your IP will likely be in that same subnet.

10

Got it thanks! i’ll try it

11

I just change the URL by IP adress and it freeze instant when i go back to the editor

12

Please determine if it is indeed your DB code causing the issue. (remove and test again)