Help pls

[tzuasd]

how an i fix error.

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!

[pieter]

search for FN_BinDateToStr on the forums, no one will be explaining this again since it's asked 3 times in a day...

[daddycool.]

A little correction. The name of the function is FN_BinDateToDateTime, anyway look at this thread

[tzuasd]

i dont know how to insert it

[daddycool.]

Just open the MSSQL Query Analyzer, copy and paste
the code and press Run (F5).

[pavkaspr]

dont work i have same error please help me too

[tzuasd]

work but even i get a error when creating character

[daddycool.]

Open SQL Server Enterprise Manager, go to Character Database, Tables, user_character and check if you has the information for each class like:

	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.

[tzuasd]

check?pls say me how to?sry but i want to learn it all

[Deadman88]

Originally Posted by tzuasd

how an i fix error.

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..