January 4, 2012 at 4:26 am
Hello!
I have a SQL Server 2008 R2 64 bit, and I created a Linked Server. Name LS_DBF of Linked Server and I use OLE DB provider "Microsoft.ACE.OLEDB.12.0".
I using this commad: SELECT fileds FROM LS_DBF...dbf_database
If the name of dbf file not longer then 8 character the select is successfully, else I receive this error message:
OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "ls_DBF" returned message "The Microsoft Access database engine could not find the object 'MB1928_201111_1'. Make sure the object exists and that you spell its name and the path name correctly. If 'MB1928_201111_1' is not a local object, check your network connection or contact the server administrator.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_COLUMNS" for OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "ls_DBF". The provider supports the interface, but returns a failure code when it is used.
What is the problem?
January 6, 2012 at 2:52 am
Hi
Are you sure this is the exact command you use :
SELECT fileds FROM LS_DBF...dbf_database
?
I don't see anything about 'MB1928_201111_1' which is in the error message.
January 6, 2012 at 3:06 am
Thanks your replay!
I sloved this problem. I rename the name of dbf file 'MBTMP' with xp_cmdshell and I run this command:
SELECT * FROM LS_DBF...MBTMP. This query always successfull. Than I rename the name of dbf file to the original name.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply