Re: OpenSchema error

I think ekkehard spotted the problem I missed. try his solution.

Guy wrote:
Hi,
I've upgraded MDAC and Jet 4. It hasn't fixed the problem. I still
get the same error.

"Bob Barrows [MVP]" wrote:

Reinstall/upgrade MDAC 2.8

Reinstall/upgrade Jet 4.0

The installables can be found by searching microsoft.com.

Guy wrote:
Hi,

I'm trying to use the OpenSchema function using asp, vbscript, and
access 2000. Here is my code :


dim objConnection

Set objConnection = Server.CreateObject("ADODB.Connection")

dim rsGetProbs

objConnection.Open "data
source=C:\db.mdb;PROVIDER=Microsoft.Jet.OLEDB.4.0;"

Set rsGetProbs = objConnection.OpenSchema (adSchemaTables)



the last line gives me this error :
ADODB.Connection (0x800A0CB3)
Object or provider is not capable of performing requested operation.
/forum/EditTable.asp, line 48

I've tried a bunch of variations on the last line :
Set rsGetProbs =
objConnection.OpenSchema(adSchemaColumns,Array(Empty, Empty,
"User"))
Set rsGetProbs = objConnection.OpenSchema(adSchemaTables,
Array(Empty, Empty, Empty, "Table"))

These lines produce the same error. Can anyone tell me how to solve
this?

Thanks,
Guy

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so
I don't check it very often. If you must reply off-line, then remove
the "NO SPAM"

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: OpenSchema error
    ... Reinstall/upgrade MDAC 2.8 ... Set rsGetProbs = objConnection.OpenSchema(adSchemaColumns,Array(Empty, ... Empty, Empty, "Table")) ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: using ado drivers with 64 bits software
    ... knowledge there won't be any 64 bit driver for JET; ... the use of the MDB file format as the backend should only be ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: Which ADO provider to use to connect to MS Access DB under Vista x64 ?
    ... release one for Vista. ... Jet is not 64 bits compatible, thus a 64 bits application can't ... use Jet provider to connect to a MS Access database ... This email account is my spam trap so ...
    (microsoft.public.data.ado)
  • Re: Which ADO provider to use to connect to MS Access DB under Vista x64 ?
    ... Yes - although that WS2003 patch does provide some hope that they will release one for Vista. ... Jet is not 64 bits compatible, thus a 64 bits application can't ... use Jet provider to connect to a MS Access database ... This email account is my spam trap so ...
    (microsoft.public.data.ado)
  • Re: Insert with multiple subqueries - possible?
    ... In Jet, tere's no such thing as a fixed-length char datatype. ... Bob Barrows ... This email account is my spam trap so I ...
    (microsoft.public.sqlserver.programming)