SQL server doesn't support Index funcationality??

SQL server doesn't support Index funcationality??

Post by ZJH » Thu, 24 May 2001 17:07:18



Hi,
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??

Thanks,
ZhenJienHou

 
 
 

SQL server doesn't support Index funcationality??

Post by Stephen How » Thu, 24 May 2001 21:26:46



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??

Nothing.

SQL Server provider does not support Index. Nor does it support Seek.
Have a look at the Supports() method for a recordset.

You will find that Oracle, SqlServer, ODBC providers don't support some ADO
functionality. It is most noticeable with ADOX where many things like views,
groups are not supported.

It seems that only the Jet provider (Access) supports all of ADO.

Stephen Howe

 
 
 

1. SQL server doesn't support Index functionality??

Hi,
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??

Thanks,
ZhenJienHou

2. Sqlserver version

3. class doesn't support automation or doesn't support expected interface

4. SQL Optimal Requirements

5. Unable to Validate Product Key

6. SQLOLEDB doesn't support ADO index/seek?

7. File Browser "FileFilters" not sticky

8. Doesn't ADODC support indexed tables?

9. SQL Anywhere doesn't support latest compilers

10. Sql Monitor doesn't support IPX/SPX?

11. Indexed view doesn't appear to be using index on queries

12. index scan with index cond on first column doesn't