Connection String for Shared Memory

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
tjarvis
Posts: 2
Joined: Mon 21 Apr 2008 02:22
Location: Melbourne

Connection String for Shared Memory

Post by tjarvis » Wed 03 Feb 2010 19:51

Hi,

I am trying to make a connection to a MySQL instance that has networking turned off and is using shared memory. I can connect just fine with the MySQL.exe client but cannot get the MySQLConnection component to connect. (Where for example do I put the Shared Memory Base Name)

Note connection string examples on connectionstrings.com don't work.

Regards Tim.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 04 Feb 2010 10:35

Please set the Protocol parameter of your connection string to Memory.
This will enable the shared memory protocol. This type of the network protocol can be used to access MySQL server at the same machine with client. Not supported in Direct mode. Not available in Mobile edition.
Also please make sure that the shared-memory and shared-memory-base-name=the_actual_name options are set in an option file of your server (http://dev.mysql.com/doc/refman/5.1/en/ ... red-memory).

If it doesn't work, please tell us:
1) the exact error you are getting;
2) your version of dotConnect for MySQL. You can find it in the Tools | MySQL | About menu of Visual Studio;
3) your connection string;
4) the shared memory options from an option file.

Post Reply