I have an Visual FoxPro application which uses flat tables.
I need to be able to query those tables using SQL Server 16 (64 bit).
I know VFP OLEDB Provider does not support 64bit.
It was suggested in another post that it may be possible to use Linked server on SQL 64bit to SQL 32bit and another linked server on SQL 32bit to the VFP flat tables.
I created the SQL 32bit linked server using VFPOLEDB.
I am receiving an error and not sure what I'm doing wrong.
"Cannot initialize the data source object of OLEDB provider VFPOLRDB...Returned message."Invalid Path or file name."" SQL error 7303.
I verified and there are no errors in the path. The linked server configured "Data Source: \\ServerName\ShareName\ApplicationFolder\TableFolder " All the free tables reside in the TableFolder.
Can I use a linked server using VFPOLEDB to connect to flat tables or does it need to be a VFP Database?
I should also clarify that I don't have SQL server experience and learning as I go on this setup.
Any help is greatly appreciated.
I need to be able to query those tables using SQL Server 16 (64 bit).
I know VFP OLEDB Provider does not support 64bit.
It was suggested in another post that it may be possible to use Linked server on SQL 64bit to SQL 32bit and another linked server on SQL 32bit to the VFP flat tables.
I created the SQL 32bit linked server using VFPOLEDB.
I am receiving an error and not sure what I'm doing wrong.
"Cannot initialize the data source object of OLEDB provider VFPOLRDB...Returned message."Invalid Path or file name."" SQL error 7303.
I verified and there are no errors in the path. The linked server configured "Data Source: \\ServerName\ShareName\ApplicationFolder\TableFolder " All the free tables reside in the TableFolder.
Can I use a linked server using VFPOLEDB to connect to flat tables or does it need to be a VFP Database?
I should also clarify that I don't have SQL server experience and learning as I go on this setup.
Any help is greatly appreciated.