Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DMorley
Starting Member
2 Posts |
 Posted - 2003-02-07 : 06:37:41
|
| I'm trying to set an index over a SQL Server table that has a multi-column primary key so I can use the ADO 'Seek' method. I'm using ADO 2.7 over SQL Server 7.0.It keeps generating a 'Current provider does not support the necessary interface for Index functionality...' error when I call the method. The recordset returns false for rsAdo.Supports(adIndex). Do I need to open the connection or recordset objects in a particular way to allow this method to work (adOpenDynamic etc) ??Any help appreciated... |
|
|
DMorley
Starting Member
2 Posts |
Posted - 2003-02-10 : 10:45:53
|
| Found out that SQL Server provider does not support the interface, no workaround.....will have to recode.... |
 |
|
|
|
|
|
ADO Index & Seek