psyche6
asked on
ODBC drivers for Windows 2003 x64 server
We do have currently SQL server 7.0 running on Windows NT 4.0 OS.
Upgrading to SQL server 2005 x64 running on Windows 2003 Server x64.
Currently we use Linked servers on the SQL server 7.0 to get data from Visual FoxPro tables.
I'm trying to add a DSN connection from the new Windows 2003 x64 Server to the VFP tables using ODBC and I cannot see any driver other than SQL server within the ODBC Data Source Administrator. I cannot find any doc as to how to add those drivers (VFP drivers etc...) to the new Windows 2003 x64 server. Any help would be appreciated.
Upgrading to SQL server 2005 x64 running on Windows 2003 Server x64.
Currently we use Linked servers on the SQL server 7.0 to get data from Visual FoxPro tables.
I'm trying to add a DSN connection from the new Windows 2003 x64 Server to the VFP tables using ODBC and I cannot see any driver other than SQL server within the ODBC Data Source Administrator. I cannot find any doc as to how to add those drivers (VFP drivers etc...) to the new Windows 2003 x64 server. Any help would be appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the quick response and help.
Plan change and we'll re-install 32 bit OS and SQL server.
Plan change and we'll re-install 32 bit OS and SQL server.
<32-bit apps are running on 64-bit
try
http://groups.google.com/group/microsoft.public.fox.vfp.dbc/browse_thread/thread/e0fc27f669d30abc/b79d190f3e7e9088?lnk=st&q=odbc+driver+64+bit+%22Visual+FoxPro%22&rnum=1&hl=en#b79d190f3e7e9088
In 64-bit Windows, you cannot access
the 32-bit VFP ODBC driver or the VFO OLEDB Provider for a 64-bit
application. However, you can compile a VS 2005 application as a 32-bit
app and then access either the VFP ODBC drier of the VFPOLE DB Provider.
We recommend you use the provider because it is thread safe.
I hope this helps.
This posting is provided "AS IS" with no warranties, and confers no rights.
Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell
*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/
*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=5478...
69-4500-8bf2-3f06689f4ab3&
Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003
try
http://groups.google.com/group/microsoft.public.fox.vfp.dbc/browse_thread/thread/e0fc27f669d30abc/b79d190f3e7e9088?lnk=st&q=odbc+driver+64+bit+%22Visual+FoxPro%22&rnum=1&hl=en#b79d190f3e7e9088
In 64-bit Windows, you cannot access
the 32-bit VFP ODBC driver or the VFO OLEDB Provider for a 64-bit
application. However, you can compile a VS 2005 application as a 32-bit
app and then access either the VFP ODBC drier of the VFPOLE DB Provider.
We recommend you use the provider because it is thread safe.
I hope this helps.
This posting is provided "AS IS" with no warranties, and confers no rights.
Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell
*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/
*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=5478...
69-4500-8bf2-3f06689f4ab3&
Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003
//there is hope
one more:
<Visual FoxPro will remain stand-alone Win32 based, and will run on 64-bit Windows in 32-bit compatibility mode>
http://msdn.microsoft.com/vfoxpro/roadmap/
one more:
<Visual FoxPro will remain stand-alone Win32 based, and will run on 64-bit Windows in 32-bit compatibility mode>
http://msdn.microsoft.com/vfoxpro/roadmap/
No, the Visual FoxPro OLE DB Provider is a 32-bit provider. It cannot be
seen or used by the 64-bit system or programs compiled as 64-bit
application.
Visual Studio 2005 allows you to compile an application as either 64-bit or
32-bit. You need to compile the application in 32-bit for the VFP Provider
to work.
As of now, there are no plans to make a 64-bit VFP OLE DB Provider.
I hope this helps.
This posting is provided "AS IS" with no warranties, and confers no rights.
Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell