the session server telling me this
Service Provider:CHINA
CreateIoCompletionPort OK
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
ERROR:SQLConnect Failed
ERROR:User db open failed
== Please wait until server stop
Stop IOCP
Stop Message Queue
Stop DataBase
Stop CFG
=======================================================
Server Stop OK
=======================================================
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
because you input the wrong password in the config filesOriginally Posted by Choy
then ccan you help me cause im really having some big problems??
my ym is rockista80@yahoo.com
check ur configuration..
yup u need to configured ur odbc settings....
here follow this steps:
start >>control panel>>data source(odbc)click>>system DSN>>add, then scroll down choose SQL NATIVECLIENT click finish>>>
put the ff. info:
name: rangame1
description: u can leave it blank
server: ur sqlserver name
click next
choose between thetwo
>>>w/ integrated windows authetication (if u used default installtion of ur sql servermanagemenet studio
or
>>>w/ sql server authentication using a login id and password
(this implies on mixed mode)
login id: sa
password: ur password if u change the default(1234)
click next
change the default database to:
rangame1
click next
click finsih
the click TEST DATA SOURCE(it will display result if ur connection is successful or not) if successful click ok, then do it again on ranshop, ranlog and ranuser.. and if not double check ur settings....
tanx me if i help...
Last edited by rob_angel23; 13-08-10 at 05:54 AM. Reason: guide on setting up odbc(how to fixed error on sql connect and db open when running the server)
Reply With Quote