Re: Connecting to access or SQL server

I believe connecting to SQL Server directly is better. Access cannot handle well concurrent users. Using the native SQL Server functions instead of ODBC should be (at least theoretically) faster as well. Andrian Martin Rokicki wrote: > > 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