Error trying to open with a different connection string.

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
phburke
Posts: 3
Joined: Sun 22 Feb 2009 22:57

Error trying to open with a different connection string.

Post by phburke » Thu 15 Mar 2012 03:12

This works in Visual Studio 2008, but not in Visual Studio 2010. Any suggestions?

using (var data = new FreeswitchNamespace.FreeswitchEntities("User Id=username;Password=pwd;Host=192.168.0.74;Database=freeswitch;Persist Security Info=True;"))
{
MessageBox.Show("got here");
}


I get the following exception. "Keyword not supported: 'user id'."

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Mon 19 Mar 2012 15:32

Could you please specify the ORM (e.g., LinqConnect or Entity Framework) you are working with?

For example, this issue may occur if you are trying to create an Entity Framework object context, since the EntityConnection connection string format differs from the format of provider's connection string. For the detailed information about creating a proper EntityConnection connection string, please refer to the following topics:
http://msdn.microsoft.com/en-us/library/cc716756.aspx
http://msdn.microsoft.com/en-us/library/bb738533.aspx

Post Reply