Common Errors

Common Errors

Prob. 1
Quote:
-------error--------
Service Provider:FEYA TAIWAN
CreateIoCompletionPort OK
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
User DB Open OK
ERROR:SQLConnect Failed
ERROR:Game DB Open Error
== Please wait until server stop
== Update Thread stopped.
== Client Manager closed
== Message Manager closed
== Database Manager closed
================================================== =====
Server Stop OK
================================================== =====
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
ERROR:SQLConnect Failed
ERROR:Game DB Open Error

Read here to solve this.
ODBC Setup

Your MSQL Server should be running first.

Setting ODBC:

Click Start Menu -> open Control Panel -> open Administrative Tools -> open Data Sources (ODBC)

Follow this:

On your OBDC Window Click ADD





On your MS SQL Server DSN Configuration

On your Create New Data Resources
- Scroll Down and Click SQL Native Client
- Click Finish



Name: RanGame1
Description : (anything)
Server: (name of your Server ex. STATION2\SQLEXPRESS)

How should SQL Verify....
- Select With SQL Server authentication

You Login ID: sa
Your Pass: 1234
- Click Next

Check Change the Default database to
- Select RanGame1
- Click Next

Test Data Source
- Click Finish
Just repeat the Process for:

-RanLog
-RanUser
-RanShop

SQL Manager: GM Account Setup







But first.. delete GMCharEdit.cfg

Run your GMCharEdit.exe

First field : RanUser
Second field : sa
Third field : 1234
Fourth field : 1234

Prob. 2
Quote:
Service Provider:FEYA TAIWAN
ERROR:MaxChannelUser X ServerChannelNumber = MaxClient
== Please wait until server stop
== Update Thread end
== Client Manager closed
== Message Manager closed
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
== Database Manager closed OK
================================================== =====
Server Stop OK
================================================== =====
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
ERROR:MaxChannelUser X ServerChannelNumber = MaxClient

1. Set it by default in your Agentserver.cfg / server.cfg

server_max_client 500
server_max_channel_client 500

Prob. 3


Ok for you to resolve this problem... go to your sql - enterprise manager - select rangame1 database - then tables - select chainfo - then right click - open table - return all rows - then look for ChaGuSecede - change this dates into this one "1/1/1970 8:00:00 AM"

rihom wrote:

Common Errors

Prob. 1
Quote:
-------error--------
Service Provider:FEYA TAIWAN
CreateIoCompletionPort OK
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
User DB Open OK
ERROR:SQLConnect Failed
ERROR:Game DB Open Error
== Please wait until server stop
== Update Thread stopped.
== Client Manager closed
== Message Manager closed
== Database Manager closed
================================================== =====
Server Stop OK
================================================== =====
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
ERROR:SQLConnect Failed
ERROR:Game DB Open Error

Read here to solve this.
ODBC Setup

Your MSQL Server should be running first.

Setting ODBC:

Click Start Menu -> open Control Panel -> open Administrative Tools -> open Data Sources (ODBC)

Follow this:

On your OBDC Window Click ADD





On your MS SQL Server DSN Configuration

On your Create New Data Resources
- Scroll Down and Click SQL Native Client
- Click Finish



Name: RanGame1
Description : (anything)
Server: (name of your Server ex. STATION2\SQLEXPRESS)

How should SQL Verify....
- Select With SQL Server authentication

You Login ID: sa
Your Pass: 1234
- Click Next

Check Change the Default database to
- Select RanGame1
- Click Next

Test Data Source
- Click Finish
Just repeat the Process for:

-RanLog
-RanUser
-RanShop

SQL Manager: GM Account Setup







But first.. delete GMCharEdit.cfg

Run your GMCharEdit.exe

First field : RanUser
Second field : sa
Third field : 1234
Fourth field : 1234

Prob. 2
Quote:
Service Provider:FEYA TAIWAN
ERROR:MaxChannelUser X ServerChannelNumber = MaxClient
== Please wait until server stop
== Update Thread end
== Client Manager closed
== Message Manager closed
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
== Database Manager closed OK
================================================== =====
Server Stop OK
================================================== =====
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
ERROR:MaxChannelUser X ServerChannelNumber = MaxClient

1. Set it by default in your Agentserver.cfg / server.cfg

server_max_client 500
server_max_channel_client 500

Prob. 3


Ok for you to resolve this problem... go to your sql - enterprise manager - select rangame1 database - then tables - select chainfo - then right click - open table - return all rows - then look for ChaGuSecede - change this dates into this one "1/1/1970 8:00:00 AM"

thanks this is the problem i encounter

kainis ung prob 3 ung error server di naman binigay ung step by step procedure paki linaw po ung error sa mga channel kasi ung given dun sa taas ok naman sa akin i think ung channel error iba p ung gagawin para complete channels