What is the "Provider Name" for foxpro DB when using openrowset in SQL select ?
Posted on 2006-07-21
I'm now writing a two-way query between MS SQL server & foxpro DB.
On MS SQL server, I need to access both tables on SQL server as well as on foxpro DB using SQL select statement. From the SQL Server Books Online (search Transact-SQL Reference "OPENROWSET"), I can find my expected syntax. However, in the OPENROWSET command, the first parameter is "provider name" .... I'm now required to access DB in Visual Foxpro 6.0 DB, what is the "provider name" for this ? Please also, advise how can one search such name ? Thanks.
Can anyone help ?