Re: Performance of ODBC

Most likely this is a problem with your or your ISP network configuration,
most likely with DNS. I just tried to connect from home computer to sql
server running at my work computer and published on the firewall; both
Access through odbc and vb6 program were able to connect and extract the
data practically instantly..

Did you try tracert to your server?

Also, if you close your Access and then reopen and reaccess the server data,
is it still slow? perhaps sql server is autostarted when you connect first
time, or maybe the database is autoclosed and needs to reopen?

Vadim Rapp


.

Relevant Pages

  • Re: slow DNS caused extreme SQLS memory pressure+CPU?
    ... RAM in my 64-bit SQL Server box. ... The DNS problem occurring at almost the same time is simply ... The CPU on the SQLS ...
    (comp.databases.ms-sqlserver)
  • Re: NewBie ASP.NET on a PDC securiy sugestions
    ... are about 25, I am running SQL, and imail, and DNS on the server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Renaming cluster
    ... DNS refresh times can bite you. ... Senior SQL Infrastructure Consultant ... Microsoft SQL Server MVP ... > cluster and retire the SQL 2000 server. ...
    (microsoft.public.sqlserver.clustering)
  • Re: 5 static IPs - How to best utilize them - Request for comments -
    ... the web server in the DMZ that Trevor mentioned (and only IF you decided ... You mentioned you have SBS premium... ... Why would you want a seperate IP for SQL? ... DNS on your server is really only serving local addresses. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL 7.0 on Windows 2000
    ... You can create a clustered file share and group it with the SQL server ... If you already have used the old name for your cluster, ... problems with a DNS alias You may even prevent the cluster from coming ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)