db error?

smoochy boys on tour

troop

LOMCN Veteran
Veteran
Nov 28, 2003
304
1
64
can sum1 plz hlp me wiv this?
ive tried changing everything 2 make this work but i cant find where the problem is.
here is the error.

dbserver...

gate connected
gate disconnected
gate connected
gate disconnected
gate connected
gate disconnected
gate connected
gate disconnected
gate connected
gate disconnected

m2server...

Loaded client version information and server table...
Loading StdItem.DB...
[10/02/2008 09:35:50] StartTimer exception: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied
[10/02/2008 09:36:49] -- --> Error Keeping Query Alive!
[10/02/2008 09:37:22] -- --> Error Keeping QueryCommand Alive!
[10/02/2008 09:37:56] -- --> Error Keeping charQuery Alive!
[10/02/2008 09:38:29] -- --> Error Keeping charQueryCommand Alive!

plzzzz help.

thnx a lot in advance
 

Elvin

Golden Oldie
Golden Oldie
May 14, 2003
1,155
1
195
middlesex
heres a Clue to your problem= [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied

you havent made the 2 inis correct or your trying to connect to a DB that u added to sql which isn t the same name as that to which dbsrc and !setup.txt are looking for
 
Upvote 0

troop

LOMCN Veteran
Veteran
Nov 28, 2003
304
1
64
ive tried changing it all but still same problem.

the dbsrvr dont connect 4 sum reason. is there anything else that could b causing it?
 
Upvote 0

Elvin

Golden Oldie
Golden Oldie
May 14, 2003
1,155
1
195
middlesex
this is just the dbsrc u'll need to check what !setup says especially if ur using 2 seperate dbs like the char_db and the other one from the files
[SQL]
SQLType=mssql are u using sql if so this should read MSSQL
SQLHost=(local) or localhost or 127.0.0.1
SQLPort=3306
SQLDatabase=Mir2 this needs to be the same as the db name in sql
SQLUsername=sa your sql mixedmode username
SQLPassword=sa your mixedmode sql password
 
Upvote 0