multiple database connectivity

can i connect to more than one database from the same program.
if s how do i incorporate the same??
ie i want the dialog box displaying all the connectors
pl give me the code for the same

Comments

  • : can i connect to more than one database from the same program.
    : if s how do i incorporate the same??
    : ie i want the dialog box displaying all the connectors
    : pl give me the code for the same

    to answer the first two q's

    a ) yes, it should be entirely possible
    b ) how : by simply adding two or more connections or data controls to which ever databases you want to use.
  • [b][red]This message was edited by the toeswr at 2002-6-11 3:54:11[/red][/b][hr]
    general declaration
    --------------------
    dim con,con1 as new ADODB.connection
    dim rs,rs1 as new ADODB.Recordset

    Form_Intialize
    -------------
    set con=new Connection
    set con1=new Connection
    set rs=new Recordset
    set rs1=new Recordset

    con.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Program FilesMicrosoft Visual StudioVB98Nwind.mdb;"


    toeswr@yahoo.com
    con1.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Program FilesMicrosoft Visual StudioVB98Biblio.mdb;"

    rs.open "customer",con
    rs1.open "Titles",con1


Sign In or Register to comment.

Howdy, Stranger!

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

Categories

In this Discussion