Re: UPDATE Problem with FoxPro Linked Server

From: James Thompson (jwegge_at_cox.net)
Date: 02/06/05 

Date: Sun, 06 Feb 2005 10:26:15 -0800

If I leave spaces/padding for the field I get the following error no
matter what I do:

Server: Msg 7399, Level 16, State 1, Line 3
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Visual FoxPro
Driver]SQL: Statement too long.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::SetData
returned 0x80004005: ].

SELECTs work fine with the spaces/padding. If I remove the padding for
UPDATE, no rows are found.

If I perform the same UPDATE query where there the field value equals
the length of the field, I have no problems with UPDATES.

Additionally, because the error above refers to a statement that is too
long, I have verified that the field is actually 10 characters and my
where value is 10 characters.

I guess that I am looking for something like Oracle's LPAD() or RPAD()
functions.

Thanks,

Jim

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • DTC Fehler
    ... The operation could not be performed because the OLE DB ... OLE DB error trace [OLE/DB Provider 'MSDASQL' ... Weiß jemand, wo der Fehler liegt, und wie ich den Fehler ...
    (microsoft.public.de.sqlserver)
  • Re: ISAM error when trying to create tablelink
    ... ODBC Provider (MSDASQL) ... "You are strongly encouraged to use one of the native OLE DB Providers ... instead of the Microsoft Open Database Connectivity Provider. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Bulk Copy / BCP problem....please advise
    ... OLE DB provider 'MSDASQL' reported an error. ... Driver] System resource exceeded.] ...
    (microsoft.public.sqlserver.programming)
  • Re: Antwort: Re: sql2005/management studio und verteilte transaktion
    ... fehlermeldung "The operation could not be performed because the OLE DB ... provider 'MSDASQL' was unable to begin a distributed transaction.". ...
    (microsoft.public.de.sqlserver)
  • Linked server to as400 - for the love of god please help.
    ... i'm trying to setup a linked server between SQL Server and an AS400/DB2/IBM ... OLE DB provider 'MSDASQL' reported an error. ... OLE DB error trace [OLE/DB Provider 'IBMDA400' IColumnsInfo::MapColumnIDs ...
    (microsoft.public.sqlserver.server)
Quantcast