Salve a tutti.
Ho creato una pagina che deve fare il login a un'area riservata del sito.
Inserendo i dati username e password, viene fatto il controllo su una tabella del db.
Se i dati sono presenti allora entro nell'area riservata.
Nella pagina di login ho dichiarato la stringa di connessione da utilizzare che è memorizzata nel web.config.
Utilizzo un database MYSQL.
Ho questo problema, quando faccio click sul bottone di accesso:
-----------------------------------------------------------------
Server Error in '/' Application.
Format of the initialization string does not conform to specification starting at index 0.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0.
Source Error:
Line 14: Dim query As String = "<%$ConnectionString:gdlgestionaledb%>"
Line 15:
Line 16: conn = New OdbcConnection(query)
Line 17: conn.Open()
Line 18:
Source File: C:\Inetpub\vhosts\gdl-connect.eu\httpdocs\Login.aspx Line: 16
-------------------------------------------------------------------
Grazie dell'aiuto.
Il codice della pagina che va in errore è il seguente:
<%@ Page Language="VB" Debug="true"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.Odbc" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim conn As OdbcConnection
Dim cmd As OdbcCommand
Dim dr As OdbcDataReader
Dim query As String = "<%$ConnectionString:gdlgestionaledb%>"
conn = New OdbcConnection(query)
conn.Open()
cmd = New OdbcCommand("SELECT id FROM connect_clienti", conn)
dr = cmd.ExecuteReader
dr.Close()
conn.Close()
End Sub
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title></title>
<style type="text/css">
.style1
{
width: 55%;
}
.style2
{
width: 43%;
}
.style3
{
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<table align="center" class="style1">
<tr>
<td align="center">
<img alt="" src="immagini/GdlConnect.jpg" /></td>
</tr>
<tr>
<td align="center">
<table class="style2">
<tr>
<td align="right" class="style3">
Codice utente</td>
<td>
<asp:TextBox ID="Username" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="Codice utente non inserito" Text="*" ControlToValidate="UserName" ForeColor="Red"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right" class="style3">
Password:</td>
<td>
<asp:TextBox ID="Password" runat="server" TextMode="Password"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"
ErrorMessage="Password non inserita" Text="*" ControlToValidate="Password"
ForeColor="Red"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right" class="style3">
</td>
<td align="left">
<asp:Button ID="Button1" runat="server" Text="Accedi" BackColor="#663333"
BorderColor="#663333" ForeColor="White" onclick="Button1_Click" />
</td>
</tr>
<tr>
<td align="left" colspan="2">
<asp:ValidationSummary ID="ValidationSummary1" runat="server"
HeaderText="Elenco errori:" ForeColor="Red" >
</asp:ValidationSummary>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="center">
<img alt="" src="immagini/GdlStudio.jpg" /></td>
</tr>
</table></div>
</form>
</body>
</html>
