Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can not update DBF file via SQL 2005 Express by OPENROW
Message
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01145510
Message ID:
01146943
Views:
18
I didn't get any errors running following code in SQL Server 2005 Developer edition.
UPDATE openrowset('MSDASQL',
		'Driver=Microsoft Visual FoxPro Driver;
		SourceDB=C:\PROGRAM FILES\MICROSOFT VISUAL FOXPRO 9\SAMPLES\Data;
		SourceType=DBF',
		'select * from customer where cust_id = "CACTU"')
set region = 'WA'
Do you have SP1 installed?
SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
<snip>
>
>And then update the table some record.
>
>Update openrowset('MSDASQL',
>'DSN=Visual FoxPro Tables;
>SourceDB=c:\VFP98\data;
>SourceType=DBF',
>'select * from customer where customerid = "CACTU"')
>set region = 'WA'
>
>This command can be run from within SQL server 2000.
>
>When I use this command with in SQL Server 2005 Expres ,
>I can retrive the data but I can't update the data into the table via OPENROWSET. It's show error message :
>
>Msg 7399, Level 16, State 1, Line 1
>The OLE DB provider "MSDASQL" for linked server "(null)" reported an error. The provider did not give any information about the error.
>Msg 7343, Level 16, State 4, Line 1
>The OLE DB provider "MSDASQL" for linked server "(null)" could not UPDATE table "[MSDASQL]". Unknown provider error.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform