is this possible, i had to use the mysql class to connect to the database, but i would rather use oledb.

the connection string i used is "Provider=MySQLProv;Data Source=mySQLDB;User Id=myUsername;Password=myPassword"

when i try to connect a popup titled "MySql Data Source Name Setup" always comes up. even if i try entering the login information i fail to connect. Has anyone else experienced this and/or knows the solution?

guess this isnt possible, DX

This is how I use the OleDb...

Imports System.Data.OleDb


Dim connectString As String

Dim sqlString As String

Dim ObjConnection As OleDbConnection

Dim objCmd As OleDbCommand


connectString = "Provider=SQLOLEDB;Data Source=PFCI-DB1;Initial Catalog=Master_Training;Persist Security Info=True;User ID=mt;Password=training"
sqlString = "Update "

ObjConnection = New OleDbConnection(connectString)
objCmd = New OleDbCommand(sqlString, ObjConnection)
ObjConnection.Open()
objCmd.ExecuteNonQuery()
ObjConnection.Close()

1) you just bumped 2 years old post
2) you are not using coding tags
3) you did not mention the language you using (i guess it is VB) and we do not know what language plazmo been using in that time

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.