Re: Copy a database table into another using ado.net

Tech-Archive recommends: Fix windows errors by optimizing your registry



Open a connection to both databases, read the data from one, and write
it to the other.

Robin S.
----------------------------
<kkizer@xxxxxxxxx> wrote in message
news:1167777897.160161.96810@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I need help! Here is what i have going. I have a cobal database that i
connect with using a DSN/ODBC (the source data) and i have a Sql 2000
database that i am trying to copy the data to. I have a DTS package
setup doing this task just fine but i need to do this process using
ado.net/vb.net, not using DTS (dont ask why, long story). I have been
searching around places and just cant find any good code examples to
help me get started. Can anyone helP?

I already have the tables setup in sql server and they are identical
to
the Cobal database.



.



Relevant Pages

  • VB6 Application Install
    ... ability to upgrade a SQL Server database, if needed, depending on the nature ... Create a Database if it does not already exist ... Continue on with application SETUP... ... ODBC, install MDAC, etc. ...
    (microsoft.public.vb.general.discussion)
  • VB6 Application Install
    ... ability to upgrade a SQL Server database, if needed, depending on the nature ... Create a Database if it does not already exist ... Continue on with application SETUP... ... ODBC, install MDAC, etc. ...
    (microsoft.public.vb.database)
  • VB6 Application Install
    ... ability to upgrade a SQL Server database, if needed, depending on the nature ... Create a Database if it does not already exist ... Continue on with application SETUP... ... ODBC, install MDAC, etc. ...
    (microsoft.public.vb.database.ado)
  • Re: Package fails "Cannot use a CONTAINS or FREETEXT predicate"
    ... How are you transferring the data? ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > database is working fine. ... This DTS package used to work fine for a long ...
    (microsoft.public.sqlserver.replication)
  • Re: Package fails "Cannot use a CONTAINS or FREETEXT predicate"
    ... How are you transferring the data? ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > database is working fine. ... This DTS package used to work fine for a long ...
    (microsoft.public.sqlserver.dts)