July 13, 2015 at 3:58 am
I'm running SQL Server 2008 (x64) version.
How can i create a linked server for Microsoft Visual Foxpro databases ?
I'm using Microsoft.ACE.OLEDB.12.0 driver.
I success create a linked server, and can browse all tables from linked server connections, but why when query data using
SELECT * FROM OPENQUERY(PIP_TEST,'select * from tbctrl')
it getting error message
Cannot process the object "select * from tbctrl". The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "pip_test" indicates that either the object has no columns or the current user does not have permissions on that object.
July 13, 2015 at 6:44 am
gentong.bocor (7/13/2015)
I'm running SQL Server 2008 (x64) version.How can i create a linked server for Microsoft Visual Foxpro databases ?
I'm using Microsoft.ACE.OLEDB.12.0 driver.
I success create a linked server, and can browse all tables from linked server connections, but why when query data using
SELECT * FROM OPENQUERY(PIP_TEST,'select * from tbctrl')
it getting error message
Cannot process the object "select * from tbctrl". The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "pip_test" indicates that either the object has no columns or the current user does not have permissions on that object.
You might be able to use the ODBC driver instead:
http://download.microsoft.com/download/vfoxodbcdriver/Install/6.1/W9XNT4/EN-US/VFPODBC.msi
Just be aware that some newer features of VFP, if used in the database, might result in this not working.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
July 13, 2015 at 8:05 am
ODBC Driver for visual foxpro does not support x64 version of windows.
I've tried it..
July 13, 2015 at 8:26 am
dont know if this will help, but have you seen this
http://saltydogllc.com/in-visual-foxpro-using-32-bit-odbc-drivers-on-a-64-bit-machine/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 13, 2015 at 9:58 am
J Livingston SQL (7/13/2015)
dont know if this will help, but have you seen thishttp://saltydogllc.com/in-visual-foxpro-using-32-bit-odbc-drivers-on-a-64-bit-machine/
That, and using ODBCAD32.exe to get to the 32-bit ODBC configuration.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
July 13, 2015 at 9:29 pm
creating system DSN using odbcad32 and making linked server on sql server 2008 (x64) getting error when saving the connections..
it seems, system DSN that i created didn't detected on sql server (x64).
so now i'm very frustated, how do i join vfp table with sql table..
July 14, 2015 at 8:59 am
gentong.bocor (7/13/2015)
creating system DSN using odbcad32 and making linked server on sql server 2008 (x64) getting error when saving the connections..it seems, system DSN that i created didn't detected on sql server (x64).
so now i'm very frustated, how do i join vfp table with sql table..
What error did you get, and exactly what was being done when it occurred? It's a tad difficult for us to solve a problem we can't see...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply