View Full Version : [Question] Connect to SQL Server to ES5
can any one hlpe me how can connect to SQLserver 2008 thrw ES5 with Unity 3
tcarr
12-01-2010, 11:58 AM
Database connection is done on the server side. I've never tried to connect to SQL server 2008, but it should be similar to the way that the two database examples do it. Yes those are MySQL and embedded Derby. I suggest reading the Java JDBC tutorials (http://download.oracle.com/javase/tutorial/jdbc/index.html) and How to connect Microsoft SQL Server using JDBC (http://www.java-tips.org/other-api-tips/jdbc/how-to-connect-microsoft-sql-server-using-jdbc.html). Info on JDBI is here (http://jdbi.codehaus.org/).
tcarr
12-01-2010, 01:31 PM
Unity 3 is a client. I doubt that it would be connecting to your database directly. What you would do is have a plugin on the ES5 that communicates with the database, that the Unity 3 client can send a PluginRequest to and a get PluginEvent from with the response from the database. Most applications want to restrict most of the database calls to the server side, to protect the database from hackers. Many applications have a user log on to the website first using PHP, before ever connecting to the ES5 (and sometimes before even opening the ES5 application client).
Powered by vBulletin® Version 4.1.6 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.