|
The only issue I can see is that the tilde (~) might not be parsed by the server because it is in the config file. Have you tried to use a relative path (eg "/cookies/")?
Does the cookies directory exist?
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|
|
Hello J Snyman,
Compliments for the article is very interesting
I use Visual Studio 2008 c#, mysql 5 and ADO.NET Driver for MySQL (Connector/NET)
I am trying to work your suite, but I have difficulties.
In Web Site Administration Tool
-------------------------------------------------------------------
An exception occurred communicating with the data source.
Action: GetAllUsers
Exception: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][Driver Manager ODBC] Nome origine dati non trovato e driver predefinito non specificato.
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConnection.Open()
at Simple.Providers.MySQL.MysqlMembershipProvider.GetAllUsers(Int32 pageIndex, Int32 pageSize, Int32& totalRecords)
Per ulteriori informazioni, consultare la Guida in linea e supporto tecnico
-------------------------------------------------------------------
In login.aspx
-------------------------------------------------------------------
System.InvalidOperationException non è stata gestita dal codice utente
Message="The ConnectionString property has not been initialized."
Source="System.Data"
StackTrace:
at System.Data.Odbc.OdbcConnection.PermissionDemand()
at System.Data.Odbc.OdbcConnectionFactory.PermissionDemand(DbConnection outerConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConnection.Open()
at Simple.Providers.MySQL.MysqlMembershipProvider.ValidateUser(String username, String password)
at _Default.Login1_Authenticate(Object sender, AuthenticateEventArgs e) in c:\Inetpub\wwwroot\sito\Default.aspx.cs:line 34
at System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e)
at System.Web.UI.WebControls.Login.AttemptLogin()
at System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e)
at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
at System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
InnerException:
-------------------------------------------------------------------
Thanks
|
|
|
|
|
The example above uses the MySQL ODBC driver, not the .NET driver.
|
|
|
|
|
As the Order Alphabetically by MySqlSiteMapProvider us children, or qdo I add an item on the menu I would like the Parent Title him he was Sorted Alphabetically or is not
If pd help me now thank you
<div class="ForumSig">LADEF</div>
|
|
|
|
|
Hello J. Snimman at least managed to put the already My Menu with MySQLSITEMAPPROVIDER using MYSQLCONNECTOR 5.0 in the air, now I would like to know if there any article or link that based on his or Article code of example that nôs teaches itself as customize the menus based on user profiles, or would be accessible to each user a menu or menus for it if there is any link please ask if I could pass. Sincerely and now thank
LADEF
|
|
|
|
|
But I wonder if taking advantage vc have an article based on this same driver MySQLCONNECTOR 5.0 on the ASPNETDB such as HTTP LINK
Http://forums.mysql.com/read.php?60, 119245.119245
Or based on the structure of the tables MYSQLSITEMAPPROVIDER as harness would get them into FORMS AUTHENTICATIONS with Login and Password with rules set for cd Profile usuário.Se pd me spend a HTTP on some kind of your article so I am already grateful
LADEF
|
|
|
|
|
How would the WEBCONFIG, based on the article of the Voloda with MySqlConnector since Article Voloda do not have the WebConfig or what would have to change in relation to your WebConfig for use with MySQLCONNECTOR 5.0 is pd help me now thank you
LADEF
|
|
|
|
|
I would like to know if is to help me take some questions about the article if possible
Doubts 1) The article is for the driver - MySql Odbc driver to adapt the code for use with the driver MYSQL5.0 CONNECTOR
Doubts 2) What do I use as given in the Table of ApplicationName sitemap of db DBStructure.sql that it provides to download the article fz
Doubts 3) In WEBConfig what to say about that
/ *! Please replace the App Your Name) (instances with a valid
Application Name. The application name should not contain
Any spaces or special characters. ! * /
If pd help me now thank you
LADEF
|
|
|
|
|
Hi...
Please try to be more clear on what you want. Punctuation might help as well. I just can't understand what you want!
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|
|
OK here are the answers
1) Using the driver MYSQLCONNECTOR 5.0 in this article what I have to change in the code in webconfig?
2) What data or information which I place on the field in the table ApplicationName sitemap of bd coming downloading article
And
3) What I have to ask where kj says
/ *! Please replace the App Your Name) (instances with a valid
Application Name. The application name should not contain
Any spaces or special characters. ! * /
At. Luiz - Brazil - Itatiba-SP - I am using google translation, I do not understand much English, but if pd help me now thank you
LADEF
|
|
|
|
|
|
2 and 3) Replace all instances of "Your Name App" in the web.config with a short name for its implementation. The short name will also be used under sitemap.
I could understand, but in the case the name of its implementation would be short NAME OF THE ARCHIVE PROJECT eg.
On the code below that name would be short MeuMenuDinamico?
Using System;
Using System.Data;
Using System.Configuration;
Using System.Collections;
Using System.Web;
Using System.Web.Security;
Using System.Web.UI;
Using System.Web.UI.WebControls;
Using System.Web.UI.WebControls.WebParts;
Using System.Web.UI.HtmlControls;
Namespace MeuMenuDinamico
(
Public partial class _Default: System.Web.UI.Page
(
Protected void Page_Load (object sender, EventArgs e)
(
)
Protected void Menu1_MenuItemClick (object sender, and MenuEventArgs)
(
Switch (e.Item.Value)
(
Case "Products":
SiteMapDataSource2.StartingNodeUrl = "Default.aspx? Hardware node =";
Return;
Case "Services":
SiteMapDataSource2.StartingNodeUrl = "Default.aspx? Consulting node =";
Return;
Case "Support":
SiteMapDataSource2.StartingNodeUrl = "Default.aspx? Node = drivers";
Return;
)
)
)
)
If pd help me now thank and in the case of Article of Voloda if the link would get me the same move if possible
LADEF
|
|
|
|
|
2 & 3) Yes... That is correct...
What is pd?
I don't understand your last line... "If pd help me now thank and in the case of Article of Voloda if the link would get me the same move if possible"
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|
|
I do the LINK TO ARTICLE VOLODA SE POSSIVEL this is what I say in the last line
And name of the application is MeuMenuDinamico correct?
LADEF
|
|
|
|
|
And name of the application is MeuMenuDinamico correct? - YES!
I do the LINK TO ARTICLE VOLODA SE POSSIVEL this is what I say in the last line - You do the link? What do you mean, DO the link?
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|
|
Thanks for the tip MeuMenuDinamico that part I understand in the case of link am asking the address of the http or
Http://www.codeproject.com/KB/webforms/MySQLsuite.aspx?msg=2483671 # xx2483671xx
But the address of the article VOLODA
LADEF
|
|
|
|
|
|
The ok Thanks JacquesSnyman that is exactly what I wanted to little we really googlando the translator google is confusing at times but now I will help examine a little the http address of the VOLODA I went any doubt very much that I return
LADEF
|
|
|
|
|
What we need to change or implement in WebConfig, Na ConnectionString or the code of MySqlSiteMapProvider to be accepted in connection with the driver MySql 5.0 MySQL CONNECTOR one of the most used at the time
Add the connection string to your newly created database to the connectionStrings section, eg <Add connectionstring = "MySQL ODBC driver = (3.51) Driver; server Your Server IP = (); port = (Your Server Port No.); option = 3; database New Database Name = (); uid = (Your username) ; pwd = () Your password "name =" SimpleProviderConnectionString "providername =" System.Data.Odbc "/>.
At. Luiz - Itatiba-SP - Brazil
LADEF
|
|
|
|
|
Do I have to call INitialize() manually when I instantiate any of the provider classes?
If so, what am I supposed to pass for the 2nd parameter?
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
Hi...
No... It is not neccessary to call Initialize() manually. If you define the provider in the web.config, the .NET framework will initialize them for you.
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|
|
|
I get an error in line 155 "foreach (SettingsProperty prop in ppc)" about an unsupported property? Any ideas?
.
.
.
public override SettingsPropertyValueCollection GetPropertyValues (SettingsContext context, SettingsPropertyCollection ppc)
{
string username = (string)context["UserName"];
bool isAuthenticated = (bool)context["IsAuthenticated"];
// The serializeAs attribute is ignored in this provider implementation.
SettingsPropertyValueCollection svc = new SettingsPropertyValueCollection();
foreach (SettingsProperty prop in ppc)
.
.
.
|
|
|
|
|
This functionality is provided in the MySQL Connector/NET's MySql.Web.dll. No need to build your own!
MySql.Web.Security.MySqlRoleProvider and MySql.Web.Security.MySqlMembershipProvider
Mikko
|
|
|
|
|
That's true as for Membership and Roles, but Profile has yet to be implemented?
|
|
|
|