More than one DATABASE
Luis Carlos Díaz Otero <[email protected]>
| Newsgroups | gmane.comp.lang.4gl.aubit.general |
|---|---|
| Message-ID | <818384.228259.1420734306993.JavaMail.yahoo@jws10671.mail.bf1.yahoo.com> |
Hi group. Is it possible to connect to more than one MySQL database from the same program?. I.E.: one MySQL database (the main one) is local in my machine and its connection is done thru DATABASE clause at the beginning of the program, but i need to query some tables on another MySQL database located in another machine in the same network. How can i implement it?. DATABASE maindatabaseGLOBALSDEFINE ..................END GLOBALSMAIN... some stuff..SELECT column1,column2,columnn FROM otherdatabase.tableintheotherdatabase WHERE ... Or, in the other hand, can i use OPEN SESSION for doing so? It is very important for us that we can query more than one database in the same program. Anyone can help with this? Cordial saludo: Luis Carlos Díaz Otero Hay 10 clases de personas en el mundo: las que saben de números binarios y las que no Asesoramos y acompañamos su presentación de tareas y trabajos de matemáticas: Quieres aprender a desarrollar aplicaciones de escritorio gráficas en Linux? O visita nuestra página web ------------------------------------------------------------------------------ Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net _______________________________________________ Aubit4gl-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss