RE: [PHP-WIN] Help, connection object in php

Ah well, though I quite believed I was probably going to be wrong anyway! :) Thanx for the info though, nice when someone takes the time to explain it. :) Ross PS. Again, look at my disclaimer ;) -----Original Message----- From: Svensson, B.A.T. [mailto:B.A.T.Svensson@lumc.nl] Sent: 30 October 2001 01:54 To: 'php-windows@lists.php.net ' Cc: 'Ross Fleming ' Subject: RE: [PHP-WIN] Help, connection object in php Sort of. The main purpose with ODBC is though to scale away the lower layers of setting up a connection - making it target independent, but also get rid about having to think about which kind of network protocol to use, etc, etc. Once encapsulating all boring stuff of ODBC in C++ objects it gets in fact quite nice to work with, but according to my experience larger bulk inserts starts to behave strange with ODBC (I am talking about doing several hundred of thousand or millions of inserts in one single run.) A common mistake when one migrate a database and hence have to change the ODBC connection is to forget to create the user account on the target RDBMS - of course causing connection problem - this might, by the way, be the problem Aaron experience right now - but for now I lack enough information to be able to judge on that one. To be continued. :) So I wouldn't say it hazzle free, but still easier - but only once everything is set up properly. ;) -----Original Message----- From: Ross Fleming To: aaron; php-windows@lists.php.net Sent: 2001-10-30 02:32 Subject: RE: [PHP-WIN] Help, connection object in php Forgive my ignorance but doesn't ODBC do this for you, pretty much hassle free? I've only briefly looked into this once though. Ross PS I've REALLY only dabbled in this when tossing an idea over in my head, I should really have a disclaimer: The above statements could well be a load of ^%%&!! Feel free to ridicule them. :) -----Original Message----- From: aaron [mailto:atd@u.washington.edu] Sent: 29 October 2001 18:17 To: php-windows@lists.php.net Subject: [PHP-WIN] Help, connection object in php Is is possible to set the connection object to point to a database on another server? I'm using SQLserver and IIS and would like to point the connection object to the SQL server. SQL server is on one computer and IIS is on another. Thanks, Aaron -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net For additional commands, e-mail: php-windows-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net For additional commands, e-mail: php-windows-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net For additional commands, e-mail: php-windows-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net