Back to Blog
Download dbase iv 64 bit5/26/2023 ![]() SELECT * FROM OPENROWSET('.12.0',ĮXEC _MSset_oledb_prop N'.12.0', N'AllowInProcess', 0 ĮXEC _MSset_oledb_prop N'.12.0', N'DynamicParameters', 0 ![]() Sp_configure 'Ad Hoc Distributed Queries', 1ĮXEC _MSset_oledb_prop N'.12.0', N'AllowInProcess', 1 ĮXEC _MSset_oledb_prop N'.12.0', N'DynamicParameters', 1 To read data directly modify following sql statement with your data and execute it: You can read data directly without linked server, but i find this less elegant To create a Linked Server modify following sql statement with your data and execute it:ĮXEC _addlinkedserver = N'DBFServer', IV' It took me quite a while to find a solution that will enable me to read dbf files from 64 bit SQL server, so i decided to create this guide for all of you guys searching for an answer.ĭownload and install Access Database Engine 64 bit : Ĭreating Linked server for me is the most elegant solution
0 Comments
Read More
Leave a Reply. |