Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OLEDB provider error - maximum length is 128

Status
Not open for further replies.
unseth

unseth

Programmer
Sep 10, 2000
31
US
I have an ole db provider that i call this way

select filename from mpaole...[this is my input]

however, if my input exceeds 128 characters, I'm given the error 103 that the maximum length is 128 characters.

I know this deal's with quotes, and setting QUOTED_IDENTIFIER OFF, however, there aren't any quotes to deal with so this solution doesn't work.

Anyone know what to do?
 
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
284
Andrzejek
Andrzejek
Virendra Yaduvanshi
  • Locked
  • Question
SSRS - Subscription page error
Replies
0
Views
107
Virendra Yaduvanshi
Virendra Yaduvanshi
grnzbra
  • Locked
  • Question
Is "IF EXISTS()..." better than "IF (SELECT COUNT...) > 0"
Replies
4
Views
1K
gmmastros
gmmastros
ahmedsa2018
  • Locked
  • Question
the goal mfrom asking question is t
Replies
0
Views
94
ahmedsa2018
ahmedsa2018
peac3
  • Locked
  • Question
Gaps and islands
Replies
8
Views
232
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top