I don't think that the current download/install of VFPODBC (VFPODBC.MSI) hasn't ever worked on Vista, and I notice it's still broke in RC2. Is VFPODBC going to be supported in Vista
We have a bunch of code that doesn't work under VFPOLEDB, but works just fine under VFPODBC so we can't just switch... plus it's a deployed application, so in order to change code we'd have to put a bunch of remote customers through an app upgrade.
When I say it still isn't working, I mean the install process is broke ( the VFPODBC.MSI that works with XP doesn't work on Vista )... so there's no way to reasonably instruct an end customer on how to download and install VFPODBC.
Yes, I believe you can manually move and register the DLL yourself...
The requirements are very simple so capabilities are not the issue, but rather things like stability, performance, ease of implementing for programmer, ease of installation, etc.
You probably won't get a lot of help for installing on an unreleased operating system, but I'm not surprised there are problems. Installing software is one of the things Vista tightens down considerably.
In the name of security, they're (rightly) making it difficult to actually use a computer. I fear they've gone too far, but it isn't released yet so who knows where it will land.
I ran into the same problem and figured out a workaround. I tried to install the current 6.0 version of the VFPODBC DLL, and the MSI package ran. However, when I checked the drivers in the ODBC in the Admin Tools, it was still at version 1.0
I then went into the command line, unregistered vfpodbc.dll from c:\windows\system32, and then copied the verision 6.0 vfpodbc.dll (from another machine) into the c:\windows\system32 directory and registered it with regsvr32.
Works fine, and give me a chance to relax. Our applications rely on the ODBC connection, and was starting to swet after not getting to work.
Just don't let any of your users run a 64-bit version of either WindowsXP or Vista. 32-bit ODBC and OLEDB drivers are not visible or usable by 64-bit applications.
ODBC Drivers are not Operating System specific, they are product specific. The last version of the VFP ODBC Driver was for Version 6.0 and you can get that from this location:
(look for the "Download VFPODBC.MSM" link). This will work with later versions of Visual FoxPro providing that the tables do not use features introduced AFTER Version 6.0 (e.g. Auto-incrementing Integers, VarChar fields etc).
The alternative is to use the VFP OLEDB Provider which is also downloadable - from here:
Visual FOXPRO ODBC Drivers for windows Vista
Jones1
Is there any reason to choose ODBC over OLEDB or vice versa App is in VB.Net and uses both MDB and DBF.
Corey Bornmann
AJB123
Nightman28
When I say it still isn't working, I mean the install process is broke ( the VFPODBC.MSI that works with XP doesn't work on Vista )... so there's no way to reasonably instruct an end customer on how to download and install VFPODBC.
Yes, I believe you can manually move and register the DLL yourself...
A911Pro
Dan,
Are you sure of this
64bits OS and/or Apps
imed-deborah
The requirements are very simple so capabilities are not the issue, but rather things like stability, performance, ease of implementing for programmer, ease of installation, etc.
NorthHaven
In the name of security, they're (rightly) making it difficult to actually use a computer. I fear they've gone too far, but it isn't released yet so who knows where it will land.
ZDB
I ran into the same problem and figured out a workaround. I tried to install the current 6.0 version of the VFPODBC DLL, and the MSI package ran. However, when I checked the drivers in the ODBC in the Admin Tools, it was still at version 1.0
I then went into the command line, unregistered vfpodbc.dll from c:\windows\system32, and then copied the verision 6.0 vfpodbc.dll (from another machine) into the c:\windows\system32 directory and registered it with regsvr32.
Works fine, and give me a chance to relax. Our applications rely on the ODBC connection, and was starting to swet after not getting to work.
Hope that helps
MD
Bob_Sullivan
MD
AK88
Jon Davis
Similar situation! But I couldn't unregister the DLL.
I deleted and re-copied the correct version in. ODBC System Administrator was correct the next time I started.
Thanks
Kerry.............
KeithGWilliams
Ariel Valentin
ODBC Drivers are not Operating System specific, they are product specific. The last version of the VFP ODBC Driver was for Version 6.0 and you can get that from this location:
http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx
(look for the "Download VFPODBC.MSM" link). This will work with later versions of Visual FoxPro providing that the tables do not use features introduced AFTER Version 6.0 (e.g. Auto-incrementing Integers, VarChar fields etc).
The alternative is to use the VFP OLEDB Provider which is also downloadable - from here:
http://www.microsoft.com/downloads/details.aspx FamilyId=E1A87D8F-2D58-491F-A0FA-95A3289C5FD4&displaylang=en
DOSST
We are in same situation...I'm trying to view inside VFPODBC.MSI with ORCA to learn how can i install it "manually" but is hard for me !
Can anyone help us