RE: [PHP-WIN] Connecting to access or SQL server

Hi Martin, I think its faster to connect directly to the SQL-Server. If you use ODBC, then the Sourcecode is equal for Access and MS-SQL-Server. Hope this helps. Greetinx, Michael Rudel - Web-Development, Systemadministration - _______________________________________________________________ Suchtreffer AG Bleicherstraße 20 D-78467 Konstanz Germany fon: +49-(0)7531-89207-17 fax: +49-(0)7531-89207-13 e-mail: mailto:mru@suchtreffer.de internet: http://www.suchtreffer.de _______________________________________________________________ -----Original Message----- From: Martin Rokicki [mailto:Martin_Rokicki@Jabil.com] Sent: Thursday, March 01, 2001 3:07 PM To: 'php-windows@lists.php.net' Subject: [PHP-WIN] Connecting to access or SQL server Hi All, I've got PHP running on an NT box with IIS 4.0. I also have an SQL server 6.5 running on another box. Here is my question. I need to make data reports based on a database located on the SQL server. There is an access database that points to this SQL server through linked tables. What should I do? Connect to the acces database or the SQL server? Is one harder than the other? Is there any kind of advantage to using one over the other? I'm going to look at the PHP documentation to figure it all out, but any kind of head start you guys could give me would be appreciated. I have only used PHP to connect to a mysql database and have found it very easy, but have not connected to anything else. Regards, Martin -- 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