Results 1 to 2 of 2

Thread: mysql db error

  1. #1
    Join Date
    Oct 2005
    Posts
    15

    Unanswered: mysql db error

    Can someone tell if the following connection has been set properly?

    my connection in my vb app to access db works fine

    ' Opens the Access database.
    Set conn = New ADODB.Connection
    conn.ConnectionString = _
    "Provider=Microsoft.Jet.OLEDB.4.0;" & _
    "Data Source=" & txtAccessFile.Text & ";" & _
    "Persist Security Info=False"
    conn.Open

    but this one is problamatic:

    ' Opens the MySQL database.
    Set c3 = New ADODB.Connection
    c3.ConnectionString = _
    "Provider={MySQL ODBC 3.51 Driver};database=pacs;" & _
    "Data Source=" & txtMySQLFile3.Text & ";" & _
    "Persist Security Info=False"
    c3.Open

    Error = Provider cannot be found. It may not be properly installed

    Thanks

  2. #2
    Join Date
    Sep 2004
    Posts
    1
    try this one....
    con.ConnectionString = "Driver={MySQL ODBC 3.51 Driver};Server=[your server name or ip] ;Port=3306;Option=131072;Stmt=;Database=[your database name];Uid=[user id];Pwd=[password]

    -ramamurthi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •