help please

06/22/2014 03:40 Takahiro // Maximiliano#1
Help please:
yesterday at ending the configurations of the db i came across the following problem,
and I don't know what could trigger.
If any of you can guide me in your solution, I would be very grateful.
The problem is the following:
To give play to the SV. accounts created may not enter, resulting in error of connection 0.
But the new accounts if they can enter and stay in the game,hasta el momento en que cambian de personaje
o cierran la misma,lo que las deriva con el problema de coneccion.
If someone can guide me in your solution would be grateful.
Greetings.
06/23/2014 09:28 Takahiro // Maximiliano#2
Hello boys, looking a little more detail in the error i found the following legend.

2014-06-23 01:56:16 ::LoadCharacter 12 (Name Pj) qerr=-1, EXEC usp_Read_Chars_PointLog_R 12

2014-06-23 01:56:16 ErrorMsg=[Microsoft][ODBC SQL Server Driver]Valor de carácter no válido para especificación cast, SQL STATE: 22018, NATIVE ERROR: 0 (0x0)

I go to the list indicated and the code in the same is:
Code:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER OFF
GO



ALTER Proc [dbo].[usp_Read_Chars_PointLog_R]

@CharID int
--@UseType tinyint

AS

SET NOCOUNT ON


SELECT TOP 10 ProductCode, UseDate, UsePoint FROM PointLog WITH (READUNCOMMITTED) WHERE CharID=@CharID
ORDER BY UseDate desc

SET NOCOUNT OFF
According to the error report said that the error has its beginning in that line of code.
If any of you, I could say where is the error.I'll be very grateful
Many thanks
06/25/2014 23:44 Autrux#3
#moved
06/28/2014 10:18 beetols#4
No veo donde este procedimiento está en la base de datos solicitada si este es el comando completo, entonces estoy seguro u tiene algo mal y que va a resolver el uso de una palabra mágica .. u se encuentra esta palabra en una gran cantidad de temas , por favor asegúrese de que es la palabra correcta .. lo siento por la mala google español traducir
06/30/2014 07:01 Takahiro // Maximiliano#5
If that is my problem is not well in that line may fail with the template code of the SQL. what gives me that message as above as error, of course I am not an expert in SQL for that reason I would appeal to you to see if they provide their assistance.
07/01/2014 05:11 beetols#6
Your procedure must begin so..
Code:
USE [PS_GameData]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
Begin to use your brain.exe and solve your problems alone as all! or change hobby.
07/01/2014 09:37 Takahiro // Maximiliano#7
Thank you beetols. the truth I didn't know precisely how my knowledge in SQL is very low. to be carried out in accordance with take a few courses or something to deepen more. again thank you very much.
07/01/2014 11:54 beetols#8
more that here are haven't begin with knowledge in SQL but we try to learn out for work about, you can't create a server thinking that this community is here extra to help you! so good luck learning it, and don't write so stupid posts.. if u can't do something try your self, and if you can't, search it, don't ask.. so you will learn how to do the things, asking and not using your brain you will not learn nothing!