Re: ODBC

Thanks for the info. I use PHP3 and PostgeSQL and Linux Redhat server. My understanding is that the way you read in data from the database would remain the same. Therefore in terms changing to using ODBC later in the future you could simply change the part that connects to the database to the ODBC method and the rest would remain the same (e.i. the part where the results from the queries are assigned to variables etc.). Thanks people, Abe ----- Original Message ----- From: "Daniel Convissor" <danielc@analysisandsolutions.com> To: "PHP List" <php-general@lists.php.net> Sent: Tuesday, October 10, 2000 3:42 PM Subject: Re: [PHP] ODBC > Hi Abe: > > > I use PHP3 and PostgreSQL very successfully. What I don't understand is > > ODBC. I have read a little about it but it appears to be a Microsoft type > > product. Is this something I should consider learning more about if I want > > to interact also with other databases. > > Sure. It allows you to interface with more database types. Only drawback is > ODBC is a bit slower than working with the native database functions in PHP, > like for Postgree and MySQL. > > Basically, you need to create a SYSTEM DSN for each database you want to > connect to. Then, connect to it using the odbc_connect() function. At that > point you can use the odbc_exec() function, etc, to work with the data. > > If you need specific questions answered, you'll need to let us know what you > want to konw. Also, when asking, explain which OS you're on and which > database type you're trying to connect to. > > --Dan > > -- > T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y > More than just answers. Solutions. (SM) > http://www.analysisandsolutions.com/ > 4015 7 Av #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409 > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >