I've used VB to connect SQL Server 2000 named 'PLATINUM' with following code:
Set rs = New ADODB.RecordSet
rs.CursorLocation = adUseServer
rs.Open "Stock", "Provider=SQLOLEDB;Server=PLATINUM;Database=Product;UID=user;PWD=
user", adOpenKeySet, adLockOptimistic, adCmdTableDirect
If rs.Supports( adIndex) and rs.Supports( adSeek ) Then
rs.Index = "idxStockWarehouse"
the error occurs at the index setting line, although the recordset supports all
requirements specified in ADO help. The error said "Current provider does not
support the necessary for Index functionality.". What's wrong with this??