473,320 Members | 1,900 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Mapping oledb data to odbc target


Given: Data.oledb source, and a Data.odbc target

The oledb data is read into a dataset.

(1)

Is there an easy way to copy that dataset to the target datasource ( I
can look through the dataset and do INSERT statements, but is there a
single command to copy the data to a table ) ?

(2)

Is there a dataset object for odbc ?

(3)

Does .net have a native ado.net interface to as/400/db2 databases?

--

Go SeaHawks! Beat Saints!
Jul 21 '05 #1
1 1340
> Is there an easy way to copy that dataset to the target datasource ( I
can look through the dataset and do INSERT statements, but is there a
single command to copy the data to a table ) ?
If you're talking One Sql Statement ---
<--- You'll need to write the oneshot command as the actual database
underlying the ODBC provider could be god knows what. Even then very few
databases support the ability to persist everything from a datatable like
structure into tables - Sql Server does - XML DML

Now if you're looking for a one shot command as far as your C# code goes

Create a new DataTable,
DataTable.ImportRow (From the other datatable in a loop)
DataAdapter.Update(thisnewDatatable)

<--- remember the above will use COmmandBuilder to generate your Sql - so it
won't be pretty and won't work in every single case on the planet (i.e. if
there are PK's missing or weird joins ).

(2)

Is there a dataset object for odbc ? Yes, System.Data.DataSet is not for a provider, it's common all over.
(3)

Does .net have a native ado.net interface to as/400/db2 databases? .... I think for Db2 it does, but I really don't know :-/// !! But there are
many other ultra smart folks on this group who will know for sure. How 'bout
google? :)
- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik


"Josef Schneider" <us*@cord.blah> wrote in message
news:34*************@individual.net...
Given: Data.oledb source, and a Data.odbc target

The oledb data is read into a dataset.

(1)

Is there an easy way to copy that dataset to the target datasource ( I
can look through the dataset and do INSERT statements, but is there a
single command to copy the data to a table ) ?

(2)

Is there a dataset object for odbc ?

(3)

Does .net have a native ado.net interface to as/400/db2 databases?

--

Go SeaHawks! Beat Saints!

Jul 21 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
by: Parking Meters | last post by:
Today I managed to get the OleDB provider to let me put datasets from an as400 using sql. Great, the provider string I used is: Provider=IBMDA400.DataSource.1;User ID=XXXXX;Password=XXXX;Data...
4
by: PeteZ | last post by:
I've come from a strong ODBC usage background (using DSN's on servers) and am wondering whether I should start recommending OLEDB or SQL data providers rather than ODBC It seems that ODBC...
8
by: Johan Goris | last post by:
I've made a small test program. I connect with oleDb (in fact sqlConnection ....etc) to a SQL-server. It works fine at home. But it did not work at another place, altough other simple C-sharp...
1
by: Me | last post by:
I need to build a tool to map data from various database schemas into a system I have built. I need to be able to allow the clients of my software to use a tool to map data in their database with...
1
by: Josef Schneider | last post by:
Given: Data.oledb source, and a Data.odbc target The oledb data is read into a dataset. (1) Is there an easy way to copy that dataset to the target datasource ( I can look through the...
3
by: Giuseppe D'Elia | last post by:
Hi there, I got a problem using an MS Access database through ASP.NET. After updating my system from .NET Framework 1.0 to 1.1, my existing application gives me the following error when...
2
by: ram_palavalasa | last post by:
Hi all, I have a assignment of vc++.net and sybase to populate data and generate reports which is the best one? is OLEDB more efficient than ODBC? i think OLEDB itself is a layer on the...
5
by: Jesse Albert | last post by:
Hiyo, I'm trying to import a CSV file into a datatable using either ODBC or OLEDB. One of the columns contains an IP Address. For some reason, the IP address will not display correctly. All of...
0
by: Randy | last post by:
Hi,all I met a strange problem, I connected to access database using oledb connection, connection string like "Provider=Microsoft.Jet.OLEDB.4.0; Data...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.