Hi all,
I transfered my mssql database to a mysql database (different webhost). It was difficult but I succeeded. Yeeh!
Now I need to use a ODBC Connection. My webhost gave me the connectionstring below, however my webpage gives the following error:
System.ArgumentException: Keyword not supported: 'driver'.
I think I have to adjust my code. I already changed SqlConnection into OdbcConnection, SqlCommand into OdbcCommand etc.
Could someone please help me? (I am new to programming)
The code I've got so far:
Imports Microsoft.Data.Odbc
Imports System.Data
Partial Class Bedrijvenindex
Inherits System.Web.UI.Page
Sub drpCategorie_SelectedIndexChanged(ByVal s As Object, ByVal e As EventArgs)
adsrechts.Visible = "true"
'geselecteerde CategorieID uitlezen
Dim intCategorieID As Integer = drpCategorie.SelectedItem.Value
'verbinding maken met de database en juiste bedrijven ophalen
Dim conBedrijf As OdbcConnection
Dim ConnectionString As String = "Driver={MySQL ODBC 5.1 Driver};Server=***;Database=***;User=***; Password=***;Option=3;"
Dim cmdSelectBedrijf As OdbcCommand
Dim OdbcString As String
conBedrijf = New OdbcConnection(ConnectionString)
conBedrijf.Open()
OdbcString = "SELECT * from Bedrijf WHERE CategorieID="
OdbcString &= intCategorieID
If intCategorieID = "6" Then OdbcString = "SELECT * from Bedrijf"
If intCategorieID = "0" Then OdbcString = "SELECT * from Bedrijf WHERE CategorieID=0"
If intCategorieID = "0" Then adsrechts.Visible = "false"
Dim dtrBedrijf As OdbcDataReader
conBedrijf = New OdbcConnection(ConnectionString)
conBedrijf.Open()
cmdSelectBedrijf = New OdbcCommand(OdbcString, conBedrijf)
dtrBedrijf = cmdSelectBedrijf.ExecuteReader()
'opgehaalde gegevens binden aan repeater
rptCategorie.DataSource = dtrBedrijf
rptCategorie.DataBind()
dtrBedrijf.Close()
conBedrijf.Close()
End Sub
End Class
