Determining Jet Version?

Hi,

I am currently developing an ASP application that will be installed on
multiple servers by a variety of different users.

This application requires that JET 4.0 be installed on the server.

I have written a script that checks various other configuration
settings (parent paths, buffering, etc...) to be certain they are
compatible with my application.

Is there a way through an ASP script to detect the version of the JET
Database Engine that is installed?

Thanks.

Mike Biang
Cramer IT Consulting

Re: Determining Jet Version?

You could check the version of ODBCJT32.DLL.

Or you could use on error resume next, and try to create a Jet.4.0
connection, then fall back to a Jet.3.5.

Or you could just include the latest jet drivers with your code, and install
them (re-installing shouldn't hurt anything, but I'll leave it up to you to
test that).
http://www.aspfaq.com/2342

--
http://www.aspfaq.com/
(Reverse address to reply.)




"Mike Biang" wrote in message
news:4c93bd86.0411301258.4119d8a0@posting.google.com...
> Hi,
>
> I am currently developing an ASP application that will be installed on
> multiple servers by a variety of different users.
>
> This application requires that JET 4.0 be installed on the server.
>
> I have written a script that checks various other configuration
> settings (parent paths, buffering, etc...) to be certain they are
> compatible with my application.
>
> Is there a way through an ASP script to detect the version of the JET
> Database Engine that is installed?
>
> Thanks.
>
> Mike Biang
> Cramer IT Consulting