Devart Forums

Hi,

I was migrating to SQL Azure, there are tools available for this process however I was concerened about the password migration. Fortunately this was not a problem and I could migrate the hashed passwords.

Thanks,

HL

Thanks but this doesn't really help in the migration process.

Fortunately, I found http://www.devart.com/forums/viewtopic.php?t=20034 which means I can transfer and use the hashed passwords.

Hi,

I need to retrieve the passwords for my users (as I'm migrating the system).

Originally my web.config was setup like this:



With this, if I call GetMethod I get NotSupportedException "Specified method is not supported.".

I then tried changing:

enablePasswordRetrieval="true"

But I still get the same exception. I'm using Version=4.85.33.0.

I can get the hashed password directly from MySql but I do not know how to decrypt this. I do not have a machineKey element specified in my web.config.

Please advise how I can retrieve my passwords.

Thanks

In Visual Studio 2010 RTM (Version 10.030319.1 RTMReI) on Windows 7 Ultimate 64

1. File | New Project | ASP.NET Web Application

2. Add references to:
Devart.Data (5.0.85.0)
Devart.Data.MySql (5.70.124.0)
Devart.Data.MySql.Web (5.70.124.0)

3. Convert these References to Copy Local = True

4. Setup Connection string in Web.config, e.g.







*** Note this is a new clean empty database which has been setup using the Devart\MyDirect.NET2\InstallWebTables.sql

5. Setup providers, remove other providers and setup Membership Provider:













6. Run project, click Login then Register to create a new user. This new user is added OK and can be seen to be added to the MySql database.

7. Click Login and attempt to login. Always fails.

Note, if the passwordFormat is set to "Clear" this problem does not occur, but if the passwordFormat is set to "Encrypted" then new users cannot be created.

I hope we can get a solution to this soon!

I have the same problem with

Microsoft Visual Studio 2010
Version 10.030319.1 RTMReI
and NET 4

ASP.NET configuration pages display, two of my three providers are listed but clicking test reports:

Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.

I have upgraded an ASP .NET 3.5 project to Visual Studio 2010 .NET 4 with the project migration wizard.

I have also upgrade my previous CoreLab.MySql installation (Version=4.85.33) to the latest MySQL 5.70









Now however, it seems that the providers are not working:
From ASP.NET Web Site administration tool | Provider Configuration
Use this page to select a provider for each feature.

Membership Provider
AspNetSqlMembershipProvider
Test

AspNetMySqlMembershipProvider Test
MyDirect membership provider



Role Provider
AspNetSqlRoleProvider
Test

AspNetWindowsTokenRoleProvider
AspNetMySqlRoleProvider
Test


Note that the Profile provider is missing

When I click the Test link I get:

Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.

Here are my provider definitions:























How can I get these providers to continue to work with the upgrade?

Thanks in advance.

After solving the new issue introduced by the upgrade to 4.70.31 (see above) one of these issues is fixed.

However, there are still open issues:

1: MySqlDataSource does not show up connection stings in the web.config file. e.g Add a MySqlDataSource to a form when there are connection string in the web.config. These do not appear as options and have to be manually added in the ASPX (this used to work fine).

2: There is very little documenation on the design time support for MySqlDataSource. Please provide details of how to use this. In previous versions there was a WHERE button which I chould use to specify a QueryString parameter. It is not clear how this can be done and there is no help. I'm guessing it might be the Select Parameters button but who knows?

For example, I'd like to pass in the QueryString id to the select statement, e.g.

mypage.aspx?id=123

Do I need to write this in the select statement or what? With all the other issues I'm not sure if this feature is present or if there are issues? Please advise.

3: Underscores are added when certain column names are used e.g. id, datetime, data. These need to be manually moved from the ASPX.

A note for anyone else who updates their project to 4.70.31: The provider names have changed

from:

providerName="CoreLab.MySql.Entity"

To:

providerName="CoreLab.MySql"

I found this buried in the release notes only available at http://devart.com/mysqlnet/History.html

HL

I've been using 4.70.30, I'll download 4.70.31 and see how it goes.

Thanks,

Hi,

I don't think that is the cause of the problem as I get the same problem with other column names, e.g.

CREATE TABLE `alpha`.`newtable2` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`contents` VARCHAR(45) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE = InnoDB;

Hi Andrey,

This simple scenario causes a problems. I just want to add a GridView of my table.

Create a simply table

CREATE TABLE `alpha`.`newtable` (
`index` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`data` VARCHAR(45) NOT NULL,
PRIMARY KEY (`index`)
)
ENGINE = InnoDB;

Also add a couple of rows of data.

In Visual Studio 2008: Create a Web application project

Drag a MySQLDataSourced, manually setup the connection strings.

Use ConfigureDataSource, enter select stamtemet:

select * from newtable;

Command Generator | Generate Commands (as instructed)

Add a GridView (using the MySQLDataSource) include Edit and Delete functions.

Run the application, you should see the grid view data with the rows.

Select Edit, then press Update:

The following error:

Server Error in '/' Application.
--------------------------------------------------------------------------------

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'index = NULL))' at line 1

Also, if you try Delete

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'index = NULL))' at line 1

This functionality used to work well in your earlier versions but now it does not. It might be that the Generate Commands is failing, but there is currently little documentation on the subject.

Please advise.

HL

Also, I think it would be very useful to have some instructions how to setup this control. For example, I have a MySQL database I just want to setup a MySqlDataSource control to use that database and use the GridView control with the MySqlDataSource to allow Editing and Deleting of fields.

This was very intuitive with previous versions and worked much like Microsoft's SQLDataSource but now I am getting errors in the GridView control when I press Update and Delete, so I'm guess the Update and Delete strings are not setup correctly. I'd really appreciate some instructions how to use this now.

The MySqlDataSource still does not seem to work correctly in the latest build.

I drag the control onto an ASP.NET form, I can’t chose my existing configuration settings so have to use <%# directives in the tags.

Also, I can’t find much help on it and confess to be confused without any help or documentation. The content in your help pages for the Design Time Support for MySqlDataSource is not very helpful (ms-help://CoreLab.MySql/MyDirect/SqlDataSource.html). Is there any information about the various tabs? Specifically the Select Parameters tab.

I am disappointed that the functionality in this control which featured in the trial version (a few months ago) is now not included.