Hi smantha11, Currently Microsoft does not have any 64 bit ODBC drivers available for the Office products. However, as long as the application that you want to connect to is 32 bit, you can use the 32 bit ODBC drivers to create the DSN. To get to the 32 bit ODBC drivers, the 32 bit Data Source administrator must be used. The 32 bit Data Source administrator must be launched directly if you are using a 64 bit OS. The file should be located at the following path: c: windows sysWOW64 odbcad32.exe Hope this helps! You can download the drivers here: This file will add Access to the list of file types in the ODBC administrator.

Not sure if its 32 or 64 bit. But it worked on a machine running 64bit Win 7 Hope this helps, Scott P.S. Please post a response to let us know whether our answer helped or not. Microsoft Access MVP 2009 Author: Microsoft Office Access 2007 VBA Technical Editor for: Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports and Queries Hope this helps, Scott Blog: Microsoft Access MVP since 2007. Srw2024 downloading code using xmodem hyperterminal.

You are using 64-bit SQL Server which is looking to the 64-bit ODBC sources when the drivers are 32-bit. There is a workaround for FoxPro (also DBF) that should work for dBASE as well: Open a new SqlDataSource in Visual Studio using the.NET Framework Provider for OLE DB then MS OLE DB Provider for VFP. The connection string should look like this (or with UNC) Provider=VFPOLEDB.1;Data Source=h: Programs Data;Persist Security Info=True;User ID=Your_user;Password=your_password The config wizard includes a part to test your SQL. You can use this run ad hoc SQL.

I enjoy building up new teams, efficient and effective organisations and working in projects connecting different cultures, countries, functions, units and processes. Oliver kasper softbox. Being a resourceful HR leader with international working experience in business transformation, towards new HR service delivery models including outsourcing.

Apr 12, 2018 - This is done by using the OpenQuery or OpenRowset Transact-SQL functions. Because SQL Server is multi-threaded, the VFP ODBC Driver may cause problems under some circumstances. 'Driver=Microsoft Visual FoxPro Driver. You will need to make a DSN and point it to the Testdata database.