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 |
|
dhooger
Starting Member
2 Posts |
 Posted - 2005-12-23 : 14:03:17
|
| Using the command: sp_addlinkedserver 'AZ', '', 'VFPOLEDB', 'c:\trackercommon\data\comp01\company.dbc'I can make a linked server that works in SQL 2000 but not in 2005.I have used VFP OLE DB 9.0 from MS and no luck. I see some issue about memory leakage on MS's site but I can't even get the linked server to recognize the VFP database.Openqueries fail, etc.Thoughts? |
|
|
dhooger
Starting Member
2 Posts |
Posted - 2006-01-10 : 11:48:37
|
| Think I'm closer. Turns out that MDAC has not recognized VFPOLEDB despite having downloading and installed it on Windows Server 2003. I have now tried regsvr32 and it says it's registered but still not listed in MDAC (used the component checker). Thoughts? |
 |
|
|
|
|
|
foxpro linked server not working sql server 2005