Re: Performance of ODBC

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Vadim

that worked because you had a port forwarded.. on the firewall side
right?

that is an insecure setup; most real security people sure wouldn't
allow that

-Aaron



Vadim Rapp wrote:
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: IS IT SAFE TO HOST SQL SERVER AND IIS SERVER ON THE SAME MACHINE
    ... > safe to host a web application on a mchine outside of our firewall ... and the sql server would reside on this one machine. ... The vulnerabilities of Windows, IIS and SQL are well known, so you ...
    (microsoft.public.inetserver.iis.security)
  • Re: Clickonce and license question question
    ... would prefer to change the way we license / register the application. ... updates the SQL server at our ISP that the license key is now in use. ... What about just meaking the company open their firewall for the server? ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: Connection error from VBScript
    ... The only firewall we use is Windows Firewall and that is disabled by default ... -2147467259 from MS OLE DB Provider, Specified SQL Server not found. ... you only need TCP/IP connectivity and TCP port 1433 to ...
    (microsoft.public.data.ado)
  • Re: Replication over a firewall
    ... inbound access is required to pull the updates from the server. ... Most projects I've done where the firewall admin won't open a port ... for replication use a VPN to get around it. ... make sure you're running sql server and sql server agent under an ...
    (microsoft.public.sqlserver.ce)
  • Re: SQL Server 2000 behind ZoneAlarm Pro 4
    ... >it is creating a log file which is not manageable. ... ZoneAlarm is not really the best thing to protect a server. ... should have a hardware firewall for better ... allow SQL Server to access Trusted, and act as server for Trusted ...
    (comp.security.firewalls)