I'm running Win 2k on all boxes. MS SQL 2000 is running on a separate server on the same network. After making the modifications to config.cs per Ceday on page 1 of this thread, I finally got the shard talking to the database. The web portion is working fine as far as I can tell (the player count updates correctly on status.asp), but I'm getting errors when the shard goes to update the character database:
Code:
Scripts: Compiling C# scripts...done (0 errors, 0 warnings)
Scripts: Compiling VB.net scripts...no files found.
Scripts: Verifying...done (1630 items, 451 mobiles)
World: Loading...done (133060 items, 14022 mobiles) (25.2 seconds)
Regions: Loading...done
Address: 127.0.0.1:2593
Address: 10.0.0.81:2593
MyRunUO: Updating status database
MyRunUO: Updating character database
MyRunUO: Status database updated in 7.2 seconds
MyRunUO: Exception caught in database thread
System.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver
][SQL Server]Line 1: Incorrect syntax near 'DATA'.
at System.Data.Odbc.OdbcConnection.HandleError(HandleRef hrHandle, SQL_HANDLE
hType, RETCODE retcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior,
String method)
at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
at Server.Engines.MyRunUO.DatabaseCommandQueue.Thread_Start()
MyRunUO: Database statements compiled in 68.07 seconds
MyRunUO: Characeter database updated in 1.6 seconds
The status table updates properly, but the characters table remains empty. I believe it may be the SQL statement syntax, but that's as far as I can think it through. Any suggestions are welcome.
Thanks in advance,
Mark