Hello experts in ASP - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

Hello experts in ASP



hi friends my name is aravind n i am working as a project Assistant in BITS,pilani. actully i am not so good in ASP. but i want to work in it.

so i have got a problem here i am using oracle 9i as backend.

what i need to do is there are two databases n i need to copy those databases in to a single database.

here the problem is that those two databases contains tables of similar structure so i need to append the values in a single database i dont want them to override one table with the other one.

so if anyone knows what to do with this plz.. reply me.

or can i connect to two databases using a single Data Source Name..
is that possible and if that is possible hw to do that.

if that is possible my problem is solved.

plz.. help me in this, this is a good question for experts in ASP also..


thanx in advance
bye
aravind

Comments

  • faustinegeorgefaustinegeorge Posts: 351Member
    that's a good one.The way I (Not an expert) think it could be done is :

    1.I think you need two dsns ,I could be wrong.
    2.The fact that both db's are identical helps.
    3.Get the table names from the first db ("Select tname from tab").
    4.For each of these tables,do "Select * from table".
    5.Insert into the corresponding table in the second db,using the second dsn.
    6.loop

    That's the general idea .

    Start with it.And all the best.
    There are others here who could help more.


    Faustine
    --------






    :
    :
    : hi friends my name is aravind n i am working as a project Assistant in BITS,pilani. actully i am not so good in ASP. but i want to work in it.
    :
    : so i have got a problem here i am using oracle 9i as backend.
    :
    : what i need to do is there are two databases n i need to copy those databases in to a single database.
    :
    : here the problem is that those two databases contains tables of similar structure so i need to append the values in a single database i dont want them to override one table with the other one.
    :
    : so if anyone knows what to do with this plz.. reply me.
    :
    : or can i connect to two databases using a single Data Source Name..
    : is that possible and if that is possible hw to do that.
    :
    : if that is possible my problem is solved.
    :
    : plz.. help me in this, this is a good question for experts in ASP also..
    :
    :
    : thanx in advance
    : bye
    : aravind
    :

  • studaravindstudaravind Posts: 2Member

    thanx Faustine

    but the problem here can i have DSN's in the same page..
    see in ur case what ever u are saying i have to be connected to two databases at a time is this possible if possible how???
    hope u reply me back..
    bye
    aravind


    : that's a good one.The way I (Not an expert) think it could be done is :
    :
    : 1.I think you need two dsns ,I could be wrong.
    : 2.The fact that both db's are identical helps.
    : 3.Get the table names from the first db ("Select tname from tab").
    : 4.For each of these tables,do "Select * from table".
    : 5.Insert into the corresponding table in the second db,using the second dsn.
    : 6.loop
    :
    : That's the general idea .
    :
    : Start with it.And all the best.
    : There are others here who could help more.
    :
    :
    : Faustine
    : --------
    :
    :
    :
    :
    :
    :
    : :
    : :
    : : hi friends my name is aravind n i am working as a project Assistant in BITS,pilani. actully i am not so good in ASP. but i want to work in it.
    : :
    : : so i have got a problem here i am using oracle 9i as backend.
    : :
    : : what i need to do is there are two databases n i need to copy those databases in to a single database.
    : :
    : : here the problem is that those two databases contains tables of similar structure so i need to append the values in a single database i dont want them to override one table with the other one.
    : :
    : : so if anyone knows what to do with this plz.. reply me.
    : :
    : : or can i connect to two databases using a single Data Source Name..
    : : is that possible and if that is possible hw to do that.
    : :
    : : if that is possible my problem is solved.
    : :
    : : plz.. help me in this, this is a good question for experts in ASP also..
    : :
    : :
    : : thanx in advance
    : : bye
    : : aravind
    : :
    :
    :

  • faustinegeorgefaustinegeorge Posts: 351Member
    You will need two connection objects.Open one connection with the first dsn, and the second connection with the second dsn>I think I have seen a connection being opened with more than one dsn, though I haven't tried it myself.
    It was something like :
    con.open "DSN=DSN1,DSN2"

    btw,What will you do about the strored procedures,views etc. ?
    And,why did you chose ASP ? It could be more easier to handle with something like VB ? Just a thought.

    Faustine
    -------

    :
    : thanx Faustine
    :
    : but the problem here can i have DSN's in the same page..
    : see in ur case what ever u are saying i have to be connected to two databases at a time is this possible if possible how???
    : hope u reply me back..
    : bye
    : aravind
    :
    :
    : : that's a good one.The way I (Not an expert) think it could be done is :
    : :
    : : 1.I think you need two dsns ,I could be wrong.
    : : 2.The fact that both db's are identical helps.
    : : 3.Get the table names from the first db ("Select tname from tab").
    : : 4.For each of these tables,do "Select * from table".
    : : 5.Insert into the corresponding table in the second db,using the second dsn.
    : : 6.loop
    : :
    : : That's the general idea .
    : :
    : : Start with it.And all the best.
    : : There are others here who could help more.
    : :
    : :
    : : Faustine
    : : --------
    : :
    : :
    : :
    : :
    : :
    : :
    : : :
    : : :
    : : : hi friends my name is aravind n i am working as a project Assistant in BITS,pilani. actully i am not so good in ASP. but i want to work in it.
    : : :
    : : : so i have got a problem here i am using oracle 9i as backend.
    : : :
    : : : what i need to do is there are two databases n i need to copy those databases in to a single database.
    : : :
    : : : here the problem is that those two databases contains tables of similar structure so i need to append the values in a single database i dont want them to override one table with the other one.
    : : :
    : : : so if anyone knows what to do with this plz.. reply me.
    : : :
    : : : or can i connect to two databases using a single Data Source Name..
    : : : is that possible and if that is possible hw to do that.
    : : :
    : : : if that is possible my problem is solved.
    : : :
    : : : plz.. help me in this, this is a good question for experts in ASP also..
    : : :
    : : :
    : : : thanx in advance
    : : : bye
    : : : aravind
    : : :
    : :
    : :
    :
    :

Sign In or Register to comment.