Very Computer

by **Marc Bumgarne** » Thu, 30 Mar 2000 04:00:00

I'm using the ADO Ext. 2.1 object to determine if a query exists in a Jet DB
using the Microsoft.Jet.OLEDB.4.0 provider from VB6.0. I am also using ths
application to create and delete views in SQL Server 7.0 but when I try to
use the code that works in Jet I get the error "The Operation requested by
the application is not supported by the provider". Is this a know limitation
for the "sqloledb" provider. Is there a work around or a better way to this.

Sample Code:

Dim cat As New ADOX.Catalog

Set cat.ActiveConnection = cnn

ViewCnt = cat.Views.Count - 1

For i = 0 To ViewCnt
Set objView = cat.Views.Item(i)
If objView.Name = SelectedSiteID & "M" Then
cat.Views.Delete objView.Name
Exit For
End If
Next

Thanks,

by **Torsten Rendelman** » Fri, 31 Mar 2000 04:00:00

Have a look at adoxreadme.txt within the folder that contains msadox.dll.
--
Regards,

Torsten Rendelmann
PROCOS AG; FL-9490 Vaduz

http://www.procos.com

Quote:> I'm using the ADO Ext. 2.1 object to determine if a query exists in a Jet
DB
> using the Microsoft.Jet.OLEDB.4.0 provider from VB6.0. I am also using ths
> application to create and delete views in SQL Server 7.0 but when I try to
> use the code that works in Jet I get the error "The Operation requested by
> the application is not supported by the provider". Is this a know
limitation
> for the "sqloledb" provider. Is there a work around or a better way to
this.

> Sample Code:

> Dim cat As New ADOX.Catalog

> Set cat.ActiveConnection = cnn

> ViewCnt = cat.Views.Count - 1

> For i = 0 To ViewCnt
> Set objView = cat.Views.Item(i)
> If objView.Name = SelectedSiteID & "M" Then
> cat.Views.Delete objView.Name
> Exit For
> End If
> Next

> Thanks,

by **Andrew Grillag** » Fri, 31 Mar 2000 04:00:00

It does seem that this is not supported. I suggest looking at the SQLDMO
object library for managing SQL Server objects.

--
Andrew Grillage
http://vbdata.iwarp.com

Quote:> I'm using the ADO Ext. 2.1 object to determine if a query exists in a Jet
DB
> using the Microsoft.Jet.OLEDB.4.0 provider from VB6.0. I am also using ths
> application to create and delete views in SQL Server 7.0 but when I try to
> use the code that works in Jet I get the error "The Operation requested by
> the application is not supported by the provider". Is this a know
limitation
> for the "sqloledb" provider. Is there a work around or a better way to
this.

> Sample Code:

> Dim cat As New ADOX.Catalog

> Set cat.ActiveConnection = cnn

> ViewCnt = cat.Views.Count - 1

> For i = 0 To ViewCnt
> Set objView = cat.Views.Item(i)
> If objView.Name = SelectedSiteID & "M" Then
> cat.Views.Delete objView.Name
> Exit For
> End If
> Next

> Thanks,

by **mary chipma** » Fri, 31 Mar 2000 04:00:00

why do you need to create and delete views in sql server? what are you
trying to do? perhaps there's a better way to skin that cat.

On Wed, 29 Mar 2000 23:53:57 GMT, "Marc Bumgarner"

>I'm using the ADO Ext. 2.1 object to determine if a query exists in a Jet DB
>using the Microsoft.Jet.OLEDB.4.0 provider from VB6.0. I am also using ths
>application to create and delete views in SQL Server 7.0 but when I try to
>use the code that works in Jet I get the error "The Operation requested by
>the application is not supported by the provider". Is this a know limitation
>for the "sqloledb" provider. Is there a work around or a better way to this.

>Sample Code:

>Dim cat As New ADOX.Catalog

>Set cat.ActiveConnection = cnn

> ViewCnt = cat.Views.Count - 1

> For i = 0 To ViewCnt
> Set objView = cat.Views.Item(i)
> If objView.Name = SelectedSiteID & "M" Then
> cat.Views.Delete objView.Name
> Exit For
> End If
> Next

>Thanks,

Very Computer

ADOx Catalog Question

ADOx Catalog Question

ADOx Catalog Question

ADOx Catalog Question

ADOx Catalog Question