forbindelse til mysql

Se evt. http://weblogs.dotnetforum.dk/guidmaster/archive/2003/11/21/469.aspx

Du kan gøre dette her:

<%@ Import Namespace="System.Data.Odbc" %>
<%
    Dim con As OdbcConnection = New OdbcConnection ("DRIVER={MySQL};SERVER=server;DATABASE=db;UID=navn;PWD=123456;OPTION=1123")
    con.Open
    Dim sel As OdbcCommand = New OdbcCommand ("SELECT id FROM tabel", con)
    Dim rdr As OdbcDataReader = sel.ExecuteReader
    rdr.Read
    Response.Write rdr(0)
    rdr.Close
    con.Close
%>

Men:

1)  skift til ByteFX eller MySQL .NET provider for MySQL

2)  overvej at bruge en af de smarte web kontroller

    (læs mere her http://samples.gotdotnet.com/quickstart/aspplus/doc/webdataaccess.aspx)

> arne_v

hvis jeg bruger :

<%@ Import Namespace="System.Data.Odbc" %>
<%
    Dim con As OdbcConnection = New OdbcConnection ("DRIVER={MySQL};SERVER=server;DATABASE=db;UID=navn;PWD=123456;OPTION=1123")
    con.Open
    Dim sel As OdbcCommand = New OdbcCommand ("SELECT id FROM tabel", con)
    Dim rdr As OdbcDataReader = sel.ExecuteReader
    rdr.Read
    Response.Write rdr(0)
    rdr.Close
    con.Close
%>


Får jeg denne fejl :

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30035: Syntax error.

Source Error:



Line 8: 
Line 9:      rdr.Read
Line 10:    (Response.Write rdr(0))
Line 11:    rdr.Close
Line 12:

Prøv lige med parenteser omkring:

Response.Write(rdr(0))

mange tak - så virker det

kan du så få lavet et svar :o)

kommer her