May 28, 2008 at 11:07 am
Is there anyway that SQL server can link up to a DBF or a DBC and if so then how??
I have been trying using the string in below::
[oledb]
; Everything after this line is an OLE DB initstring
Provider=VFPOLEDB.1;Data Source=C:\Documents and Settings\jesraelo\My Documents\Visual FoxPro Projects\RESOURCE SCHEDULING.DBC;Mode=ReadWrite;Password="";Collating Sequence=MACHINE
The SQL server does not complain and creates the linked server, no problem. However, I get the error (cannot fetch a row from ole db provider "sql server" for linked server "(null)" (Microsoft SQL Server, Error: 7330) while attempting to view the views and the tables...
Any assistance will help tremendously.
thx
Cheers,
John Esraelo
May 28, 2008 at 9:46 pm
If DBF refers to foxpro, you may reference the link
http://www.connectionstrings.com/?carrier=dbffoxpro
But what is DBC?
May 30, 2008 at 12:07 pm
The vfp is visual foxpro and the dbc is database container or for lack of a better word a device for the old sql server programmers and admins.
I will take a look at the link you have provided me with.
thx
If DBF refers to foxpro, you may reference the link
http://www.connectionstrings.com/?carrier=dbffoxpro
But what is DBC?
Cheers,
John Esraelo
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply