Error : FIXED ! . A connection was successfully established with the server, but then an error occurred during the pre-login handshake

Posted on August 29, 2015 by coder

Cannot connect to : A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: Shared Memory Provider, error: 0 – No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476 —————————— BUTTONS: OK ——————————

1- Open SQL SERVER configuration MANAGER

2- SQL SERVER services

3- SQL SERVER (MSSQLSERVER )

4- CHANGE (Log ON AS)

5- SELECT LOCALSYSTEM

mssql jar java package download

Posted on July 28, 2015 by coder

sqljdbc_4.2.6225.100_enu.tar.part2

sqljdbc_4.2.6225.100_enu.tar.part3

sqljdbc_4.2.6225.100_enu.tar.part1

Hibernate jar package download

Posted on July 28, 2015July 28, 2015 by coder

Hibernate Jar and Needed library

hibernate-search-engine-5.3.0.Final.jar

hibernate-search-orm-5.3.0.Final.jar

hibernate-commons-annotations-4.0.5.Final.jar

javassist-3.18.1-GA.jar

jboss-logging-3.1.4.GA.jar

xml-apis-1.3.03.jar

antlr-2.7.7.jar

dom4j-1.6.1.jar

– – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –

Sql lite .exe download

Posted on July 28, 2015 by coder

Click on the link and download.

sqlite-shell-win32-x86-3081002

System.Collections.Generic.KeyNotFoundException . Fixed !

Posted on June 27, 2015June 27, 2015 by coder

Exception: System.Collections.Generic.KeyNotFoundException
Message  : The given key was not present in the dictionary.
Stack Trace:
   at System.ThrowHelper.ThrowKeyNotFoundException()
   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
   at MySql.Data.MySqlClient.CharSetMap.GetCharacterSet(DBVersion version, String CharSetName)
   at MySql.Data.MySqlClient.CharSetMap.GetEncoding(DBVersion version, String CharSetName)
   at MySql.Data.MySqlClient.Driver.Configure(MySqlConnection connection)

Exception: System.Collections.Generic.KeyNotFoundException

Message : The given key was not present in the dictionary.

Stack Trace:

at System.ThrowHelper.ThrowKeyNotFoundException()

at System.Collections.Generic.Dictionary`2.get_Item(TKey key)

at MySql.Data.MySqlClient.CharSetMap.GetCharacterSet(DBVersion version, String CharSetName)

at MySql.Data.MySqlClient.CharSetMap.GetEncoding(DBVersion version, String CharSetName)

at MySql.Data.MySqlClient.Driver.Configure(MySqlConnection connection)

Solution

UPGRADE your MYSQL DATA .DLL

M:Download >>>> MySql.Data.zip

http://dev.mysql.com/downloads/connector/net/5.1.html

For more look link given above

System.Collections.Generic.KeyNotFoundException: Der angegebene Schlüssel war nicht im Wörterbuch angegeben.
   bei System.ThrowHelper.ThrowKeyNotFoundException()
   bei System.Collections.Generic.Dictionary`2.get_Item(TKey key)
   bei MySql.Data.MySqlClient.CharSetMap.GetCharacterSet(DBVersion version, String CharSetName)
   bei MySql.Data.MySqlClient.CharSetMap.GetEncoding(DBVersion version, String CharSetName)
   bei MySql.Data.MySqlClient.Driver.Configure(MySqlConnection connection)
   bei MySql.Data.MySqlClient.MySqlConnection.Open()

System.Collections.Generic.KeyNotFoundException: Der angegebene Schlüssel war nicht im Wörterbuch angegeben.

bei System.ThrowHelper.ThrowKeyNotFoundException()

bei System.Collections.Generic.Dictionary`2.get_Item(TKey key)

bei MySql.Data.MySqlClient.CharSetMap.GetCharacterSet(DBVersion version, String CharSetName)

bei MySql.Data.MySqlClient.CharSetMap.GetEncoding(DBVersion version, String CharSetName)

bei MySql.Data.MySqlClient.Driver.Configure(MySqlConnection connection)

bei MySql.Data.MySqlClient.MySqlConnection.Open()

mysql dublicate a table

Posted on June 27, 2015June 28, 2015 by coder

CREATE TABLE kutay LIKE oldtable;
INSERT kutay SELECT * FROM oldtable;

1 2	CREATE TABLE kutay LIKE oldtable; INSERT kutay SELECT * FROM oldtable;

mysql performance optimization for restart and connection

Posted on December 20, 2012June 4, 2015 by coder

skip-name-resolve

To your MySQL configuration file (my.ini/my.cnf) and then be sure to reload (restart) the MySQL database server. The ‘[mysqld]‘ section of the my.cnf file now looks like this:

[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
skip-name-resolve

[mysqld]

port = 3306

socket = /tmp/mysql.sock

skip-locking

skip-name-resolve

From Microsoft Windows this can be done from the ‘Services’ window in ‘Administrative tools’ or in Debian/Ubuntu entering this command:

/etc/init.d/mysql restart

1	/etc/init.d/mysql restart

Page 4 of 6

« 1 2 3 4 5 6 »