Please ask any question if my English was not clear at some point. I am new to this forum and I would highly appreciate any help on this topic. 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 įROM OPENROWSET('.12.0','dBASE IV Database=D:\','SELECT * FROM x09150614.dbf')Ĭannot create an instance of OLE DB provider ".12.0" for linked server "(null)". I tried this: sp_configure 'show advanced options', 1 I need this process to be automatic, so I guess I need to use OPENROWSET with this provider. When I import the table using the wizard and the .12.0 provider, all values are imported correctly and there is no problem whatsoever. I tried casting to DECIMAL(11,3) but it didn't work for me. Windows 2008 + DNS servers Thread starter Silence Start date S. The value that cannot be retrieved is a big real number: 73798812.010. The provider cannot determine the value for this column. The code that has worked better for me so far is: select DCOMįrom openrowset('VFPOLEDB','D:\x09150614.DBF' '' '','SELECT * FROM x09150614')īut when I want to select another column: select vfobserdolĬannot get the current row value of column ".vfobserdol" from OLE DB provider "VFPOLEDB" for linked server "(null)".
However when i go in to Create a new System or User Odbc connection the VFP drivers are not listed and so i can't create a connection.
#Vfpodbc windows server 2008 install#
It appears to install correctly get no errors. I have done a lot of research and I have tried many suggestions but none of them have worked completely. I am trying to install the VFPODBC.MSI setup file on a windows 7 32 bit workstation. Cannot initialize the data source object of OLE DB provider VFPOLEDB for linked server XXX. DBF file that I want to import into a SQL Server table. I have a windows 2008 with SQL Server 2008 R2 VM on Azure. I am using 32-bit SQL Server 2008 and FoxPro OLE DB driver is 32-bit.
0 kommentar(er)
