DB connection error (using System.Data)

Questions & Answers
1

Hello everybody! I got a stupid Database error and i need a solution… I can’t connect to any database. The script looks like:

import System;
import System.Data;
import System.Data.SqlClient;


function Start () {
	var dbcon : IDbConnection;
	var connectionString : String =
	    "Server=db4free.net;" +
	    "Database=databasegame24;" +
	    "User ID=xxxxxxxx;" +
	    "Password=xxxxxxxx;";
	dbcon = new SqlConnection(connectionString);
	dbcon.Open();

	var dbcmd : IDbCommand = dbcon .CreateCommand();
	var cmdSql : String = "SELECT level, gold, dolars FROM databasegame24.accounts";
	dbcmd.CommandText = cmdSql;
	var reader : IDataReader = dbcmd.ExecuteReader();

	while(reader .Read()) {
	        var name : String = reader["name"].ToString();
	        print ("Name: " + name);

	    }
	if(name!=""){
		reader .Close();
		reader = null;
		dbcon.Close();
		dbcon = null;
}
}

and what i got:

 SocketException: No connection could be made because the target machine actively refused it.
       System.Net.Sockets.Socket.Connect (System.Net.EndPoint remoteEP, Boolean requireSocketPolicy)
        System.Net.Sockets.Socket+Worker.Connect ()
        Rethrow as TdsInternalException: Server does not exist or connection refused.
        Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32 port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion)
        Mono.Data.Tds.Protocol.Tds..ctor (System.String dataSource, Int32 port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion)
        Mono.Data.Tds.Protocol.Tds70..ctor (System.String server, Int32 port, Int32 packetSize, Int32 timeout, TdsVersion version)
        Mono.Data.Tds.Protocol.Tds80..ctor (System.String server, Int32 port, Int32 packetSize, Int32 timeout)
        Mono.Data.Tds.Protocol.TdsConnectionPoolManager.CreateConnection (Mono.Data.Tds.Protocol.TdsConnectionInfo info)
        Mono.Data.Tds.Protocol.TdsConnectionPool.GetConnection ()
        System.Data.SqlClient.SqlConnection.Open ()
        Rethrow as SqlException: Server does not exist or connection refused.
        System.Data.SqlClient.SqlConnection.Open ()
        cdb.Start () (at Assets/Scripts/cdb.js:14)

What’s the problem? :frowning: I won’t connection with PHP. Is true that connection with System.Data is somehow dangerous for game?

Thanks for anything which help me or not. :slight_smile:

2

SocketException: No connection could be made because the target machine actively refused it.

Normally something in the host machine is blocking up your connection.
Could be: User/Password, Port, IP, Service not running, etc.

Check all these itens.