I love adodb but all options are ok. Your answer is in php abstaction libraries. I asked linktaker "how can i encapsulate the data access in php?" and I got this answers. http://www.linktaker.com/grab.php?idQ=69 Hernán Mauricio Velásquez Ingeniero Sistemas y Computación Universidad de los Andes Santafé de Bogotá ----- Mensaje original ---- De: vanila2000 <vanila2000@xxxxxxxxx> Para: php-objects@xxxxxxxxxxxxxxx Enviado: martes, 14 de agosto, 2007 2:25:56 Asunto: Re: I need a universal connection You can also use PEAR DB Package which is by default available with PHP 5 and above. It is a set of abstraction library allowing you to connect to any database you want to connect. --- In php-objects@ yahoogroups. com, Krishna Srikanth <krishna.srikanth@ ...> wrote: > > Hi Anees, > > 1) For this, in your package, you need to package all kinds of libraries, > mysql, mssql, odbc, etc.. > 2) While installing, you can ask for the type of database the user wishes > to have and write it into some config file. > 3)While running your script (after installation is finished), based on the > config file value, include only that db library. > > Just wanted to tell you that, for sql server, using stored procedures is > an efficient way, instead of querying with big sql statements. MySQL can > bare the sqlquery transport, but SQL server itself is very heavy loaded, > and causes problems. So use stored procedures for your mssql > installations. > > Bye, > Manda Krishna Srikanth > http://www.krishnas rikanth.com > http://www.ksjourna l.info > > php-objects@ yahoogroups. com wrote on 08/08/2007 11:37:39 PM: > > > Hi, > > > > I am interested in developing a web application to which I can > > attach any of db like mysql,access, sql server,oracle ... as it is > > there in most of projects where during the installation we select > > any of optional db. > > > > > > how to write such a code which can work with all of databases. > > > =====-----== ===-----= ==== > Notice: The information contained in this e-mail > message and/or attachments to it may contain > confidential or privileged information. If you are > not the intended recipient, any dissemination, use, > review, distribution, printing or copying of the > information contained in this e-mail message > and/or attachments to it are strictly prohibited. If > you have received this communication in error, > please notify us by reply e-mail or telephone and > immediately and permanently delete the message > and any attachments. Thank you > > > > > [Non-text portions of this message have been removed] > <!-- #ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;} #ygrp-mlmsg table {font-size:inherit;font:100%;} #ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;} #ygrp-mlmsg pre, code {font:115% monospace;} #ygrp-mlmsg * {line-height:1.22em;} #ygrp-text{ font-family:Georgia; } #ygrp-text p{ margin:0 0 1em 0;} #ygrp-tpmsgs{ font-family:Arial; clear:both;} #ygrp-vitnav{ padding-top:10px;font-family:Verdana;font-size:77%;margin:0;} #ygrp-vitnav a{ padding:0 1px;} #ygrp-actbar{ clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;} #ygrp-actbar .left{ float:left;white-space:nowrap;} .bld{font-weight:bold;} #ygrp-grft{ font-family:Verdana;font-size:77%;padding:15px 0;} #ygrp-ft{ font-family:verdana;font-size:77%;border-top:1px solid #666; padding:5px 0; } #ygrp-mlmsg #logo{ padding-bottom:10px;} #ygrp-vital{ background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;} #ygrp-vital #vithd{ font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;} #ygrp-vital ul{ padding:0;margin:2px 0;} #ygrp-vital ul li{ list-style-type:none;clear:both;border:1px solid #e0ecee; } #ygrp-vital ul li .ct{ font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;} #ygrp-vital ul li .cat{ font-weight:bold;} #ygrp-vital a { text-decoration:none;} #ygrp-vital a:hover{ text-decoration:underline;} #ygrp-sponsor #hd{ color:#999;font-size:77%;} #ygrp-sponsor #ov{ padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;} #ygrp-sponsor #ov ul{ padding:0 0 0 8px;margin:0;} #ygrp-sponsor #ov li{ list-style-type:square;padding:6px 0;font-size:77%;} #ygrp-sponsor #ov li a{ text-decoration:none;font-size:130%;} #ygrp-sponsor #nc { background-color:#eee;margin-bottom:20px;padding:0 8px;} #ygrp-sponsor .ad{ padding:8px 0;} #ygrp-sponsor .ad #hd1{ font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;} #ygrp-sponsor .ad a{ text-decoration:none;} #ygrp-sponsor .ad a:hover{ text-decoration:underline;} #ygrp-sponsor .ad p{ margin:0;} o {font-size:0;} .MsoNormal { margin:0 0 0 0;} #ygrp-text tt{ font-size:120%;} blockquote{margin:0 0 0 4px;} .replbq {margin:4;} --> __________________________________________________ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ¡gratis! Regístrate ya - http://correo.espanol.yahoo.com/ [Non-text portions of this message have been removed]
