oledbexception

OleDbException System Resources Exceeded

The following code executes a simple insert command. If it is called 2,000 times consecutively (to insert 2,000 rows) an OleDbException with message = "System Resources Exceeded" is thrown. Is there something else I should be doing to free up resources? using (OleDbConnection conn = new OleDbConnection(connectionString)) using (OleDbC...

System.Data.OleDb.OleDbException: Too many fields defined

I'm working on building a .NET WinForms application to replace a series of forms in a Microsoft Access (insert collective groan here) database. In an effort to get the initial version finished, I am attempting to use the existing queries rather than digging into the data model and its obvious design problems. I'm calling the queries us...

OLE DB Exception - database/user/password is too large

I'm trying to connect to a database using OleDbConnection and a connection string, the error given within the try-catch statement is 'database/user/password is too large'. What does that statement mean, and how can I solve this problem so I can connect to my database? My database is using a SQLBase driver. ...

Sql error "Arithmetic operation resulted in an overflow."

Hello! I am running a service that does some computation and communicates with an ms sql server every minute or so (24/7, uptime is very important) and writes to error log if anything funny happens (like a timeout or lost connection). This works great, however once in a while I will get this error: Arithmetic operation resulted in ...

OleDB connection only working when debugging

I have a C# application that connects to a named SQL Express instance on the local machine using OleDBConnection: _connection = new OleDbConnection(_strConn); _connection.Open(); _strConn is something like this: "Provider=sqloledb;Data Source=.\NAMEDINSTANCE;Initial Catalog=dbname;User Id=sa;Password=password;" If I debug the applica...

Error executing update over OLEDB from C#

I am using OLEDB to Update data in .dbf database from c#. I get Error: System.Data.OleDb.OleDbException {"Undefined function 'replace' in expression."} on ExecuteNonQuery. How can I make this work with least changes, i need to replace double quotes with single quotes in many files, so i have to automate this process. Should I try ODBC...

OleDB + Jet: Syntax Error in Join Operation

I've built a complex query for my access database and in access it works like a charm. But when I try to run the same query in my program via OleDB I get the exception "Syntax Error in Join Operation". No further info. SELECT MainTable.Main_dbID, D0.Kvp_Value AS ["Value"] FROM (MainTable INNER JOIN ( SELECT Main_dbID, Kvp_Va...