stevesaved
Programmer
Greetings,
Does anyone know what this means and how to deal with it?
I get the error when trying to write to a dBASE file using the OPENDATASOURCE command. This used to work and I haven't changed anything! See below for query.
Thanks for any help.
Here's the error ...
Server: Msg 7331, Level 16, State 2, Procedure spExpChai, Line 28
Rows from OLE DB provider 'Microsoft.Jet.OLEDB.4.0' cannot be released.
[OLE/DB provider returned message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.]
Here's the query ...
INSERT INTO OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source="C:\HICAD\S0S\TMP";Extended Properties=DBASE IV')...[chai]
( ARTIKEL_NR, ARTKETT, ARTTEXT, X_MASS, Y_MASS, Z_MASS, INFO, MKEY, SERIE, SE_CAD )
SELECT NewArticleCode.strNewArticleCode,
NewArticleCode.strNewArticleCode,
NewArticleCode.strArtText,
ATAB.X_MASS,
ATAB.Y_MASS,
ATAB.Z_MASS,
ATAB.INFO,
ATAB.MKEY,
ATAB.SERIE,
ATAB.SERIE
FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source="C:\HICAD\S0S\TMP";Extended Properties=DBASE IV')...[atab]
AS ATAB
INNER JOIN HMUKSQL.PDMTest.dbo.NewArticleCode AS NewArticleCode
ON (NewArticleCode.strNewArticleCode = ATAB.ARTIKEL_NR)
Does anyone know what this means and how to deal with it?
I get the error when trying to write to a dBASE file using the OPENDATASOURCE command. This used to work and I haven't changed anything! See below for query.
Thanks for any help.
Here's the error ...
Server: Msg 7331, Level 16, State 2, Procedure spExpChai, Line 28
Rows from OLE DB provider 'Microsoft.Jet.OLEDB.4.0' cannot be released.
[OLE/DB provider returned message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.]
Here's the query ...
INSERT INTO OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source="C:\HICAD\S0S\TMP";Extended Properties=DBASE IV')...[chai]
( ARTIKEL_NR, ARTKETT, ARTTEXT, X_MASS, Y_MASS, Z_MASS, INFO, MKEY, SERIE, SE_CAD )
SELECT NewArticleCode.strNewArticleCode,
NewArticleCode.strNewArticleCode,
NewArticleCode.strArtText,
ATAB.X_MASS,
ATAB.Y_MASS,
ATAB.Z_MASS,
ATAB.INFO,
ATAB.MKEY,
ATAB.SERIE,
ATAB.SERIE
FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source="C:\HICAD\S0S\TMP";Extended Properties=DBASE IV')...[atab]
AS ATAB
INNER JOIN HMUKSQL.PDMTest.dbo.NewArticleCode AS NewArticleCode
ON (NewArticleCode.strNewArticleCode = ATAB.ARTIKEL_NR)