How can I determine the ole driver version?

[cj2]

I'm trying to access VFP 8 tables from VB 2008. How can I determine the
version of the VFP OLEDB driver on my PC? What is the latest version?

[Michel Posseth [MCP]]

Re: How can I determine the ole driver version?

Hello CJ2

It looks like there is only one version of vfpoledb.dll

http://support.microsoft.com/dllhelp/default.aspx?l=55&fid=20251

you can download it here

http://www.microsoft.com/DownLoads/details.aspx?familyid=E1A87D8F-2D58-491F-A0FA-95A3289C5FD4&displaylang=en

hth

Michel Posseth [MCP]

http://www.vbdotnetcoder.com

"cj2" <cj2@nospam.nos pamschreef in bericht
news:ORDywWWLJH A.2760@TK2MSFTN GP06.phx.gbl...

I'm trying to access VFP 8 tables from VB 2008. How can I determine the
version of the VFP OLEDB driver on my PC? What is the latest version?

[cj2]

Re: How can I determine the ole driver version?

If there is only one I guess I have it cause I have one. I was telling
someone the other day that my testing reveiled odbc was much faster than
oledb and they said they thought the opposite was true and asked if I
was using the latest version of oledb. I didn't know. I know with odbc
I can go into the odbc manager and see what drivers I have and what
version they are but I don't know how to look at oledb drivers to see
what is installed.


Michel Posseth [MCP] wrote:

Hello CJ2
>
It looks like there is only one version of vfpoledb.dll
>

http://support.microsoft.com/dllhelp/default.aspx?l=55&fid=20251

>
you can download it here
>

http://www.microsoft.com/DownLoads/details.aspx?familyid=E1A87D8F-2D58-491F-A0FA-95A3289C5FD4&displaylang=en

>
>
hth
>
Michel Posseth [MCP]

http://www.vbdotnetcoder.com

>
>
>
"cj2" <cj2@nospam.nos pamschreef in bericht
news:ORDywWWLJH A.2760@TK2MSFTN GP06.phx.gbl...

>I'm trying to access VFP 8 tables from VB 2008. How can I determine the
>version of the VFP OLEDB driver on my PC? What is the latest version?

>
>

[Dan Freeman]

Re: How can I determine the ole driver version?

Michael is wrong. There has been a separate OLEDB driver for every version
of Foxpro (and service pack) since VFP7. His own references prove this: one
page talks about the VFP8 driver and the other talks about the VFP9 driver.

Interactively, right click on vfpoledb.dll and choose Properties. In a
program, ask it its Version().

Dan

cj2 wrote:

If there is only one I guess I have it cause I have one. I was
telling someone the other day that my testing reveiled odbc was much
faster than oledb and they said they thought the opposite was true
and asked if I was using the latest version of oledb. I didn't know.
I know with odbc I can go into the odbc manager and see what drivers
I have and what version they are but I don't know how to look at
oledb drivers to see what is installed.
>
>
Michel Posseth [MCP] wrote:

>Hello CJ2
>>
>It looks like there is only one version of vfpoledb.dll
>>
>http://support.microsoft.com/dllhelp...l=55&fid=20251
>>
> you can download it here
>>
>http://www.microsoft.com/DownLoads/d...displaylang=en
>>
>>
>hth
>>
>Michel Posseth [MCP]
>http://www.vbdotnetcoder.com
>>
>>
>>
>"cj2" <cj2@nospam.nos pamschreef in bericht
>news:ORDywWWLJ HA.2760@TK2MSFT NGP06.phx.gbl.. .

>>I'm trying to access VFP 8 tables from VB 2008. How can I
>>determine the version of the VFP OLEDB driver on my PC? What is
>>the latest version?

[Michel Posseth [MCP]]

Re: How can I determine the ole driver version?

Michael is wrong


huh ??? :-(

In that case the dll help database of Microsoft is wrong see first link

According to this database there only exists one vfpoledb.dll the VFP9
driver package could just as easily contain the
same vfpoledb.dll however just to be sure i downloaded and installed the
package in the second link i provided and indeed this version is 9.0.0.5815
so the dll help database is not so much of an help these days .

to see wich version you have

C:\Program Files\Common Files\System\Ol e DB

right click the "vfpoledb.d ll" tab version


HTH


Michel







"Dan Freeman" <spam@microsoft .comschreef in bericht
news:OfZwdJhLJH A.5060@TK2MSFTN GP02.phx.gbl...

Michael is wrong. There has been a separate OLEDB driver for every version
of Foxpro (and service pack) since VFP7. His own references prove this:
one page talks about the VFP8 driver and the other talks about the VFP9
driver.
>
Interactively, right click on vfpoledb.dll and choose Properties. In a
program, ask it its Version().
>
Dan
>
cj2 wrote:

>If there is only one I guess I have it cause I have one. I was
>telling someone the other day that my testing reveiled odbc was much
>faster than oledb and they said they thought the opposite was true
>and asked if I was using the latest version of oledb. I didn't know.
>I know with odbc I can go into the odbc manager and see what drivers
>I have and what version they are but I don't know how to look at
>oledb drivers to see what is installed.
>>
>>
>Michel Posseth [MCP] wrote:

>>Hello CJ2
>>>
>>It looks like there is only one version of vfpoledb.dll
>>>
>>http://support.microsoft.com/dllhelp...l=55&fid=20251
>>>
>> you can download it here
>>>
>>http://www.microsoft.com/DownLoads/d...displaylang=en
>>>
>>>
>>hth
>>>
>>Michel Posseth [MCP]
>>http://www.vbdotnetcoder.com
>>>
>>>
>>>
>>"cj2" <cj2@nospam.nos pamschreef in bericht
>>news:ORDywWWL JHA.2760@TK2MSF TNGP06.phx.gbl. ..
>>>I'm trying to access VFP 8 tables from VB 2008. How can I
>>>determine the version of the VFP OLEDB driver on my PC? What is
>>>the latest version?

>
>

[mark.tunnard.jackson@googlemail.com]

Re: How can I determine the ole driver version?

I've been burned by that DLL help database recently. It was a great
resource once, but Microsoft don't seem to be keeping it up to date
any more. I wish they would.

What tripped me up was it says there's no version of scrrun.dll after
version 5.6, but there's a version 5.7 available for download on the
Microsoft website.

[Dan Freeman]

Re: How can I determine the ole driver version?

The DLL hell database was out of date the day after it was made public.
<shrug>

Dan

mark.tunnard.ja ckson@googlemai l.com wrote:

I've been burned by that DLL help database recently. It was a great
resource once, but Microsoft don't seem to be keeping it up to date
any more. I wish they would.
>
What tripped me up was it says there's no version of scrrun.dll after
version 5.6, but there's a version 5.7 available for download on the
Microsoft website.

[mark.tunnard.jackson@googlemail.com]

Re: How can I determine the ole driver version?

On 14 Oct, 18:01, "Dan Freeman" <s...@microsoft .comwrote:

The DLL hell database was out of date the day after it was made public.
<shrug>

OK, you could expect it to be a little out of date, but for example
the entry Michael's referred to hasn't been updated since *2005*. I
vote Microsoft should take it off their website if it's going to be
that out of date.