Code Newbie
News     Forums     Search     Members     Sign Up    

My Code Newbie
Username

Password

Articles/Snippets
ASP Classic
ASP.NET
C
C#
C++
HTML / CSS
Java
Javascript
Linux / BSD
Perl
PHP
Python
Ruby
SQL
VB 6
VB.NET

C.N. Friends
  Planet Rome

Link to Us!
Code Newbie
  Code Newbie
    forums
Old 11-10-2004, 10:09 PM   #1 (permalink)
Newbie_Toy
Registered User
 
Join Date: Nov 2004
Posts: 1
Newbie_Toy is on a distinguished road
C# + Access

I have a ploblem with MS access with ExecuteNonQuery().
The "ExecuteNonQuery" I'm trying to execute a 10000 INSERT statement (which
executes fine in SQL+). The INSERT statement executes properly 30% of the
time( I use progress bar to see), but throws this error sometimes. please help me! I don't know what's happening.
Newbie_Toy is offline   Reply With Quote
Old 11-10-2004, 11:53 PM   #2 (permalink)
sde
Moderator
 
sde's Avatar
 
Join Date: May 2002
Location: us.ca
Posts: 4,475
sde is on a distinguished road
could there possibly be quotes in the data you are trying to insert that may be screwing up the sql string? is it in a try/catch block? if so, are you printing the exception? any other info about the errors?
__________________
Mike
sde is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
c simple question problem with switch case if13121 Standard C, C++ 1 10-24-2004 09:43 PM
Access denied for user: '@192.168.0.71' (Using password: NO) infinite_root PHP 11 04-28-2004 05:30 PM
edit? anon Lounge 10 11-21-2002 03:02 PM


All times are GMT -8. The time now is 10:29 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0 RC8





Copyright © 2000-2008, Milano Interactive
Web Hosting provided by Portal 360 Web Hosting