using Access queries using ADOX

[Arvid Dellien]

Hello,
I have the following code in an asp 3.0 page:

Dim dbConn As adodb.Connection
Dim cat As ADOX.Catalog
Dim view As ADOX.view

Set dbConn = server.createobject("ADODB.connection")
dbConn.Open sConnstr

Set cat = server.createobject("ADOX.Catalog")
cat.ActiveConnection = dbConn

Set view = cat.views("GetWAVLCount")

Which works fine when run in an asp-page or on my development server.
However, when I put the code in a vb6 com-dll and deploy it on the
production server, the last line of code generates a typ mismatch
error (13). Does anyone have any idea why?

I can also run the code on the production server using asp instead of
putting it in a dll.

Thankful for any help,
Arvid Dellien

[Manohar Kamath [MVP]]

Looks like ADOX is not registered on the Production server, or there is a
mismatch between the versions you use for compiling the DLL and the one on
production server.

--
Manohar Kamath
Editor, .netBooks
[url]www.dotnetbooks.com[/url]


"Arvid Dellien" <arvidd@hotmail.com> wrote in message
news:2475bbfb.0308180105.386d58a6@posting.google.c om...

> Hello,
> I have the following code in an asp 3.0 page:
>
> Dim dbConn As adodb.Connection
> Dim cat As ADOX.Catalog
> Dim view As ADOX.view
>
> Set dbConn = server.createobject("ADODB.connection")
> dbConn.Open sConnstr
>
> Set cat = server.createobject("ADOX.Catalog")
> cat.ActiveConnection = dbConn
>
> Set view = cat.views("GetWAVLCount")
>
> Which works fine when run in an asp-page or on my development server.
> However, when I put the code in a vb6 com-dll and deploy it on the
> production server, the last line of code generates a typ mismatch
> error (13). Does anyone have any idea why?
>
> I can also run the code on the production server using asp instead of
> putting it in a dll.
>
> Thankful for any help,
> Arvid Dellien

[Arvid Dellien]

Im sure ADOX is registered on the production server. I registered the
same adox-version as I use on my development server on the production
server, and I can instantiate ADOX objects by using asp on it. But the
code still generates the same error when run in my dll. How do I
resolve mismatch between versions?


"Manohar Kamath [MVP]" <mkamath@TAKETHISOUTkamath.com> wrote in message news:<ecZMtaYZDHA.2024@TK2MSFTNGP12.phx.gbl>...

> Looks like ADOX is not registered on the Production server, or there is a
> mismatch between the versions you use for compiling the DLL and the one on
> production server.
>
> --
> Manohar Kamath
> Editor, .netBooks
> [url]www.dotnetbooks.com[/url]
>
>
> "Arvid Dellien" <arvidd@hotmail.com> wrote in message
> news:2475bbfb.0308180105.386d58a6@posting.google.c om...

> > Hello,
> > I have the following code in an asp 3.0 page:
> >
> > Dim dbConn As adodb.Connection
> > Dim cat As ADOX.Catalog
> > Dim view As ADOX.view
> >
> > Set dbConn = server.createobject("ADODB.connection")
> > dbConn.Open sConnstr
> >
> > Set cat = server.createobject("ADOX.Catalog")
> > cat.ActiveConnection = dbConn
> >
> > Set view = cat.views("GetWAVLCount")
> >
> > Which works fine when run in an asp-page or on my development server.
> > However, when I put the code in a vb6 com-dll and deploy it on the
> > production server, the last line of code generates a typ mismatch
> > error (13). Does anyone have any idea why?
> >
> > I can also run the code on the production server using asp instead of
> > putting it in a dll.
> >
> > Thankful for any help,
> > Arvid Dellien