Help pls

06/27/2010 21:26 tzuasd#1
how an i fix error.
[Only registered and activated users can see links. Click Here To Register...]
Microsoft OLE DB Provider for SQL Server: Syntax error converting datetime form character string.

When i try to create a character i get a unnamed error!
06/27/2010 22:02 pieter#2
search for FN_BinDateToStr on the forums, no one will be explaining this again since it's asked 3 times in a day...
06/28/2010 02:19 daddycool.#3
A little correction. The name of the function is FN_BinDateToDateTime, anyway look at this thread [Only registered and activated users can see links. Click Here To Register...]
06/29/2010 18:24 tzuasd#4
i dont know how to insert it
06/29/2010 18:29 daddycool.#5
Just open the MSSQL Query Analyzer, copy and paste
the code and press Run (F5).
06/29/2010 18:34 pavkaspr#6
dont work i have same error please help me too
06/29/2010 19:11 tzuasd#7
work but even i get a error when creating character
[Only registered and activated users can see links. Click Here To Register...]
06/29/2010 19:26 daddycool.#8
Open SQL Server Enterprise Manager, go to Character Database, Tables, user_character and check if you has the information for each class like:

Code:
	DEKARON0000001	[OPR]SWORDSMAN	19999999999991	0	0	0	0	0	0	1000	1000	6	3	5	2	336	363	336	366	7	7	0	0	1	0	10	0	0	0	0	0	0	0	0	20050325	31/5/2008 01:13:15		31/5/2008 01:13:15		<Binary>	0	0	0	0	0
	DEKARON1000001	[OPR]ARCHERESS	19999999999991	0	0	0	0	0	0	1000	1000	3	6	3	3	336	215	336	216	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	20050325	31/5/2008 01:13:15		31/5/2008 01:13:15		<Binary>	0	0	0	0	0
	DEKARON2000001	[OPR]SORCERESS	19999999999991	0	0	0	0	0	0	1000	1000	2	3	2	8	354	146	354	146	7	7	0	0	1	2	0	0	0	0	0	0	0	0	0	20050325	31/5/2008 01:13:15		31/5/2008 01:13:15		<Binary>	0	0	0	0	0
	DEKARON3000001	[OPR]SUMMONER	19999999999991	0	0	0	0	0	0	1000	1000	5	3	4	4	284	146	232	158	0	0	0	0	1	3	117	0	0	0	0	0	0	0	0	20050325	31/5/2008 01:13:15		31/5/2008 01:13:15		<Binary>	0	0	0	0	0
	DEKARON4000001	[OPR]HEALER	19999999999991	0	0	0	0	0	0	1000	1000	2	4	4	5	354	146	354	146	7	7	0	0	1	4	0	0	0	0	0	0	0	0	0	20050325	31/5/2008 01:13:15		31/5/2008 01:13:15		<Binary>	0	0	0	0	0
	DEKARON5000001	[OPR]WARRIOR	19999999999991	0	0	0	0	0	0	1000	1000	6	2	4	2	354	146	354	146	7	7	0	0	1	5	0	0	0	0	0	0	0	0	0	20050325	31/5/2008 01:13:15		31/5/2008 01:13:15		<Binary>	0	0	0	0	0
My user_character table is a little diferent but the most important (column character_no) is the same.
06/29/2010 19:33 tzuasd#9
check?pls say me how to?sry but i want to learn it all :D
06/29/2010 20:43 Deadman88#10
Quote:
Originally Posted by tzuasd View Post
how an i fix error.
[Only registered and activated users can see links. Click Here To Register...]
Microsoft OLE DB Provider for SQL Server: Syntax error converting datetime form character string.

When i try to create a character i get a unnamed error!
Adjust you date..2010 to 2009..