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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL string works in access but not from VB.Net code

Status
Not open for further replies.
qwert231

qwert231

Programmer
Joined
Sep 4, 2001
Messages
756
Location
US
My page is in VB.Net, and tries to do an OleDB.ExecuteNonQuery on this string:
INSERT INTO tblGCardDetails (OrderID, Image) VALUES(5924045, '0007')

I get an System.Data.OleDb.OleDbException: Syntax error in my code.
The same string works when dropped into an Access query. What could I be missing?
 
Sort by date Sort by votes
what type is OrderID and Image?
 
Upvote 0 Downvote
Sorry, thanks, I got it. Needed brackets around Image and Size (field names).
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

chikwendu
  • Locked
  • Question Question
Mouse jumps to DropDownList when clicking a button
Replies
0
Views
377
chikwendu
chikwendu
AhmedAzizBarbary
  • Locked
  • Question Question
How to pass list of checkboxes not checked on page model razor page?
Replies
0
Views
1K
AhmedAzizBarbary
AhmedAzizBarbary
Makumbi256
  • Locked
  • Question Question
how can i convert this code to cshap
Replies
1
Views
1K
xwb
xwb
G12Consult
  • Locked
  • Question Question
Javascript from Content Pages
Replies
0
Views
986
G12Consult
G12Consult
G12Consult
  • Locked
  • Question Question
Retrieve data from JSON
Replies
1
Views
1K
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top