By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,666 Members | 1,909 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,666 IT Pros & Developers. It's quick & easy.

DB2 Qualified Table Name Problem with ODBC.NET

P: n/a
Ali
Hello,

I have written a utility in C# using ODBC.NET. It can fetch information
from a ODBC supported database table and copy it to the other ODBC
supported DB table; provided the tables exist on both databases with
similar schema.

This is running fine when I transder data from Oracle to DB2, MySQL to
Oracle and vice versa. But it fails from DB2 to Oracle.
I am using Datasets to retrieve data (using Select command of
OdbcCommand) from source DB and persist data in destination DB while
using CommandBuilder. So CommandBuilder generates INSERT command for me
automatically.

I retrieve data from DB2 and fill in a dataset, but when I try to
persist data in the destination DB, which is Oracle, the INSERT command
generated by CommandBuilder has qualified name for the table
(dbname.schemaname.tablename) and that qualified name is the problem
part. Is anybody aware, how can I avoid qualified name generated for
tablename? The same code works fine for vice versa scenario (when I
retieve data from Oracle and persist it in DB2) and does not generate
any qualified name for the table inside INSERT command.
Any help is greatly appreciated.

Rgds,
Ali

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.