Solve : How to open dbf file ??

1.	Solve : How to open dbf file ??
Answer» I am trying to load DBF files into SQL server within CLR (actually if just running the select statement outside, say within the SQLQuery window, i got the same result), but with the following ERROR: Msg 7314, Level 16, State 1, Line 1 The OLE DB provider "VFPOLEDB" for linked server "MYDBF" does not contain the table "T8866064". The table either does not exist or the current user does not have permissions on that table. I created the linked server in this way EXEC sp_addlinkedserver @server = 'MYDBF', @provider = 'VFPOLEDB', @srvproduct = 'My Data', @datasrc = 'c:\data' i did not create the login since my SQL instance is running under a superaccount with all privilege. What frustrates me is that i can read most of the dbf files, but just a few of them is not readable. Can anyone give me some hints on it? by the way, i am using vfp9.0 thanksThe message of Quote The table either does not exist or the current user does not have permissions on that table. States that either its permissions related or the table doesnt exist that the data is to be passed to. I'd look to see if the table exists first. A tool like SQLyog Community Edition is EASIEST to look at the database. If the table exists at the database that is the target, then I'd look into privileges, either creating an account or using the superaccount and specifying in the instruction the username and password to authenticate with.A linked server is basically just a pointer that lets the code within your database INTERACT with external data sources as if they were also within your database/instance. There are some examples here for creating linked servers to DBF Viewer Tool: http://www.dbf.viewertool.com/ So for example if you had a linked server to a FoxPro database CALLED MyFoxProDB you could run a query within SQL Server like this: UPDATE t SET t.foo = x.bar FROM dbo.LocalTable AS t INNER JOIN MyFoxProDB...TableName AS x ON t.key = x.key; You could also consider using OPENROWSET as described in this question: http://www.filerepairforum.com/forum/databases/databases-aa/dbase-iv-clipper-foxpro/964-how-to-restore-a-corrupted-file You can safely ignore the software linked in the above post.

Answer»

I am trying to load DBF files into SQL server within CLR (actually if just running the select statement outside, say within the SQLQuery window, i got the same result), but with the following ERROR:

Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "VFPOLEDB" for linked server "MYDBF" does not contain the table "T8866064". The table either does not exist or the current user does not have permissions on that table.

I created the linked server in this way

EXEC sp_addlinkedserver
@server = 'MYDBF',
@provider = 'VFPOLEDB',
@srvproduct = 'My Data',
@datasrc = 'c:\data'

i did not create the login since my SQL instance is running under a superaccount with all privilege.

What frustrates me is that i can read most of the dbf files, but just a few of them is not readable.

Can anyone give me some hints on it?

by the way, i am using vfp9.0

thanksThe message of

Quote

The table either does not exist or the current user does not have permissions on that table.

States that either its permissions related or the table doesnt exist that the data is to be passed to. I'd look to see if the table exists first. A tool like SQLyog Community Edition is EASIEST to look at the database. If the table exists at the database that is the target, then I'd look into privileges, either creating an account or using the superaccount and specifying in the instruction the username and password to authenticate with.A linked server is basically just a pointer that lets the code within your database INTERACT with external data sources as if they were also within your database/instance. There are some examples here for creating linked servers to DBF Viewer Tool:
http://www.dbf.viewertool.com/
So for example if you had a linked server to a FoxPro database CALLED MyFoxProDB you could run a query within SQL Server like this:
UPDATE t
SET t.foo = x.bar
FROM dbo.LocalTable AS t
INNER JOIN MyFoxProDB...TableName AS x
ON t.key = x.key;
You could also consider using OPENROWSET as described in this question:
http://www.filerepairforum.com/forum/databases/databases-aa/dbase-iv-clipper-foxpro/964-how-to-restore-a-corrupted-file
You can safely ignore the software linked in the above post.

Solve : How to open dbf file ??

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment