Good evening!

I'm getting the following error when trying to create a recordset from
a .dbf table.
The error line is :

    recMyRecordSetTAPE1.Open "SELECT billname, mtgss FROM TAPE1.DBF", 

The error message is : 'Selected collating sequence not supported by the operating system'.
I am totally lost here. Any help is greatly appreciated.


Here is my code:

' Connection to TAPE1.DBF
    Set cnMyConnectionTAPE1 = New Connection
    Set recMyRecordSetTAPE1 = New Recordset
    cnMyConnectionTAPE1.Open "Driver={Microsoft dBASE Driver (*.dbf)};" & _
                  "DriverID=277;" & _
                  "Dbq=j:\euc_database;"
    ' Build the record set
    Set recMyRecordSetTAPE1.ActiveConnection = cnMyConnectionTAPE1
    recMyRecordSetTAPE1.CursorType = adOpenDynamic
    recMyRecordSetTAPE1.LockType = adLockBatchOptimistic
    recMyRecordSetTAPE1.Open "SELECT billname, mtgss FROM TAPE1.DBF", cnMyConnectionTAPE1
    ' Bind the textcontrols
    Set Text5.DataSource = recMyRecordSetTAPE1
    Set Text6.DataSource = recMyRecordSetTAPE1
    Text5.DataField = "billname"
    Text6.DataField = "mtgss"

Thanks,
Sergio