---
title: "Connect to mySQL"
type: "forum-thread"
url: "https://www.webforum.nu/amne/dotnet/75194-connect-to-mysql"
topic: ".NET"
topic_url: "https://www.webforum.nu/amne/dotnet"
author: "icaaq"
published: "2003-04-27T16:13:19.000Z"
updated: "2003-04-29T15:58:44.000Z"
replies: 5
views: 314
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/dotnet/75194-connect-to-mysql"
---

# Connect to mySQL

## #1 — icaaq, 2003-04-27T16:13Z

Hur ser en mySql Connectionstring ut i .NET??

Mvh icaaq

Permalänk: https://www.webforum.nu/p/75194

## #2 — P, 2003-04-27T17:51Z

<https://www.connectionstrings.com> ?

Permalänk: https://www.webforum.nu/p/1026307

## #3 — cyprys, 2003-04-27T18:12Z

Tanka MyOLEDB från <https://www.mysql.com> och sen typ

"Provider=MySQLProv;Data Source=databasnamn;"

Permalänk: https://www.webforum.nu/p/1026324

## #4 — PatrikB, 2003-04-27T22:08Z

Typ så här kan det se ut:

```
<%@ Page Language="VB" Trace="True" %>
<%@ import Namespace="Microsoft.Data.Odbc" %>
<script runat="server">

    Public Sub Page_Load(Sender As Object, E As EventArgs)
        Dim ldsn As String = "driver=mysql;server=localhost;database=db-namn;uid=anvandarnamn;pwd=losenord"
        Dim query As String = "SELECT * FROM Statistics"
        Dim cnnS As New OdbcConnection(ldsn)
        Dim cmdS As New OdbcCommand(query, cnnS)
        cnnS.Open()
    
        Dim drS As OdbcDataReader = cmdS.ExecuteReader()
    
        DataGrid1.DataSource = drS
        DataGrid1.dataBind()
    
        drS.Close()
    
        cnnS.Close()
    End Sub

</script>
<html>
<head>
</head>
<body>
    <form runat="server">
        <asp:DataGrid id="DataGrid1" runat="server"></asp:DataGrid>
    </form>
</body>
</html>
```

cya,
PatrikB

Permalänk: https://www.webforum.nu/p/1026499

## #5 — P, 2003-04-28T11:01Z

Har du version 1.1 så finns Odbc i System.Data.Odbc tror jag

Permalänk: https://www.webforum.nu/p/1026723

## #6 — icaaq, 2003-04-29T15:58Z

TAck

Permalänk: https://www.webforum.nu/p/1030562

---

Tråden på webben: https://www.webforum.nu/amne/dotnet/75194-connect-to-mysql
