Bonjour,
J’ai un probleme de connexion à ma base de dopnnées mysql sur le serveur mysql9.webcontrolcenter.com.
Voici le code de ma page test.aspx :
-------------------------------------------------------------------------------------------------------------------------------------------------------------
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.Odbc" %>
<html>
<script language="VB" runat="server">
Sub btn_click(Sender As Object, E As EventArgs)
Dim LE_DSN
Dim MaConnexion
Dim ServerAddress
Dim DBName
Dim UID
Dim Password
ServerAddress = "mysql9.webcontrolcenter.com"
DBName = "nogentinformatiquedb"
UID = "dubrayjimmy"
Password = "margaret"
LE_DSN = "driver={MySql};server=" & ServerAddress & ";db=" & DBName & ";user id=" & UID & ";pwd=" & Password & ";option=16386"
Set MaConnexion = Server.CreateObject("ADODB.Connection")
MaConnexion.ConnectionTimeout = 30
MaConnexion.CommandTimeout = 30
MaConnexion.Open LE_DSN
End Sub
</script>
<body>
<h3><font face="Verdana">P'tits trucs bidons !!!!</font></h3>
<form action="test.aspx" runat=server>
<asp:button text="Click me" style="font: 8pt verdana;background-color:lightgreen;border-color:black;width:100" onclick="btn_click" runat="server"/>
</form>
</body>
</html>
-------------------------------------------------------------------------------------------------------------------------------------------------------------
A priori, rien de bien complexe, mais lorsque j’ajoute la ligne :Set MaConnexion = Server.CreateObject("ADODB.Connection")
ma page me retourne une erreur.
Aurai-je un probleme de librairie ?
Merci de m’aider svp car je bloque litéralement sur ce probleme