Connection String for Shared Memory

Connection String for Shared Memory

Postby 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.
tjarvis
 
Posts: 2
Joined: Mon 21 Apr 2008 02:22
Location: Melbourne

Postby 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/server-options.html#option_mysqld_shared-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.
Shalex
Devart Team
 
Posts: 7340
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL