MySQL remote connection with LingConnect for Metro

MySQL remote connection with LingConnect for Metro

Postby Braveheart » Wed 12 Jun 2013 20:28

hi,
I am trying to make a remote connection to a MySQL server in our local network with "Devart LinqConnect for Metro (MySQL)" and it always say "access denied". I am using the following code :

Devart.Data.MySql.MySqlConnection lMySqlConnection = new Devart.Data.MySql.MySqlConnection();
lMySqlConnection.Host = "192.168.0.237";
lMySqlConnection.Port = 3306;
lMySqlConnection.Database = "databasename";
lMySqlConnection.UserId = "user";
lMySqlConnection.Password = "password";
lMySqlConnection.Open();

Is it possible to do this type of connection in a Metro app? If not what is the good way to connect to a remote MySQL server with the Library?


Thank you in advance
Braveheart
 
Posts: 11
Joined: Wed 12 Jun 2013 20:19

Re: MySQL remote connection with LingConnect for Metro

Postby MariiaI » Thu 13 Jun 2013 09:50

Braveheart wrote: Is it possible to do this type of connection in a Metro app?

Yes, it is possible to do.
Please open the Package.appxmanifest file of your application, open the Capabilities tab and select the "Internet (Client & Server)" and "Private Networks (Client & Server)" check boxes.
Save changes and try executing your code to open the MySQL connection.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: MySQL remote connection with LingConnect for Metro

Postby Braveheart » Thu 13 Jun 2013 12:55

ok thanks it's working!
Braveheart
 
Posts: 11
Joined: Wed 12 Jun 2013 20:19

Re: MySQL remote connection with LingConnect for Metro

Postby Braveheart » Thu 13 Jun 2013 16:05

The tutorial here http://blogs.devart.com/dotconnect/linqconnect-for-metro-quick-start-guide.html explain how to display data from a new generated database. Does it have a tutorial if we use the "Database First" model type do display data from a model of a remote SQL MySQL server. I created the model from my remote SQL database, but how I can use it to display the data in a grid view like in the tutorial?
Does it have also a quick way to fill a gridview with a datareader?

Thank you in advance!
Braveheart
 
Posts: 11
Joined: Wed 12 Jun 2013 20:19

Re: MySQL remote connection with LingConnect for Metro

Postby Braveheart » Thu 13 Jun 2013 18:09

From what I see in the documentation, after my model is created from my database, I need to do this :

TtvDevV1Context.TtvDevV1DataContext context = new TtvDevV1Context.TtvDevV1DataContext();

But when I run the application, after it get into the constructor, the application crash on the call of the base constructor:

base(@"User Id=user;Password=password;Host=192.168.0.156;Database=ttv_dev_v1;Persist Security Info=True", mappingSource)


#if DEBUG && !DISABLE_XAML_GENERATED_BREAK_ON_UNHANDLED_EXCEPTION
UnhandledException += (sender, e) =>
{
--> if (global::System.Diagnostics.Debugger.IsAttached) global::System.Diagnostics.Debugger.Break(); };
#endif

And I get the following message box :

"A debugger is attached to app1.exe but not configured to debug this unhandled exception. To Debug this exceptions, detach the current debugger"
Braveheart
 
Posts: 11
Joined: Wed 12 Jun 2013 20:19

Re: MySQL remote connection with LingConnect for Metro

Postby MariiaI » Fri 14 Jun 2013 08:22

There is no tutorial for using LinqConnect for Metro with MySQL at the moment.
The steps in the section "Binding and Displaying Data" in our blog are the same for MySQL.
Except for the lines of creating a DataContext instance:
Code: Select all
TtvDevV1Context.TtvDevV1DataContext context = new TtvDevV1Context.TtvDevV1DataContext();
instead of
Code: Select all
TtvDevV1Context.TtvDevV1DataContext context = new TtvDevV1Context.TtvDevV1DataContext.Create();

As for the exception you are getting when creating a new instance of DataContext, we couldn't reproduce it.
We are sending you a test project to the e-mail address you have provided in your forum profile. Please check that the letter is not blocked by your mail filter. Please make changes to it so that the issue could be reproduced and send it back to us or send us your project.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: MySQL remote connection with LingConnect for Metro

Postby MariiaI » Tue 18 Jun 2013 09:02

Thank you for the additional information. We still couldn't reproduce this issue on our environment.
Your database is not necessary for reproducing the issue. It's enough to have a sample project with your LinqConnect model (*.lqml file), with which this error is reproduced when creating a new DataContext instance.
Thus, please provide us with a test project, so that we are able to find a solution for you.

Please try using try-catch block in the Page_Loaded_1 method to get the stack trace of the error and send it us.

We have also sent you a sample project (14.06.2013 11:23) - please tell us whether the issue is reproduced with it or not?
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: MySQL remote connection with LingConnect for Metro

Postby Braveheart » Fri 12 Jul 2013 13:43

Sorry for late answer, I was in vacations for 3 weeks. I used a try catch to get the error that cause this line :
TtvDevV1Context.TtvDevV1DataContext context = new TtvDevV1Context.TtvDevV1DataContext();

and the error is "License not found. Please view "Licensing" topic in LinqConnect documentation for details or contact Devart technical support.

From what I see in the help, I need the file licenses.licx and App_Licenses.dll but I can't find them. Where I can find these file for the trial version ?

I found this post doing some search in the forum :

Sorry for the delay. When using LinqConnect for Metro there is no need to add the licenses.licx file to the projects manually. The License file is created automatically in case LinqConnect for Metro is integrated into Visual Studio.
Thus, please make sure that:
- LinqConnect for Metro was integrated into Visual Studio during the installation (the option "Visual Studio integration" should have been selected); if not - please re-install LinqConnect with the option "Visual Studio integration" selected;
- after compilation of the application the file named "DEVART.DATA.SQLITE.LINQ.dll.licenses" should be created in the Properties folder of the project.



I selected Visual Studio Integration during installation, but DEVART.DATA.MySQL.LINQ.dll.licenses is not generated in my project folder after compilation.


Thank you in advance!
Braveheart
 
Posts: 11
Joined: Wed 12 Jun 2013 20:19

Re: MySQL remote connection with LingConnect for Metro

Postby MariiaI » Mon 15 Jul 2013 11:41

There is a known issue with the license resource files when working with LinqConnect for Metro trial edition. We have fixed it and the fix will be included in the next build of LinqConnect for Metro.
JIC: When working with not trial version of LinqConnect for Metro, there is no need in generating license resource file.

As a workaround please do the following:
1. Remove references Devart LinqConnect for Metro (SQLite/Oracle/MySQL/PostgreSQL) from your application.
2. Add references to the Devart assemblies from the directory where LinqConnect for Metro is installed; for example, for MySql add Devart.Data.dll, Devart.Data.MySql.dll, Devart.Data.Linq.dll and Devart.Data.MySql.Linq.dll from C:\Program Files (x86)\Devart
\dotConnect\Linq\WinRT and C:\Program Files (x86)\Devart\dotConnect\MySQL\WinRT folders.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: MySQL remote connection with LingConnect for Metro

Postby Braveheart » Tue 16 Jul 2013 15:49

Thanks, all is working fine now when adding the references manually.
Braveheart
 
Posts: 11
Joined: Wed 12 Jun 2013 20:19


Return to LinqConnect (LINQ to SQL support)