ODBC passthrough string limit?

[abenitez77]

I having been using passthru queries with no issues. I am having with a passthru query. The string I am trying to pass is 3,064 in length. It is an insert that has about 150 fields. Is there a maximum length that a string odbc will take?

INSERT INTO Tab06 ( GroupID, AssignedAuditors, MoveToWS, Cltstyle, ItmDesc, PdQty, PdItmNetCst, Diff, Comments, InvNbr, InvDt, PoNbr, PoDt, RcvDt, Dateused, DateUsedDt, DlNbr, DlType, D_IND, TimesTurn, Pot
, PrevDed, Due, UnincludedPotential, OutBal, Include, IncludeAsSample, VndNbrAlt, DlVndNbrAlt, Vndname, CONSUMER_UNIT, Nsl_Code, DlAlwTyp, ListPrice, DlItmOIAlw, DlItmOIPct, DlItmNetCst, DlItmBBkAlw, NetNetCost, CreditAmt, CreditInvNbr
, RetroInvnbr, Source, PRO_ID, PPO_ID, DlOrdBegDtLP, DlOrdEndDtLP, DlOrdBegDtOI, DlOrdEndDtOI, DlOrdBegDtRE, DlOrdEndDtRE, PricingPointLP, PricingPointOI, PricingPointRE, WarehouseBuyinStart, WarehouseBuyinEnd, InvQty, RcvQty, InvItmNetCst, RcvItmNetCst, D_DAYS
, D_DAYSIND, Complex, MATCHLINK, STRNBR, TRADER_UNIT, RCVNBR, RCVLINENBR, INVLINENBR, EDI_IND, INVITMDISC, INVTOTDISC, INVVATTOT, INVCOMMENT, PRICEDTYPE, RCVREASON, RCVEXTCOST, RCVVATTOT, VND_STYLE, INVCSPCK, INVSZ
, RCVITMDISC, RCVTOTDISC, LOCTYPE, FORCE_IND, GRCVNBR, BUYER, DEBITNBR, DEBITDT, DEBITCOMMENT, DEBITLINENBR, DEBITVNDRCOST, DEBITCLIENTCOST, DEBITVNDRQTY, DEBITCLIENTQYT, DEBITEXTAMT, DEBITVATTOT, DEBITTYPE, DEBITREASON, DEBITPOSTDT, DebitReversal
, DBCRREVERSAL, BatchYear, BatchPeriod, WeekNbr, DebitNbr_Combined, DBGROUPNOTE_NO, DebitNotInAP, RollupNbr, FactBalancingDetailKey, AuditStatusCode, PreviousAuditStatusCode, IS_Complex, LastAuditor, LastAuditorDate, LastManager, LastManagerDate, LastUpdatedBy, LastUpdatedDate, CreatedDate, Tab05ID
, CutOffComments, PricingComments, Tab02ID, Tab03ID )
SELECT '110300013', 'abenit01', MoveToWS, Cltstyle, ItmDesc, PdQty, PdItmNetCst, Diff, Comments, InvNbr, InvDt, PoNbr, PoDt, RcvDt, Dateused, DateUsedDt, DlNbr, DlType, D_IND, TimesTurn, Pot
, PrevDed, Due, UnincludedPotential, OutBal, Include, IncludeAsSample, VndNbrAlt, DlVndNbrAlt, Vndname, CONSUMER_UNIT, Nsl_Code, DlAlwTyp, ListPrice, DlItmOIAlw, DlItmOIPct, DlItmNetCst, DlItmBBkAlw, NetNetCost, CreditAmt, CreditInvNbr
, RetroInvnbr, Source, PRO_ID, PPO_ID, DlOrdBegDtLP, DlOrdEndDtLP, DlOrdBegDtOI, DlOrdEndDtOI, DlOrdBegDtRE, DlOrdEndDtRE, PricingPointLP, PricingPointOI, PricingPointRE, WarehouseBuyinStart, WarehouseBuyinEnd, InvQty, RcvQty, InvItmNetCst, RcvItmNetCst, D_DAYS
, D_DAYSIND, Complex, MATCHLINK, STRNBR, TRADER_UNIT, RCVNBR, RCVLINENBR, INVLINENBR, EDI_IND, INVITMDISC, INVTOTDISC, INVVATTOT, INVCOMMENT, PRICEDTYPE, RCVREASON, RCVEXTCOST, RCVVATTOT, VND_STYLE, INVCSPCK, INVSZ
, RCVITMDISC, RCVTOTDISC, LOCTYPE, FORCE_IND, GRCVNBR, BUYER, DEBITNBR, DEBITDT, DEBITCOMMENT, DEBITLINENBR, DEBITVNDRCOST, DEBITCLIENTCOST, DEBITVNDRQTY, DEBITCLIENTQYT, DEBITEXTAMT, DEBITVATTOT, DEBITTYPE, DEBITREASON, DEBITPOSTDT, DebitReversal
, DBCRREVERSAL, BatchYear, BatchPeriod, WeekNbr, DebitNbr_Combined, DBGROUPNOTE_NO, DebitNotInAP, RollupNbr, FactBalancingDetailKey, AuditStatusCode, PreviousAuditStatusCode, IS_Complex, LastAuditor, LastAuditorDate, LastManager, LastManagerDate, LastUpdatedBy, LastUpdatedDate, CreatedDate, Tab05ID
, CutOffComments, PricingComments, Tab02ID, Tab03ID FROM SubQryTab05forAppend

 

[dhookom]

What is the issue or error message? Did you attempt to run this query in SQL Server Management Studio?

"SubQryTab05forAppend" seems like it might be an Access query. If so, this won't work since SQL Server doesn't know anything about your Access objects.

Duane
Hook'D on Access
MS Access MVP