ODBC SQL Server

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Here’s my question: What is the demand on SQL Server when running a client
mdb which uses many ODBC connections? Lets say maybe a dozen tables linked by
ODBC and many calls to SP’s and views where connection strings open and close
the link to SQL Server. How could this be measured against an adp?
Thanks,
Mark

.

Relevant Pages

  • ODBC --Call Failed Error
    ... settings and originally did not change any ODBC connections. ... Within one procedure I execute 2 SQL ... I have profiled SQL Server and I see the successful ...
    (microsoft.public.access.forms)
  • Re: Query stops working with ODBC to SQL Server. Help!
    ... When I started using sql server with Access I too ... But ODBC connections, as you are experiencing, have limitations ... If you have not used ADO before but your back end is going to be Sql ...
    (comp.databases.ms-access)
  • Problems sharing a workbook created from External source
    ... I recently upgraded our SQL Server from SQL2005 to SQL2008. ... retrieved data from the SQL server using ODBC connections and brought the ... After the upgrade, ...
    (microsoft.public.excel.misc)
  • Install SQL Server 2000 on home network
    ... I'm a web developer who is trying to expand my database knowledge by ... I've kept it bare bones and am trying to install SQL Server 2000. ... Server to start when I start the computer and I can create ODBC connections ...
    (microsoft.public.sqlserver.setup)
  • Does anyone do SQL Server to Jet4 Merge Replication?
    ... We have a large legacy application built in MS Access (front-end client mdb ... with back-end shared data mdb) and are looking for a good migration path ... To me the ideal path would require that we be able to use SQL server merge ...
    (microsoft.public.access.replication)