Viewing 10 posts - 1 through 10 (of 10 total)
I did try changing the filename to 8.3 format, but no luck.
Also, the folder we have DBF files are set to 'Everyone' 'Full Control' for testing purpose.
I remember reading about...
June 9, 2021 at 3:33 pm
I have tried Access Database engine on Windows Server 2012, and gets similar error.
Cannot obtain the schema rowset "DBSCHEMA_COLUMNS" for OLE DB provider "Microsoft.ACE.OLEDB.16.0" for linked server "DBFServer16". The provider...
June 8, 2021 at 8:08 pm
Hi Brian,
Yes, I have tested by running SSMS as an administrator, but no luck.
I am just wondering is there any 64-bit OLDDB driver that can enable to open a DBF...
June 7, 2021 at 8:28 pm
Have tried all three queries and have returned error.
Most of the queries pointing to 'the object has no column'. Looks like the DBF structure is not being retrieved properly.
SELECT *...
June 4, 2021 at 7:08 pm
Good morning Brian,
In fact the issue we are having is with Windows Server 2019 and it's new Security features. I have a test environment with Windows Server 2019 / SQL...
June 4, 2021 at 12:39 pm
Hi,
Also, when I try 'SELECT TO' within Linked server, gets the following error.
TITLE: Microsoft.SqlServer.Smo
Enumerate columns failed for LinkedServer 'TESTACE'.
For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.100.46367.54+(SMO-master-A)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Enumerate+columns+LinkedServer&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or...
June 3, 2021 at 2:22 pm
HI,
I have tried both OPENQUERY and OPENROWSET to access DBF files, but both fails with following ERRORS..
SELECT FROM OPENROWSET ('MICROSOFT.ACE.OLEDB.12.0','dBase 5.0;HDR=NO;DATABASE=F:\TEMP', 'SELECT FROM TEST.DBF')
Msg 7357, Level 16, State 2, Line 53
Cannot process...
June 3, 2021 at 2:21 pm
I would like to use any other OLE DB 64 bit driver to create a Linked Server to open DBF files, so that there is no code change is required....
June 2, 2021 at 12:59 pm
With 'Advantage OLE DB', I did capture System Internals thru Process Monitor in both environments. In old environment, 'Operation' reports 'Create file', Read file' and ultimately a 'close file', where...
June 2, 2021 at 12:59 pm
Hi Brian, Thanks for your quick response.
As the latest version of 'Advantage OLE DB' driver does not work with Windows Server 2019, using that Driver is not an option any...
June 1, 2021 at 6:45 pm
Viewing 10 posts - 1 through 10 (of 10 total)