Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can not update DBF file via SQL 2005 Express by OPENROW
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
01145510
Message ID:
01146943
Vues:
19
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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform