Article Discussion: Programming with MySQL database and Microsoft .NET Technology

If you have any questions or comments on this article then please post them here.

This forum post relates to this article

Hi,

I have just started to develop with MYSQL.
I have a local installation of the MySql db, and am trying to connect to it using .Net 2.0


Here is my connection string.
<add connectionString="Data Source=localhost;Database=KAW_WEB_USER;User ID=root;Password=xxxxx" name="MySqlServer"/>

Now when I go to a page which tries to connect to the db, it gives me this error: I do not get any opportunity to get in the code to any of my breakpoints.

==================================
Exception Details: System.SystemException: The trust relationship between this workstation and the primary domain failed.
Stack Trace:

[SystemException: The trust relationship between this workstation and the primary domain failed.
]
System.Security.Principal.NTAccount.TranslateToSid s(IdentityReferenceCollection sourceAccounts, Boolean& someFailed) +1167
System.Security.Principal.NTAccount.Translate(Iden tityReferenceCollection sourceAccounts, Type targetType, Boolean& someFailed) +42
System.Security.Principal.NTAccount.Translate(Iden tityReferenceCollection sourceAccounts, Type targetType, Boolean forceSuccess) +46
System.Security.Principal.WindowsPrincipal.IsInRol e(String role) +205
System.Web.Configuration.AuthorizationRule.IsTheUs erInAnyRole(StringCollection roles, IPrincipal principal) +166
System.Web.Configuration.AuthorizationRule.IsUserA llowed(IPrincipal user, String verb) +393
System.Web.Configuration.AuthorizationRuleCollecti on.IsUserAllowed(IPrincipal user, String verb) +263
System.Web.Configuration.AuthorizationSection.IsUs erAllowed(IPrincipal user, String verb) +45
System.Web.Security.UrlAuthorizationModule.OnEnter (Object source, EventArgs eventArgs) +286
System.Web.SyncEventExecutionStep.System.Web.HttpA pplication.IExecutionStep.Execute() +167
System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, Boolean& completedSynchronously) +117
=========================================

But if i start the application with a different connection string, like the one i used for SQL server: It errors out as while connecting, and I am able to debug et all.
Now I go back in and change the connection string to the actual one, i can go back to that page, and connect to the database just fine. But then it comes back to that “Trust” error randomly.

Any idea what is going on here?

All the elements are on my development machines. MySql server, IIS server, code all..

Any insight will be welcome.

-Jainnys
http://www.mindexp.com
Mind Experts Inc.