connessione MYsql odbc

**davfrata** · 05-06-2013, 12:36

cosa sbaglio???

upload.ashx

codice:

<%@ WebHandler Language="VB" Class="Upload" %>

Imports System
Imports System.Web
Imports System.IO
Imports System.Data


Public Class Upload : Implements IHttpHandler
    
    Dim myConnection As Odbc.OdbcConnection
    Dim id As Integer = 0
    Dim tipo As String = ""
    
    Public Sub connessione()
        Try
            Dim sPort As String = 3306
            Dim sServer As String = "localhost"
            Dim sUserID As String = "xxxx"
            Dim sPassword As String = "xxxx"
            Dim sDb As String = "xxxxx"
            Dim stringa As String = String.Format("DRIVER={{MySQL ODBC 3.51 Driver}};Server={1};Port={0};database={4};UID={2};Password={3}", sPort, sServer, sUserID, sPassword, sDb)
            Dim Conn_str As Odbc.OdbcConnectionStringBuilder = New Odbc.OdbcConnectionStringBuilder
            Conn_str.ConnectionString = stringa


            myConnection = New Odbc.OdbcConnection(Conn_str.ConnectionString)
            myConnection.Open()
            Console.WriteLine(myConnection.ServerVersion)
        Catch e As Odbc.OdbcException
            MsgBox(e.Message)
        End Try

    End Sub
.................

upload.aspx

codice:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Dprove upload multiplo con Asp.NET</title>

<script type="text/javascript" src="scripts/jquery-1.4.1.min.js"></script>
<script type="text/javascript" src="scripts/swfobject.js"></script>
<script type="text/javascript" src="scripts/jquery.uploadify.v2.1.0.min.js"></script>
<link rel="stylesheet" type="text/css" href="Css/uploadify.css" />

<script type="text/javascript">
	$(function() {
		$('#uploadify1').uploadify({
			'uploader': 'scripts/uploadify.swf',
			'checkScript': 'scripts/Check.ashx?id=<%=request.querystring("id")%>',
			'script': 'scripts/Upload.ashx?id=<%=request.querystring("id")%>',
			'folder': '<%=request.querystring("tipo")%>',
			'cancelImg': 'images/annulla.gif',
			'multi': true,
			'fileDesc': 'Immagini JPEG, PNG',
			'fileExt': '*.jpg;*.png;',
			'sizeLimit': '4194304',
			'buttonImg': 'images/carica.gif',
			'rollover': true,
			'width': '135',
			'height': '28',
			'auto': true,
			'onComplete': function (a, b, c, d, e) {
				//codice da incorporare
			}
		});
	});
</script>
</head>
.............

in locale mi da errore:

ERROR [IM002] [Microsoft][Driver Manager ODBC] Nome origine dati non trovato e driver predefinito non specificato.

ma il driver 3.51 c'è perché lo utilizzo benissimo con asp puro

spero che basti questo

**davfrata** · 05-06-2013, 13:05

mi rispondo da solo

Dim stringa As String = String.Format("DRIVER={{MySQL ODBC 3.51 Driver}};Server={1};Port={0};database={4};UID={2}; Password={3}", sPort, sServer, sUserID, sPassword, sDb)

non è UID ma User

Discussione: connessione MYsql odbc

Strumenti discussione

Ricerca discussione

Visualizza

connessione MYsql odbc

Permessi di invio