RE: ADO and Proxy Server

ingo_at_nospam.com
Date: 02/26/04 

Date: Thu, 26 Feb 2004 06:31:10 -0800

Hi Kevin,

Thanks for your reply. No, I definitely can't use port 1433 as it is being blocked, but I know in my connection string I can specify any port I want. As an example, in our office we don't have a proxy server (this is for a client application), but just a firewall doing NAT. I configured our SQL server to listen on port 80. From outside the firewall, I used the following SQL connection string:

oConn.Open "Driver={SQL Server};" & _
           "Server=xxx.xxx.xxx.xxx;" & _
           "Address=xxx.xxx.xxx.xxx,80;" & _
           "Network=DBMSSOCN;" & _
           "Database=myDatabaseName;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"

Which worked great. But it fails when I put it behind a proxy server and try and configure socks to go through port 80 as well.

Again, is there a different way to approch the problem perhaps? My end gola is to do a bulk upload from Access to SQL server. I know I could do some form of web service, packaging the data on one side, and unpackaging/importing it on the other, but my preference would be to make it as simple as possible.

Thanks,
Ingo

Relevant Pages

  • Re: Tool to find hidden web proxy server
    ... > Few smart guys have installed free proxy server running on non ... > default ports and distributed the internet access to their friends. ... BTW, if you catch one box, do a full TCP port scan of that IP to find ...
    (Pen-Test)
  • HOW TO: Acessing a Terminal Server when the client is behind a proxy
    ... Your computer is behind a firewall and proxy server. ... set to use a proxy server on port 8080. ... Java RDP Client: this is needed if you cannot use 2 PCs at work. ... The terminal server on the remote network must ...
    (microsoft.public.windows.terminal_services)
  • Re: stop all http traffic
    ... Regards, ... > people cannot access servers listening on port 80 on your Windows XP ... > they can see from the proxy server. ... > StopHTTP.cmd (stop all http traffic, include all browser navigation) ...
    (microsoft.public.win2000.cmdprompt.admin)
  • Re: Blocking Ports
    ... server to do it, and not necessarily on port 1080. ... are a small, but growing, number of open socks proxies ... > WinMX = 209.61.186.0/24 ...
    (comp.security.firewalls)
  • Re: No internet access
    ... > If I ping an external IP address or external DNS/FQDN then the ping times ... > connection to host on port 80: ... Is there a Proxy Server or other proxy in the path? ...
    (microsoft.public.win2000.dns)