ODBC driver does not support the requested properties

[achmad abed]

Hey guys,

I have the following problem. I'm trying to get something from a database and i'm using this code:

Code:
Private Sub button_click()
Dim a
Dim rss As New ADODB.Recordset
dim str as string

str = text1.text
rss.Open "select Setting from list WHERE id = '" & str & "'", Mysql_Connection, adOpenStatic, adLockReadOnly
a = rss!Setting

rss.Close
end sub



So now if i press on button it wil get the data and the code works but if i press a couple of minutes later on the button i get this error:

Run-time error '-2147217887 (80040e21)':

ODBC driver does not support the requested properties.

so the code works but i cant use it twice.