Page 1 of 1

Connection String for Shared Memory

Posted: Wed 03 Feb 2010 19:51
by tjarvis
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.

Posted: Thu 04 Feb 2010 10:35
by Shalex
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.