passing parameter to rdo connection

[jozino01]

hi,

i am using rdo odbc text driver for vb6. i can open and read the file:

Set en = rdoEngine.rdoEnvironments(0)
With cn
.CursorDriver = rdUseOdbc
.Connect = "DRIVER={Microsoft Text Driver (*.txt;" & _
" *.csv)};DBQ=c:\mcp;"
.EstablishConnection rdDriverNoPrompt, False
End With
Set rs = cn.OpenResultset("select * from [addresses#txt]")
While Not rs.EOF
Combo3.AddItem (rs!address1)
rs.MoveNext
Wend

but the following command:

Set rs = cn.OpenResultset("select * from [addresses#txt] where address1 ='" & Combo3.Text & "'")


is giving me an error message - Run time error 40002. selected collating sequence not supported by the operating system.

any idea what's wrong (syntax?)/how to fix it?