Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sam4
Starting Member
7 Posts |
 Posted - 2008-07-14 : 14:50:14
|
| I am trying to open a .dbf file using openrowset and I get this error msg:Cannot create an instance of OLE DB provider "VFPOLEDB" for linked server "(null)".Isn't it possible to open a table without creating a linked server? I would rather not do so unless I have to. I am running SQL server 2005. I installed the most recent release of vfpoledb.Here is my select:select * from openrowset('VFPOLEDB','C:\Program Files (x86)\Microsoft SQL Server\';'';'','Select * from zip') as x |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-14 : 22:53:00
|
| Did you try with linked server anyway? |
 |
|
|
sam4
Starting Member
7 Posts |
Posted - 2008-07-14 : 23:15:17
|
| No. VFPOLEDB does not appear on the provider list. Should it? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-14 : 23:21:49
|
| How can you make openrowset work if it's not in provider list? |
|
|
|
sam4
Starting Member
7 Posts |
Posted - 2008-07-15 : 11:45:36
|
| How do I add it to the list?? Note: Prior to writing my initial post I installed the Microsoft OLE DB Provider for Visual Foxpro 9.0. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-15 : 23:26:46
|
| If you can use it in openrowset, you can use it for linked server too. |
|
|
|
|
|
|
openrowset error