Downloading from database

#21 Then tell adam to post using his account with the license, proving hes adam. So we may see that he does infact have a license.

#22 To Stefan, Rod and Chirs.
first of all, the post (under adam's name was make by me, i was using his computer that day)
secondly, adam has his a license(believe it or not). anyway he is doing avartar modeling(nothing to do with torque)
lastly, and most importantly, i am here to look for help and not debating about whether adam has a license or not. so stop ask about it. i really need help in link torque to my database.

chunwei

#23 Have you added ODBC32.lib and ODBCCP32.lib to the project settings, under the linker section in additional Dependencies? You shouldn't have to add ODBC32.lib and ODBCCP32.lib to any .cc files, as far as i remember

Daniel

#24 Daniel, i got the compiling done. but when i run the game the following error appear.

DatabaseConnection::Execute - SQLExec direct failed

starter.fps/server/scripts/dbTest.cs (0): Unable to find object: '0' attempting to call function 'nextRow'

starter.fps/server/scripts/dbTest.cs (0): Unable to find object: '0' attempting to call function 'commit'

do u know what happen?

and for the two line below
$error = $db.connect("SQL Server", "SERVER=servername; UID=username;PWD=password;");

$results = $db.execute("SELECT * FROM Test");

i have a few question:
(1)username is the database-username or the server-username?
(2)password is the password-username or the password-username?
(3)"Test" is the name of the database?

thk ur all ur help!

chunwei(tp student)

#25 1 and 2) The login information is the username and password you setup when you installed MsSql, for example:

$error = $db.connect("SQL Server", "SERVER=danielsSQLServer; UID=daniel;PWD=APassword;");

SERVER is the network name of the computer, on which MsSql is installed.

3) Not to be rude but it seems you don't know much SQL, the best thing to do is search the net and get a begginners book on SQL, as its too vast of a subject to cover here!! But the 2 commands you need to execute when starting is:

$results = $db.execute("USE torque");

Torque being the name of the database your using, the use command tells the server which database you are looking in, as you can have multiple databases at one time.

$results = $db.execute("SELECT * FROM userInfo");

userinfo is the name of the table in the database called torque. The * means you want to get all the columns in that table for every row. If you just wanted to select the strength for the player named cuddlyBunny, you would use the command.

$results = $db.execute("SELECT strength FROM userInfo WHERE username = 'cuddlyBunny'");

Hope that makes some sense, like I said its best if you get a book on it.

Daniel

#26 Thanks daniel, but i am still not very sure. do you mean that for line:

$error = $db.connect("SQL Server", "SERVER=danielsSQLServer; UID=daniel;PWD=APassword;");

all the information i should enter is for the server and not the database?

chunwei

#27 Daniel sorry, i got the wrong .cc and .h fileslast time.
i used the correct ones this time and got the following error:

DatabaseConnection::Connect - SQLDriverConnect failed
Got error 0 trying to connect to database

do u know what wrong?

btw, i dun really know anything about sql. trying to learn as i do.
could u recommend any book?

chunwei

#28 Hello. anyone still there?i run the dbtest.cs as follow:

{
	$db = new DatabaseConnection();
$error = $db.connect("SQL Server", "SERVER=SVR1;UID=torque;PWD=torque;");
if ($error != 1)
{
	echo("got error");
	echo("Got error " @ $error @ " trying to connect to database");
}
else
{
	echo("start execute");
	$results = $db.execute("USE torque");
	echo("done first execute");
	$results = $db.execute("SELECT * FROM User");
	echo("done second execute");

	echo($results.testCol1);
	echo($results.testCol2);
	echo($results.testCol3);
	echo($results.testCol4);

	$results.nextRow();
	echo($results.testCol1);
	echo($results.testCol2);
	echo($results.testCol3);
	echo($results.testCol4);

	$results.testCol1 = "it works";
	$results.commit();
}

and got the following error:
Loading compiled script starter.fps/server/scripts/dbTest.cs.
start execute
done first execute
DatabaseConnection::Execute - SQLExec direct failed
done second execute

starter.fps/server/scripts/dbTest.cs (0): Unable to find object: '0' attempting to call function 'nextRow'

starter.fps/server/scripts/dbTest.cs (0): Unable to find object: '0' attempting to call function 'commit'

i know that it cannot connect to my table name "user". anyone has any idea wat i can do?

chunwei

#29 Use code brackets, makes your post alot easier to read.

#30 Um, the eula for torque specifically states that code like this cannot be posted in this forum... it must be in the private SDK Forum...

#31 Isn't that just for source? I thought script was ok?

#32 Read the EULA again Vince, you're not correct.

Edit: It is however recommended and preferred that anything that has to do with Torque is posted in the Torque section.