Hi,
I'm new in C# programming. I received an order to create application
with ODBC technology. Application seems to be simple, It should copy
table from database, for example SQL server, to another database, for
example MySQL. I found solution with SqlBulkCopy, but I stuck with
ODBC. Do you have any idea how to do that?
Thank you in advance.
Tomasz 1 2767
Tomasz,
I wouldn't use C# for this. This is EXACTLY what Data Transformation
Services in SQL Server is used for. Sql Server 2000 and 2005 support DTS.
You can create a reusable package and then execute that whenever you wish.
Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m
"Tomek" <ts**********@g azeta.plwrote in message
news:11******** **************@ l75g2000hse.goo glegroups.com.. .
Hi,
I'm new in C# programming. I received an order to create application
with ODBC technology. Application seems to be simple, It should copy
table from database, for example SQL server, to another database, for
example MySQL. I found solution with SqlBulkCopy, but I stuck with
ODBC. Do you have any idea how to do that?
Thank you in advance.
Tomasz This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Ian |
last post by:
We are currently experiencing problems with our Access XP database. We
are using access as the front-end and are connecting to Oracle 7.3 via
ODBC. Our users are running Win 98 and Win Xp.
We are currently using Oracle73 drivers ver:1.15.03.01 File:
SQ032.73.dll Date:18/06/1996.
The Problem,
I can re-link the Oracle tables and open them within access, However
the tables take around a minute to open.
When I try to run a query I receive...
|
by: LesM |
last post by:
This is a change of behaviour between Access 2000 SP3 and Access 2002
SP3.
I have Progress table that is linked via ODBC into Access using OpenLink
Lite for Progress 9.0b. For over a year, using Access 2000 under Win98,
I have been running a Make Table or Append query against this ODBC
table and producing an extracted Access table. Any fields that are NULL
on the source ODBC table show as NULL on the output table. The query
also has an...
|
by: Bri |
last post by:
Greetings,
I'm having a very strange problem in an AC97 MDB with ODBC Linked tables
to SQL Server 7. The table has an Identity field and a Timestamp field.
The problem is that when a new record is entered, either from a form or
from the table view of the table, when the record gets saved it
immediately displays #DELETED# in all of the fields. However, if I close
the form or table view and reopen the record has in fact been inserted.
The...
|
by: leon |
last post by:
Hi all,
I have an .mdb file (access database) which has been set to table level
locking (i.e. not just records in question, but the whole table). The
database is also in sharing mode (ie. not exclusive)...
here is my problem:
i have an application that accesses the aforementioned database from Jet
ODBC driver and runs a query which implicitly locks the whole table -
|
by: Maverick |
last post by:
If i try to create foxpro table by the following "sql" statment, the C#
compiler will only return an error "xxxx not support in non-dbc version". The
"index on" command statement return some kind of syntex error too. How can i
create a DBF table with proper indexing ability ?? The "UNIQUE" keyword has
already been proved to be failed to perform normally. Please help
string sql = "CREATE TABLE datafile (field1 C(10) PRIMARY KEY, field2...
| |
by: Phil Haddock |
last post by:
Hi,
I'm converting an existing Access application to vb.net 2003.
The application allows users to select a number of tables from an ODBC data
source, and nominate names for each table to use in a local access table.
When they press the button, it deletes any local tables that exist and
recreates them using the new names, complete with current data.
In Access I loop through the list of tables and substitute the appropriate
|
by: Jim Devenish |
last post by:
I wish to copy a table on a SQL Server backend to a table on an Access
(.mdb) front end in the simplest way.
I have the following to get the recordset but am seeking something
easier.
Dim theConnectionString
theConnectionString = "Driver=SQL Server;
Server=Server;Database=myData;Trusted_Connection=Yes"
|
by: fniles |
last post by:
I would like to copy a table(s) from SQL Server 2005 to a CVS file and vice
versa.
I was thinking to use the BCP command line utility, but I have a few
questions:
1. The machine where I am going to run BCP utility does not have SQL Server
installed, so BCP.exe and its underlying DLLs are not there.
I copied BCP.EXE, then it tells me that it expects sqlncli.dll. After I
copied that DLL, it now says "Unable to load BCP resource DLL. BCP...
|
by: Weltzy |
last post by:
Hi,
I am new to SQL SERVER 2005 and want to do the following using VB6:
Set lvWrks = CreateWorkspace("", "sa", "bulemia22", dbUseODBC)
Set cns = lvWrks.OpenConnection("", , , "ODBC;DATABASE=databaseNew;DSN=LegalperfecTSQL;")
Set lvDats = cns.Database
Set lvWrkd = CreateWorkspace("", "sa", "bulemia22", dbUseODBC) ...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |