connect to the sql database

Question

I need to connect to the sql database in unity3d,but can not find the fully information. i hope the company can provide the package,so we can use it.thang you.

Answer 1

Well, the question is still pretty unclear - but here's how to connect to an MS SQL Database:

In the editor and standalones, this approach should be working fine ... I'm not sure if it also works with Web players - but even if it should work, I'd definitely not recommend letting Web players connect to your database (unless you got everything in a local network). I also wouldn't let any clients connect directly to a database unless you have a secure environment.

You need System.Data.dll from the Unity.app folder (I think under Frameworks). Do not use System.Data.dll from any Mono installation (I had very ugly crashes with that, and it took me almost forever to find what the problem was because the crashes occured when closing my game server / closing Unity after I had started the game server inside Unity - so there was no hint that it was the database connection which was causing the crashes).

You need to make sure that the SQL Server listens to TCP connections (not a default setting).

I got this up and running easily with code from the Mono project (modified somewhat, but not toooo significantly):

using System.Data; using System.Data.Sql; using System.Data.SqlClient;

...

... and then, in some method:

using (IDbConnection dbcon = new SqlConnection(connectionString)) { 
    using (IDbCommand dbcmd = dbcon.CreateCommand()) { 
        dbcmd.CommandType = CommandType.StoredProcedure; 
        dbcmd.CommandText = procedureName; 
        foreach (SqlParameter parameter in parameters) { 
            dbcmd.Parameters.Add(parameter); 
        } 
        dbcon.Open(); 
        result = dbcmd.ExecuteScalar(); 
        dbcon.Close(); 
    } 
}

procedureName also could be an SQL statement.

Ah, and I think you can't use the IP-address in the connection string (you need to use a name that can be resolved via DNS). The only parameters I could use in the connection string (I think that's a Mono limitation) are: Database, Server, uid and pwd.

Hope that helps ...

I had a similar posting about this in the forum in MS SQL connection?; other postings regarding this issue on the forums:

Answer 2

Answer by darrelcusey · Nov 24, 2009 at 05:14 AM

...and (2) since I am a new user and can only post 1 link at a time:

2) Use SQLLite directly, as described here:

http://forum.unity3d.com/viewtopic.php?t=30249&start=0&postdays=0&postorder=asc&highlight=

Add comment · Share

Answer 3

Answer by Daniel 15 · Feb 10, 2011 at 11:30 PM

've made a step by step tutorial in javascript here: http://forum.unity3d.com/threads/77447-Starting-my-MMO-with-SQL-SERVER!-in-Javascript

Add comment · Share

Answer 4

Answer by darrelcusey · Nov 24, 2009 at 05:09 AM

There are at least 2 ways that I know of that you can accomplish this:

1) As Duck suggested, go through the WWW class. The full example for this is here:

http://www.unifycommunity.com/wiki/index.php?title=Server_Side_Highscores

Add comment · Share

Answer 5

Answer by duck · Nov 23, 2009 at 01:42 PM

You need to provide more information about this - as it stands, this is a vague question. Is this in a webplayer or standalone application? Is it a local or remote SQL server? What are you trying to achieve more broadly?

For example, to talk to a remote SQL server from a webplayer (for example, to implement a high-score board), you would typically achieve this by having your webplayer use the WWW class to make GET or POST requests to server-side scripts on your webserver. The server-side scripts would then connect locally and perform functions using the values provided by the WWW request.

Add comment · Share

connect to the sql database

8 Replies

Your answer

Welcome to Unity Answers

Follow this Question

Related Questions