|
You last visited: Today at 18:25
Advertisement
[Guide]Srevolution Full Guide Mssql + Mssql Server Manager + Server Files
Discussion on [Guide]Srevolution Full Guide Mssql + Mssql Server Manager + Server Files within the SRO Coding Corner forum part of the Silkroad Online category.
11/19/2010, 19:40
|
#331
|
elite*gold: 0 
Join Date: May 2008
Posts: 34
Received Thanks: 2
|
Quote:
Originally Posted by Blacks0ldier
Anyone know what problem is when I create the tables they are always in the Master table not in the "silk" table....
|
yea i have same problem
|
|
|
|
11/19/2010, 20:14
|
#332
|
elite*gold: 0
Join Date: Feb 2010
Posts: 38
Received Thanks: 1
|
everything works fine, but I have one problem I can not creat acc ,are only created in the first admin acc.. sry for bad englidh language 
|
|
|
|
|
11/20/2010, 12:51
|
#333
|
elite*gold: 0
Join Date: Mar 2007
Posts: 158
Received Thanks: 17
|
hi all epvp i not see my server on server list in silkroad ( ty )
|
|
|
|
|
11/20/2010, 14:20
|
#334
|
elite*gold: 0
Join Date: Sep 2009
Posts: 35
Received Thanks: 0
|
can you help my?
|
|
|
|
|
11/20/2010, 14:25
|
#335
|
elite*gold: 0
Join Date: Oct 2009
Posts: 68
Received Thanks: 9
|
all i have new problem i'am in game and my ATACK sPEED is very BIG BIG i have mob on one hit fast why ? plz help 
|
|
|
|
|
11/20/2010, 23:31
|
#336
|
elite*gold: 0
Join Date: May 2010
Posts: 4
Received Thanks: 0
|
hi guys,
I have strange problem and don't know what 's wrong:
I made everything exactly like on the movie (posted 3 pages before). I open LoginServer normaly, then GameServer.
I created chinese character and when i tried to login I see login window but the bar doesn't move and in the GameServer window I can see something like this:
Quote:
[2010-11-20 22:58:47] Could not find file 'C:\Documents and Settings\taratata\Pulpit\SERWER\Gameserver\player\ info\quickbar\Manky.dat'. -> at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)
at System.IO.File.ReadAllBytes(String path)
at Game.Private.Packet.Load(character c)
at Game.Systems.LoginScreen()
|
There are some infos that emu can't find some files but I don't know how to add them
Please help me ASAP
|
|
|
|
|
11/21/2010, 10:09
|
#337
|
elite*gold: 0
Join Date: Nov 2010
Posts: 159
Received Thanks: 10
|
Quote:
Originally Posted by zoovoo
hi all epvp i not see my server on server list in silkroad ( ty )
|
go to mssql open your db > go to tablet and open server tablet
and change
state=0 to 1
and need change type=1 to 0
|
|
|
|
|
11/21/2010, 16:29
|
#338
|
elite*gold: 100
Join Date: Sep 2009
Posts: 1,195
Received Thanks: 379
|
nothing work on new db, anyone can paste me the old db ? (silk.sql) please, thanks in advance
|
|
|
|
|
11/21/2010, 17:02
|
#339
|
elite*gold: 0
Join Date: Feb 2010
Posts: 2
Received Thanks: 0
|
Ih, im' italian 
this is my error:
game server:
Code:
[@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@]
___ ___ ___ ___ ___
/\ \ /\ \ /\ \ /\__\ /\ \
/::\ \ /::\ \ /::\ \ /:/ / /::\ \
/:/\ \ \ /:/\:\ \ /:/\:\ \ /:/ / /:/\:\ \
_\:\~\ \ \ /::\~\:\ \ /::\~\:\ \ /:/__/ ___ /:/ \:\ \
/\ \:\ \ \__\ /:/\:\ \:\__\ /:/\:\ \:\__\ |:| | /\__\ /:/__/ \:\__\
\:\ \:\ \/__/ \/_|::\/:/ / \:\~\:\ \/__/ |:| |/:/ / \:\ \ /:/ /
\:\ \:\__\ |:|::/ / \:\ \:\__\ |:|__/:/ / \:\ /:/ /
\:\/:/ / |:|\/__/ \:\ \/__/ \::::/__/ \:\/:/ /
\::/ / |:| | \:\__\ ~~~~ \::/ /
\/__/ \|__| \/__/ \/__/
Silkroad online game server
[@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@]
@Gameserver: Error::System.Data.SqlClient.SqlException (0x80131904): A n
etwork-related or instance-specific error occurred while establishing a connecti
on to SQL Server. The server was not found or was not accessible. Verify that th
e instance name is correct and that SQL Server is configured to allow remote con
nections. (provider: Named Pipes Provider, error: 40 - Could not open a connecti
on to SQL Server)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception
, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternal
ConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Bool
ean encrypt, Boolean trustServerCert, Boolean integratedSecurity)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo
serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeo
ut, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo
serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection ow
ningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnecti
on owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, St
ring newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdent
ity identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOp
tions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConn
ection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owning
Object)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection o
wningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection ownin
gObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection ow
ningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection ou
terConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Framework.MsSQL.Connection(String connections)
[@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@]
@Gameserver: Loading Server Info!
[@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@]
@Gameserver: Experience multiplier: 1
@Gameserver: Skillpoint multiplier: 1
@Gameserver: Item drops multiplier: 1
@Gameserver: Seal drops multiplier: 1
@Gameserver: Gold drops multiplier: 1
@Gameserver: Error::System.InvalidOperationException: ExecuteNonQuery re
quires an open and available Connection. The connection's current state is close
d.
at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)
at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String me
thod, SqlCommand command)
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean as
ync)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult res
ult, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Framework.MsSQL.InsertData(String command)
UPDATE users SET online='0'
@Gameserver: Error::System.InvalidOperationException: ExecuteNonQuery re
quires an open and available Connection. The connection's current state is close
d.
at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)
at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String me
thod, SqlCommand command)
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean as
ync)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult res
ult, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Framework.MsSQL.InsertData(String command)
UPDATE server SET users_current='0'
[17:00:17] 2823 Tárgy betöltése innen: \data\itemdata_5000.txt...
[17:00:18] 2111 Tárgy betöltése innen: \data\itemdata_10000.txt...
[17:00:18] 3794 Tárgy betöltése innen: \data\itemdata_15000.txt...
[17:00:18] 294 Tárgy betöltése innen: \data\itemdata_20000.txt...
[17:00:18] 837 Tárgy betöltése innen: \data\itemdata_25000.txt...
[17:00:18] 1672 Tárgy betöltése innen: \data\itemdata_30000.txt...
[17:00:18] 299 Tárgy betöltése innen: \data\itemdata_35000.txt...
[17:00:18] 4805 betöltése innen: \data\skilldata_5000.txt...
[17:00:18] 4507 betöltése innen: \data\skilldata_10000.txt...
[17:00:18] 4943 betöltése innen: \data\skilldata_15000.txt...
[17:00:18] 4387 betöltése innen: \data\skilldata_20000.txt...
[17:00:18] 4762 betöltése innen: \data\skilldata_25000.txt...
[17:00:18] 4958 betöltése innen: \data\skilldata_30000.txt...
[17:00:18] 1892 betöltése innen: \data\skilldata_35000.txt...
[17:00:19] 110 Mastery Data betöltése...
[17:00:19] 140 Gold Data betöltése..
[17:00:19] 140 Level Data betöltése..
[17:00:19] 4632 Shop Data betöltése..
Login Server:
Code:
[@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@]
___ ___ ___ ___ ___
/\ \ /\ \ /\ \ /\__\ /\ \
/::\ \ /::\ \ /::\ \ /:/ / /::\ \
/:/\ \ \ /:/\:\ \ /:/\:\ \ /:/ / /:/\:\ \
_\:\~\ \ \ /::\~\:\ \ /::\~\:\ \ /:/__/ ___ /:/ \:\ \
/\ \:\ \ \__\ /:/\:\ \:\__\ /:/\:\ \:\__\ |:| | /\__\ /:/__/ \:\__\
\:\ \:\ \/__/ \/_|::\/:/ / \:\~\:\ \/__/ |:| |/:/ / \:\ \ /:/ /
\:\ \:\__\ |:|::/ / \:\ \:\__\ |:|__/:/ / \:\ /:/ /
\:\/:/ / |:|\/__/ \:\ \/__/ \::::/__/ \:\/:/ /
\::/ / |:| | \:\__\ ~~~~ \::/ /
\/__/ \|__| \/__/ \/__/
Silkroad online Login server
[@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@]
@Loginserver: Server loading configurations...
[17:00:22] @Loginserver: Error:A network-related or instance-specific err
or occurred while establishing a connection to SQL Server. The server was not fo
und or was not accessible. Verify that the instance name is correct and that SQL
Server is configured to allow remote connections. (provider: Named Pipes Provid
er, error: 40 - Could not open a connection to SQL Server)
[17:00:22] @Loginserver: Database:.Net SqlClient Data Provider
[17:00:22] @Loginserver: Error:ExecuteNonQuery requires an open and avail
able Connection. The connection's current state is closed.
[17:00:22] @Loginserver: Database:System.Data
[17:00:22] @Loginserver: Error:ExecuteNonQuery requires an open and avail
able Connection. The connection's current state is closed.
[17:00:22] @Loginserver: Database:System.Data
System.InvalidOperationException: ExecuteReader requires an open and available C
onnection. The connection's current state is closed.
at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)
at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String me
thod, SqlCommand command)
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean as
ync)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehav
ior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult
result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehav
ior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, S
tring method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Framework.MsSQL.Read()
at Data.Base.Load_NewsList()
Pls help me
|
|
|
|
|
11/21/2010, 17:15
|
#340
|
elite*gold: 0
Join Date: May 2010
Posts: 5
Received Thanks: 0
|
Quote:
Originally Posted by StephyDj
Ih, im' italian
this is my error:
game server:
Code:
[@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@]
___ ___ ___ ___ ___
/\ \ /\ \ /\ \ /\__\ /\ \
/::\ \ /::\ \ /::\ \ /:/ / /::\ \
/:/\ \ \ /:/\:\ \ /:/\:\ \ /:/ / /:/\:\ \
_\:\~\ \ \ /::\~\:\ \ /::\~\:\ \ /:/__/ ___ /:/ \:\ \
/\ \:\ \ \__\ /:/\:\ \:\__\ /:/\:\ \:\__\ |:| | /\__\ /:/__/ \:\__\
\:\ \:\ \/__/ \/_|::\/:/ / \:\~\:\ \/__/ |:| |/:/ / \:\ \ /:/ /
\:\ \:\__\ |:|::/ / \:\ \:\__\ |:|__/:/ / \:\ /:/ /
\:\/:/ / |:|\/__/ \:\ \/__/ \::::/__/ \:\/:/ /
\::/ / |:| | \:\__\ ~~~~ \::/ /
\/__/ \|__| \/__/ \/__/
Silkroad online game server
[@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@]
@Gameserver: Error::System.Data.SqlClient.SqlException (0x80131904): A n
etwork-related or instance-specific error occurred while establishing a connecti
on to SQL Server. The server was not found or was not accessible. Verify that th
e instance name is correct and that SQL Server is configured to allow remote con
nections. (provider: Named Pipes Provider, error: 40 - Could not open a connecti
on to SQL Server)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception
, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternal
ConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Bool
ean encrypt, Boolean trustServerCert, Boolean integratedSecurity)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo
serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeo
ut, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo
serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection ow
ningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnecti
on owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, St
ring newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdent
ity identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOp
tions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConn
ection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owning
Object)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection o
wningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection ownin
gObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection ow
ningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection ou
terConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Framework.MsSQL.Connection(String connections)
[@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@]
@Gameserver: Loading Server Info!
[@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@]
@Gameserver: Experience multiplier: 1
@Gameserver: Skillpoint multiplier: 1
@Gameserver: Item drops multiplier: 1
@Gameserver: Seal drops multiplier: 1
@Gameserver: Gold drops multiplier: 1
@Gameserver: Error::System.InvalidOperationException: ExecuteNonQuery re
quires an open and available Connection. The connection's current state is close
d.
at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)
at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String me
thod, SqlCommand command)
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean as
ync)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult res
ult, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Framework.MsSQL.InsertData(String command)
UPDATE users SET online='0'
@Gameserver: Error::System.InvalidOperationException: ExecuteNonQuery re
quires an open and available Connection. The connection's current state is close
d.
at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)
at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String me
thod, SqlCommand command)
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean as
ync)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult res
ult, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Framework.MsSQL.InsertData(String command)
UPDATE server SET users_current='0'
[17:00:17] 2823 Tárgy betöltése innen: \data\itemdata_5000.txt...
[17:00:18] 2111 Tárgy betöltése innen: \data\itemdata_10000.txt...
[17:00:18] 3794 Tárgy betöltése innen: \data\itemdata_15000.txt...
[17:00:18] 294 Tárgy betöltése innen: \data\itemdata_20000.txt...
[17:00:18] 837 Tárgy betöltése innen: \data\itemdata_25000.txt...
[17:00:18] 1672 Tárgy betöltése innen: \data\itemdata_30000.txt...
[17:00:18] 299 Tárgy betöltése innen: \data\itemdata_35000.txt...
[17:00:18] 4805 betöltése innen: \data\skilldata_5000.txt...
[17:00:18] 4507 betöltése innen: \data\skilldata_10000.txt...
[17:00:18] 4943 betöltése innen: \data\skilldata_15000.txt...
[17:00:18] 4387 betöltése innen: \data\skilldata_20000.txt...
[17:00:18] 4762 betöltése innen: \data\skilldata_25000.txt...
[17:00:18] 4958 betöltése innen: \data\skilldata_30000.txt...
[17:00:18] 1892 betöltése innen: \data\skilldata_35000.txt...
[17:00:19] 110 Mastery Data betöltése...
[17:00:19] 140 Gold Data betöltése..
[17:00:19] 140 Level Data betöltése..
[17:00:19] 4632 Shop Data betöltése..
Login Server:
Code:
[@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@]
___ ___ ___ ___ ___
/\ \ /\ \ /\ \ /\__\ /\ \
/::\ \ /::\ \ /::\ \ /:/ / /::\ \
/:/\ \ \ /:/\:\ \ /:/\:\ \ /:/ / /:/\:\ \
_\:\~\ \ \ /::\~\:\ \ /::\~\:\ \ /:/__/ ___ /:/ \:\ \
/\ \:\ \ \__\ /:/\:\ \:\__\ /:/\:\ \:\__\ |:| | /\__\ /:/__/ \:\__\
\:\ \:\ \/__/ \/_|::\/:/ / \:\~\:\ \/__/ |:| |/:/ / \:\ \ /:/ /
\:\ \:\__\ |:|::/ / \:\ \:\__\ |:|__/:/ / \:\ /:/ /
\:\/:/ / |:|\/__/ \:\ \/__/ \::::/__/ \:\/:/ /
\::/ / |:| | \:\__\ ~~~~ \::/ /
\/__/ \|__| \/__/ \/__/
Silkroad online Login server
[@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@]
@Loginserver: Server loading configurations...
[17:00:22] @Loginserver: Error:A network-related or instance-specific err
or occurred while establishing a connection to SQL Server. The server was not fo
und or was not accessible. Verify that the instance name is correct and that SQL
Server is configured to allow remote connections. (provider: Named Pipes Provid
er, error: 40 - Could not open a connection to SQL Server)
[17:00:22] @Loginserver: Database:.Net SqlClient Data Provider
[17:00:22] @Loginserver: Error:ExecuteNonQuery requires an open and avail
able Connection. The connection's current state is closed.
[17:00:22] @Loginserver: Database:System.Data
[17:00:22] @Loginserver: Error:ExecuteNonQuery requires an open and avail
able Connection. The connection's current state is closed.
[17:00:22] @Loginserver: Database:System.Data
System.InvalidOperationException: ExecuteReader requires an open and available C
onnection. The connection's current state is closed.
at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)
at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String me
thod, SqlCommand command)
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean as
ync)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehav
ior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult
result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehav
ior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, S
tring method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Framework.MsSQL.Read()
at Data.Base.Load_NewsList()
Pls help me |
after installed and config setting you should restart computer.
|
|
|
|
|
11/21/2010, 17:43
|
#341
|
elite*gold: 0
Join Date: Feb 2010
Posts: 2
Received Thanks: 0
|
Quote:
Originally Posted by taobine
after installed and config setting you should restart computer.
|
is the same thing, I just restarted the PC, the error is equal
|
|
|
|
|
11/21/2010, 17:46
|
#342
|
elite*gold: 0
Join Date: Nov 2010
Posts: 23
Received Thanks: 0
|
[0] Requesting user coniformation....
and nothing happens. Any help?
|
|
|
|
|
11/21/2010, 23:26
|
#343
|
elite*gold: 0
Join Date: Jun 2008
Posts: 322
Received Thanks: 53
|
No error and no server ? Someone know how to solve this ?
Pliz Help me
I tried a lot of things and nothing work ...
state=1
type=0
Host :
127.0.0.1 gwgt1.silkroadonline.co.kr
127.0.0.1 gwgt2.silkroadonline.co.kr
tried with hamachi and doesnt work !
I desinstalled everything and reinstalled everything . step by step and its not working !
Im gonna give a Thanx to the one that will help me
|
|
|
|
|
11/22/2010, 15:57
|
#344
|
elite*gold: 0
Join Date: Mar 2007
Posts: 158
Received Thanks: 17
|
Quote:
Originally Posted by ZiXiRo
go to mssql open your db > go to tablet and open server tablet
and change
state=0 to 1
and need change type=1 to 0
|
(thnx ) no work (((
|
|
|
|
|
11/22/2010, 17:24
|
#345
|
elite*gold: 0
Join Date: Jan 2010
Posts: 2,363
Received Thanks: 695
|
lol i cant get the tables x)
i copy-pasted it and it wont give me the tables.
|
|
|
|
 |
|
Similar Threads
|
[Guide] Setup MSSQL for Personal PServers
05/17/2012 - Shaiya PServer Guides & Releases - 14 Replies
So I know there have been quite a few people having issues setting up mssql correctly to host their own private servers. I decided to post a video tut on how to set it up correctly for local use. This was done on Windows XP 32-bit and works on other OS as well.
*Note* This configuration is based on personal home use, not for public servers. I do not condone the use of illegal public servers, you will have to figure out those settings yourself.
...
|
Hilfee!!!! Prob mit Server files Und Db MSSQL
10/23/2010 - Flyff Private Server - 1 Replies
Also ich weis nicht wie Ich die offi Files richtig einstellen Und ein fügen solll Und bei der DB Kann ich nix Machen muss mich einloggen und weiss nicht wie
Ich bitte um schnelle Antwort Kann Auch Skype oda TW?? Pls Pls Antwort
Gruß Fashiion
|
[GUIDE]ASP.NET error for MSSQL 20005
10/02/2010 - Cabal Guides & Templates - 0 Replies
After a couple hours i have figured out how to correct the ASP.NET.
I don't know if anyone else is having a problem with it....
This is what you do,
Click the start Icon.
in the search box type in "intermgr"
a screen like this should open
http://i814.photobucket.com/albums/zz64/xvvhitecl oudx/inetmgr.jpg
|
How i find mssql server
08/28/2010 - Kal Online - 3 Replies
Mssql server funzt bei mir nicht das 2000 gar nicht mehr zum installieren das 2005-2008 kann man nirgends in der scheisse bei google downloaden ... hilfe bitte
|
Sql Server 200 /MSSQL 200 ?
08/26/2009 - Dekaron Private Server - 2 Replies
Hi where i can get Sql Server 2000 or MSSQL 2000 ?
have any one a download link for me ?
|
All times are GMT +1. The time now is 18:26.
|
|
![[Guide]Srevolution Full Guide Mssql + Mssql Server Manager + Server Files](https://www.elitepvpers.com/forum/iconimages/sro-coding-corner/guide-srevolution-full-guide-mssql-mssql-server-manager-server-files_ltr.gif){kind=small}
![[B]ase[J]umP's Avatar](https://www.elitepvpers.com/forum/customavatars/avatar2047563_7.gif){kind=avatar}
