run time error 2147217900

S

sanjog

Joined
Apr 21, 2010
Messages
1
Reaction score
0
Hi,
Need your help, following is my vb code throws error message during execution "Run Time error 2147217900 Syntex Error "

SQL = "insert into BSR62005 (part_I, srno, Item_code, Acc_type, Jun, sep, dec, mar) values ("
SQL = SQL + " '" & TxtMFBankerCode & "', '" & txtSr & "',val('" & txtAcCode & "'), '" & TxtAcType & "', '" & TxtJunAmt & "','" & TxtSeptAmt & "', '" & TxtDecAmt & "', '" & TxtMarAmt & "')"
DbConn.Execute SQL

but same query works OK if executed directly in access database

we had checked the DBConn connection string also
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with INSERT query 1
run time error 2147217900 1
syntax error in INSERT INTO statement 3
Strange Error Message in A2K 2
Do you have an explanation for this? 1
Setting SQL for Pass through qry results in a 3075 error 4
Run-Time error '2342': 1
Run-time error: SQL Server does not exist or access denied 3

Top