Re: this combo: php in a windows2003 + msaccess in a samba unix sh

Tech-Archive recommends: Fix windows errors by optimizing your registry

In news:7F6FA477-0D06-4D50-A99E-5DAC856EA29E@xxxxxxxxxxxxx,
Aldo <Aldo@xxxxxxxxxxxxxxxxxxxxxxxxx> stated, which I commented on below:
Now, i think i can do any conventional type of database connection...
what should i use for faster response and performance?
ODBC? OLE? DSN-LESS?... or may be linking the access databse to the
SQL Server i have installed on the web server?, what I really wish
its to have a faster querying of the MS access database without
compromising the performance of Our SQL Server database application.

There are 2 machines involved:

Mahcine1:
Dual Core Unix Server
Samba Server
MS Access Database

Machine1:
Dual Core Windows Server
Sql Server
Apache and PHP Server

Thanks in advance.

Sorry, I'm not really a database person but would imagine that SQL using
ODBC is much faster than any Access database I've seen. But then again, I
would suggest to test it out or better yet, post this question into the SQL
newsgroups to get an expert response.

:-)

Ace


.

Relevant Pages

  • Re: SQL Server extremely slow
    ... terms of what is meant by a dis-connected ado recordset. ... table in a mdb file could be considered disconnected from the server ... Well, ok, but keep in mind the disk drive is on sql server! ... 10 reocrds from the server via odbc does not produce more ...
    (comp.databases.ms-access)
  • Linked server to ODBC DSN
    ... Server, and want to create a linked server to this same ODBC DSN: ... Provider = "Microsoft OLE DB Provider for ODBC Driver" ... Then i connect to the SQL Server using QA, and try to run my query (that ...
    (microsoft.public.sqlserver.server)
  • Re: DAO vs ADO
    ... > to re-write it at least a little but can I do it in DAO? ... > tables were on a SQL Server! ... ODBC, one table could be on the corporate server, and the other ODBC might ...
    (microsoft.public.access.conversion)
  • Re: error setting up ODBC for remote sqlexpress database
    ... We were able to get it to work with the ODBC native client driver. ... Server could be stopped in the client. ... is to install Management Studio for SQL Server 2005 Express ...
    (microsoft.public.sqlserver.odbc)
  • Re: Tools to remotely manage Access 2K
    ... No you can not use an ODBC connection over the net to a jet backend mdb ... the SQL server, and therefore you can't connect over a tc/ip connecton ... An ADP will not work in this case unless you are using SQL server (adp ONLY ... Note that before you grab a copy of this mdb file, ...
    (microsoft.public.access.gettingstarted)