Member Avatar for smariano77

Hi, I have this connction string:

Private conexion As New OdbcConnection("DRIVER={MySQL ODBC 5.1.50 Driver}; SERVER=localhost; DATABASE=netstore; UID=root; PASSWORD=123456; OPTION=3")

I use:
Visual Studio 2010
MySQL 5.1.50

When I try to open the connection, this error appears:
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

I google it a lot, and I found somethins about privileges. I try this: "GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';".

But nothing, the thing it's that all works fine from the SQL Manager.
I'm without a clue.

Any idea???

Thanks in advance.

  • 1 Contributor
  • 1 Reply
  • 85 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by smariano77
Member Avatar for smariano77

by the way, I'm using
Imports System.Data.Odbc

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.