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?
Jump to PostThis is how I use the OleDb...
Imports System.Data.OleDb
Dim connectString As StringDim 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)
…
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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.