0

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?

3
Contributors
3
Replies
4
Views
11 Years
Discussion Span
Last Post by peter_budo
0

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()

0

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.