'odbc driver does not support the requested properties

odbc driver does not support the requested properties error come when we run the program at last line can anyone please give me 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
mysqlvbaodbc


Solution 1:[1]

I must note that this error is somewhat confusing since it also occurs when there is ANY typo in the SQL statement. I for example had this error because a table was renamed and therefore did no longer exist. When you encounter this error, check the spelling of all parameters and the table names.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Steven T

Related Questions