Geek Answers Handbook

The odbc driver does not support requested properties

The odbc driver does not support the requested property errors when starting the program on the last line, can someone please give me an idea.

Dim conn As New ADODB.Connection
Dim rsRec As ADODB.Recordset
Dim cmd As ADODB.Command
Dim query As String

Set conn = New ADODB.Connection
Set rsRec = New ADODB.Recordset

conn.connectionString = "DRIVER={MySQL ODBC 3.51 Driver}; Server=127.0.0.1 ;Database=try;User=root;Password=root;"

conn.Open

query = "INSERT INTO user_table (Name)"
query = stSQL & "VALUES (Anupam)"

rsRec.Open query, conn, adOpenDynamic, adLockOptimistic
+4
source share
1 answer

Try the following: -

Dim conn As New ADODB.Connection
Dim rsRec As ADODB.Recordset
Dim cmd As ADODB.Command
Dim query As String

Set conn = New ADODB.Connection
Set rsRec = New ADODB.Recordset

conn.connectionString = "DRIVER={MySQL ODBC 3.51 Driver}; Server=127.0.0.1 ;Database=try;User=root;Password=root;"

conn.Open

query = "INSERT INTO user_table (Name) VALUES (Anupam)"

rsRec.Open query, conn, adOpenDynamic, adLockOptimistic
+1
source

More articles:


All Articles