Name Check EP 6.3 Error 10053

[xFantaa]

Hey,
ich wollte fragen ob jemand weiß was ich machen könnte sobald ich auf Check gehe beim Namen des Charakter erhalte ich einen Error 10053 ich benutze einen EP 6.3 Client.

Ich hatte schon gesucht aber keine Lösung dafür gefunden.

 Spoiler

 Spoiler

[xFantaa]

Originally Posted by Raziel166

try this and tell me if it worked

 Spoiler

USE PS_GameDefs
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO




create Proc [dbo].[AvailiableCharName]
@ varchar(20),
@iable int OUTPUT

AS

SET NOCOUNT ON

set @iable=1

if exists(select * from ps_gamedata.dbo.chars where charname @)
begin
set @iable=0
end





return

SET NOCOUNT OFF




GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

 Spoiler

USE [PS_GameData]
GO

/****** Object: Index [IX_Chars_CharName] Script Date: 10/07/2011 17:15:26 ******/
IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Chars]') AND name = N'IX_Chars_CharName')
DROP INDEX [IX_Chars_CharName] ON [dbo].[Chars] WITH ( ONLINE = OFF )
GO

USE [PS_GameData]
GO

/****** Object: Index [IX_Chars_CharName] Script Date: 10/07/2011 17:15:27 ******/
CREATE NONCLUSTERED INDEX [IX_Chars_CharName] ON [dbo].[Chars]
(
[CharName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

I can't use the first Query :/

 Spoiler

Msg 102, Level 15, State 1, Procedure AvailiableCharName, Line 15
Incorrect syntax near '@charname'.

[xFantaa]

Originally Posted by Raziel166

Make sure you have the correct ps_game

I think my EP 4.5 Database is not compatible with my Client?
and I cant attach my EP 6 Database into SQL...

 Spoiler

===================================

Attach database failed for Server 'DESKTOP-3TP83R4'. (Microsoft.SqlServer.Smo)

------------------------------
For help, click:

------------------------------
Program Location:

at Microsoft.SqlServer.Management.Smo.Server.AttachDa tabase(String name, StringCollection files)
at Microsoft.SqlServer.Management.SqlManagerUI.Attach DatabaseData.PrimaryFile.Attach()
at Microsoft.SqlServer.Management.SqlManagerUI.Attach Database.SendDataToServer()

===================================

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
Program Location:

at Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Smo.ExecutionManage r.ExecuteNonQuery(StringCollection queries)
at Microsoft.SqlServer.Management.Smo.Server.AttachDa tabaseWorker(String name, StringCollection files, String owner, AttachOptions attachOptions)
at Microsoft.SqlServer.Management.Smo.Server.AttachDa tabase(String name, StringCollection files)

===================================

Unable to open the physical file "C:\ShaiyaServerEP6\DATABASE\OMG_GameWeb_Log.L DF". Operating system error 5: "5(Zugriff verweigert)". (.Net SqlClient Data Provider)

------------------------------
For help, click:

------------------------------
Server Name: (local)
Error Number: 5120
Severity: 16
State: 101
Line Number: 1


------------------------------
Program Location:

at Microsoft.SqlServer.Management.Common.ConnectionMa nager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

[[Admin]Slice]

Originally Posted by xFantaa

I think my EP 4.5 Database is not compatible with my Client?
and I cant attach my EP 6 Database into SQL...

 Spoiler

===================================

Attach database failed for Server 'DESKTOP-3TP83R4'. (Microsoft.SqlServer.Smo)

------------------------------
For help, click:

------------------------------
Program Location:

at Microsoft.SqlServer.Management.Smo.Server.AttachDa tabase(String name, StringCollection files)
at Microsoft.SqlServer.Management.SqlManagerUI.Attach DatabaseData.PrimaryFile.Attach()
at Microsoft.SqlServer.Management.SqlManagerUI.Attach Database.SendDataToServer()

===================================

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
Program Location:

at Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Smo.ExecutionManage r.ExecuteNonQuery(StringCollection queries)
at Microsoft.SqlServer.Management.Smo.Server.AttachDa tabaseWorker(String name, StringCollection files, String owner, AttachOptions attachOptions)
at Microsoft.SqlServer.Management.Smo.Server.AttachDa tabase(String name, StringCollection files)

===================================

Unable to open the physical file "C:\ShaiyaServerEP6\DATABASE\OMG_GameWeb_Log.L DF". Operating system error 5: "5(Zugriff verweigert)". (.Net SqlClient Data Provider)

------------------------------
For help, click:

------------------------------
Server Name: (local)
Error Number: 5120
Severity: 16
State: 101
Line Number: 1


------------------------------
Program Location:

at Microsoft.SqlServer.Management.Common.ConnectionMa nager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

give me a message on here or skype and i'll help you out.

[Arby]

#moved…