ASP.NET/MySQL Connector woes.
Hi good people, I'm working with asp.net with a mysql database back-end.Im using the mysql connector/net version 6.1 .Iv installed it, changed the machine.config and web.config files as instructed here-----> http://www2.nl.freebsd.org/mysql/doc/refman/5.0/en/connector-net-programming... The result is when I try to build my application this is the error message I get: Could not load file or assembly 'MySql.Web, Version=6.0.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies Iv tried adding the references MySql.Data and MySql.Web which were added when I installed the connector but there's no change. I was previously using the ODBC 3.51 driver which was working well with me but the rest of my development team is using this .Connector/net and they've built working files with it so I cant backtrack. Please help. Regards --
Hallo,This situation used to arise for me when you use a dll thats different from the one the other team members are using. Most probably your is the latest and they are using and older version So you keep getting a version error cause the settings on the web.config dont match those on your machine. If you copied the web.config from someone else.You can maybe back it up and then remove some of those mysql connection settings then try reference them again see if the new settings u get will sort you out. But merging files could be drama later on if your using any subversion software. 2009/8/24 Edwin Wambua <eddwak@gmail.com>
Hi good people,
I'm working with asp.net with a mysql database back-end.Im using the mysql connector/net version 6.1 .Iv installed it, changed the machine.config and web.config files as instructed here-----> http://www2.nl.freebsd.org/mysql/doc/refman/5.0/en/connector-net-programming... The result is when I try to build my application this is the error message I get:
Could not load file or assembly 'MySql.Web, Version=6.0.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies
Iv tried adding the references MySql.Data and MySql.Web which were added when I installed the connector but there's no change. I was previously using the ODBC 3.51 driver which was working well with me but the rest of my development team is using this .Connector/net and they've built working files with it so I cant backtrack. Please help. Regards --
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
Thanks Kenoti. I had edited the web.config files and machine.config again and the annoying errors went, except one.Now the issue left is with the mySqlRole provider.It cant load the file yet I've edited the machine and web configurations to include the role provider.I'll try your suggestion. P.S. This is one of the reasons why I prefer php to asp.net or anything in that .NET framework.
Hallo,With the mysql role provider thats to help you with the login and so you have to check in with the asp.configuration tool Thats on the edit menu or one of the top menus.Should be the last or second last item on the menu. It will show you if you have the providers loaded up. May need to force the web.config to ignore the default connection settings and check your mysql database. <connections> <remove/> not sure if its accurate </connections> Then make sure the provider tables exist in your mysql database to add edit delete users,roles etc Usually bout 11 - 12 tables that are need to allow for authentication The other reason could be that your missing the classes for authentication from your application, so it doesnt know how to authentcate. Can look scott gurie and this links http://msdn.microsoft.com/en-us/asp.net/aa336558.aspx This ones abit of a run down on the authentication model used in the asp.netpages.Can change it to suite any other database http://www.c-sharpcorner.com/UploadFile/jmcfet/Provider-basedASP.NET10162006... http://www.4guysfromrolla.com/articles/052009-1.aspx Make sure you however confirm with the asp.configuration tool that its detecting the mysql authentication files.Should have a testing tab to show that it can connect to using the mysql provider otherwise could still be checking on the default sql server database for authentication. 2009/8/26 Edwin Wambua <eddwak@gmail.com>
Thanks Kenoti. I had edited the web.config files and machine.config again and the annoying errors went, except one.Now the issue left is with the mySqlRole provider.It cant load the file yet I've edited the machine and web configurations to include the role provider.I'll try your suggestion.
P.S. This is one of the reasons why I prefer php to asp.net or anything in that .NET framework.
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
participants (2)
-
Edwin Wambua -
kenoti maembe