Howdy, Stranger!

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

Categories

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

  • blaydeblayde Member Posts: 37
    : 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.
  • toeswrtoeswr Member Posts: 6
    [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


  • Shawn CarterShawn Carter Member Posts: 0

    _________ // http://forcoder.org // free ebooks and video tutorials about | R, C, Visual Basic, JavaScript, Delphi, Java, PL/SQL, Python, Assembly, Scratch, C#, MATLAB, Perl, PHP, Visual Basic .NET, Swift, Go, Ruby, C++, Objective-C COBOL, Prolog, Hack, Apex, Erlang, SAS, ABAP, Scheme, ML, Bash, Scala, Dart, Ada, D, F#, Kotlin, Lua, Rust, Lisp, Fortran, VBScript, Transact-SQL, FoxPro, Julia, Clojure, Crystal, Alice, Awk, Logo, LabVIEW | _____________

Sign In or Register to comment.