Wayback Machinekoobas.hobune.stream
May JUN Jul
Previous capture 13 Next capture
2021 2022 2023
1 capture
13 Jun 22 - 13 Jun 22
sparklines
Close Help
  • Products
  • Solutions
  • Made with Unity
  • Learning
  • Support & Services
  • Community
  • Asset Store
  • Get Unity

UNITY ACCOUNT

You need a Unity Account to shop in the Online and Asset Stores, participate in the Unity Community and manage your license portfolio. Login Create account
  • Blog
  • Forums
  • Answers
  • Evangelists
  • User Groups
  • Beta Program
  • Advisory Panel

Navigation

  • Home
  • Products
  • Solutions
  • Made with Unity
  • Learning
  • Support & Services
  • Community
    • Blog
    • Forums
    • Answers
    • Evangelists
    • User Groups
    • Beta Program
    • Advisory Panel

Unity account

You need a Unity Account to shop in the Online and Asset Stores, participate in the Unity Community and manage your license portfolio. Login Create account

Language

  • Chinese
  • Spanish
  • Japanese
  • Korean
  • Portuguese
  • Ask a question
  • Spaces
    • Default
    • Help Room
    • META
    • Moderators
    • Topics
    • Questions
    • Users
    • Badges
  • Home /
avatar image
0
Question by fadihasrouni · Aug 04, 2014 at 04:17 AM · databaseconnectionsqldatabase

cannot connect unity to sql server 2012

Hello,

I am now to unity and i wan to make sql server 2012 connection. So i installed the sql server 2012 and made a successful connection using C# in a windows form application.

So I made some researches to make it in unity, and i got the following Code:

 // Connect to database
     public   void openSqlConnection() {
         Debug.Log("Connecting to database...");
         string connectionString = "Server=127.0.0.1;" +
                         "Port=1433;" +
                         "Database=mydatabase;" +
                         "User ID=userId;" +
                         "Password=mypass;" +
                         "Pooling=False;";
                         
                  
                          
         dbConnection = new MySqlConnection(connectionstring);
         dbConnection.Open();
         Debug.Log("Connected to database.");
     }

When i call this function to open the connection i get this error :

 Exception: Exception of type 'System.Exception' was thrown.
 MySql.Data.MySqlClient.NativeDriver.Open ()
 Rethrow as MySqlException: Unable to connect to any of the specified MySQL hosts.
 MySql.Data.MySqlClient.NativeDriver.Open ()
 MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings)

The problem is that the connection using a windows form application is successful but using c# in unity isn't.

So help me please!! thanks!

Comment
Add comment · Show 1
10 |3000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image fadihasrouni · Aug 04, 2014 at 09:36 AM 0
Share

Thanks i figured it out!! I used dbConnection = new SqlConnection(connectionstring);

ins$$anonymous$$d of

dbConnection = new $$anonymous$$ySqlConnection(connectionstring);

0 Replies

· Add your reply
  • Sort: 

Your answer

Hint: You can notify a user about this post by typing @username

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this Question

Answers Answers and Comments

2 People are following this question.

avatar image avatar image

Related Questions

Sql Server Compact 4.0 error 2 Answers

Unity and database 1 Answer

A node in a childnode? 1 Answer

How to integrate SQL database in game? 1 Answer

SqlConnection Error con.Open() 0 Answers


Enterprise
Social Q&A

Social
Subscribe on YouTube social-youtube Follow on LinkedIn social-linkedin Follow on Twitter social-twitter Follow on Facebook social-facebook Follow on Instagram social-instagram

Footer

  • Purchase
    • Products
    • Subscription
    • Asset Store
    • Unity Gear
    • Resellers
  • Education
    • Students
    • Educators
    • Certification
    • Learn
    • Center of Excellence
  • Download
    • Unity
    • Beta Program
  • Unity Labs
    • Labs
    • Publications
  • Resources
    • Learn platform
    • Community
    • Documentation
    • Unity QA
    • FAQ
    • Services Status
    • Connect
  • About Unity
    • About Us
    • Blog
    • Events
    • Careers
    • Contact
    • Press
    • Partners
    • Affiliates
    • Security
Copyright © 2020 Unity Technologies
  • Legal
  • Privacy Policy
  • Cookies
  • Do Not Sell My Personal Information
  • Cookies Settings
"Unity", Unity logos, and other Unity trademarks are trademarks or registered trademarks of Unity Technologies or its affiliates in the U.S. and elsewhere (more info here). Other names or brands are trademarks of their respective owners.
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Default
  • Help Room
  • META
  • Moderators
  • Explore
  • Topics
  • Questions
  • Users
  • Badges