How to change character job? using SQL QUERY

[ronscript]

Hey guys, I need help how do you properly change character job?

[MentaL]

[raventh1984]

USE CHARACTER_01_DBF
GO
UPDATE CHARACTER_TBL SET m_nJob = 'HERE THE JOB DEFINENUMBER' WHERE m_szName = 'PLAYERS NAME' AND account = 'PLAYERS ACCOUNT'

[ronscript]

Thanks, I have a little question not related to this.

I have set up a game server and web server. On the web server I am using the DSN login,character01 to get data from the database. also LOGIN_STR to login, I have observed that there is a weird happenings. I'm having this error, could this be a database stored procedure related error, or something about the DSN?

Spoiler:

16/12/30 15:31:17
query:LOG_USER_CNT_STR '01', 0, 0
SQLSTATE:08S01 error:[Microsoft][SQL Server Native Client 11.0]TCP Provider: An existing connection was forcibly closed by the remote host.




2016/12/30 15:31:17
query:LOG_USER_CNT_STR '01', 0, 0
SQLSTATE:08S01 error:[Microsoft][SQL Server Native Client 11.0]Communication link failure
2016/12/30 15:31:26
query:uspDeletePropose 1, 1483083077
SQLSTATE:08S01 error:[Microsoft][SQL Server Native Client 11.0]TCP Provider: The semaphore timeout period has expired.




2016/12/30 15:31:26
query:uspDeletePropose 1, 1483083077
SQLSTATE:08S01 error:[Microsoft][SQL Server Native Client 11.0]Communication link failure
2016/12/30 15:31:46
query:MAIL_STR_REALTIME 'S1', '01'
SQLSTATE:08S01 error:[Microsoft][SQL Server Native Client 11.0]TCP Provider: The semaphore timeout period has expired.




2016/12/30 15:31:46
query:MAIL_STR_REALTIME 'S1', '01'
SQLSTATE:08S01 error:[Microsoft][SQL Server Native Client 11.0]Communication link failure
2016/12/30 15:32:01
query:character01
SQLSTATE:08001 error:[Microsoft][SQL Server Native Client 11.0]Named Pipes Provider: Could not open a connection to SQL Server [53].
2016/12/30 15:32:01
query:character01
SQLSTATE:HYT00 error:[Microsoft][SQL Server Native Client 11.0]Login timeout expired

USE CHARACTER_01_DBF
GO
UPDATE CHARACTER_TBL SET m_nJob = 'HERE THE JOB DEFINENUMBER' WHERE m_szName = 'PLAYERS NAME' AND account = 'PLAYERS ACCOUNT'

[raventh1984]

That is because of this

16/12/30 15:31:17
query:LOG_USER_CNT_STR '01', 0, 0
SQLSTATE:08S01 error:[Microsoft][SQL Server Native Client 11.0]TCP Provider: An existing connection was forcibly closed by the remote host.

As you can see the connection was closed by the remote server. So then all things that are releated to the database server will not work.
Since its closed.

[ronscript]

I am using a 1 GM ram of sql server 2008 r2 database with 20GB storage, and a 1 GM ram of application server 2008 also just to run the server. Could this be the reason?

That is because of this

16/12/30 15:31:17
query:LOG_USER_CNT_STR '01', 0, 0
SQLSTATE:08S01 error:[Microsoft][SQL Server Native Client 11.0]TCP Provider: An existing connection was forcibly closed by the remote host.

As you can see the connection was closed by the remote server. So then all things that are releated to the database server will not work.
Since its closed.

[raventh1984]

No i dont know what the problem is.
I only can tell you that the Database server has closed the connection. Its for you to figure it out why it has closed the connection.

So check your Database Server logs. And not the Error.logs but if you log in onto your Server hoster you can see the logs if you have an good hoster.

[ronscript]

HELP the change job query it doesn't work properly.