[oledb] Forum Topics

Hello to all, sorry if my english is not so good, I will try to explain the problem. I need to copy all data from a Table of a Acces mdb (connected with OleDB) to a Table of a MySql DB (connected with ODBC) I made a working solution, but …

I have a C# WCF Ajax service with an OperationContract that accepts a string of text that is expected to be CSV. I have written most of a CSV parser for this, but I would like to possibly use OLEDB to parse this string. Is this possible? I would rather …

I keep getting the following error when I try to add new record into database (Access 2007) "The INSERT INTO statement contain unknown field name:'login'." I dont whats wrong as the coding looks fine and the field login does exist in the database. Spent whole day trying to find the …

The program is currently trying to pull information from three different database tables and compiling the information onto one screen, to do this i am using three different connections and a function to handle the data at each stage. The issue is as my code hits PageLoadStage of "2" and …

Hello, everyone, My question deals with Excel, and not Access, but I understand they should be roughly the same. I have an Excel worksheet which contains several tables. The tables are actually named ranges; basically, I grabbed an area, gave it a name, and -voila!- it is a table. Until …

what's up when i call the function below i get an error that says that oledb is not regstered on this machine i am calling the function like this [CODE] ListBox1.Items.Add(getAllTableNames) [/CODE] [CODE] Public Shared Function getAllTableNames() As String() Dim con As OleDb.OleDbConnection Dim com As New OleDbCommand Dim i …

So i have tried basically 30 different methods of going about this all with different errors in every form and fashion. Basically all im trying to do is write to my database in some form or fashon. Im having no problems reading from it but i need to change some …

As the title suggests, i am trying to pull a bitmap image stored in a table location with an OLEObject type to my picture box on the form. The code i am using is as following: [CODE=VB.NET]img_ProductPicture.Image = DS.Tables("LocationInfo").Rows(0).Item(5)[/CODE] The error i am receiving is an InvalidCastException: Unable to cast …

Every time i try to run this codei get the following error: "'System.Data.DataRow.Protected Friend Sub New(builder As System.Data.DataRowBuilder)' is not accessible in this context because it is 'Protected Friend'. " this is my first time to insert using oledb and the With method. [CODE] Imports System.Data.OleDb Public Class frmAddd Dim …

Hi Everyone, Ive been messing around the OLEDB in C#, What im trying to do is create a program that would read from a Access Database, and then the user has the right to add,edit and delete a records. So far i can get the Database to display and are …

Originally I was using Office Interop to import data, but that was a headache and a half for both me and my computer. Right now I'm attempting to load it with ACE, but my data grid isn't being populated. Once that's up and running I need to know how to …

Im Writing a c# Code that Takes an Excel Sheet ,creates the Corresponding SQl table and Dumps the data in a new table in SQL. Now My problem is: In the " create table" command , i have to specify the DATATYPE for the column !i.e. CREATE TABLE "table_name" ("column …