Re: Proxy + ADO + VB6...

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

When I'm on some customer running proxy behind, the VB6 app does not connect
on SQL SERVER (default port) hosted on ISP. But if the connection is NAT or
direct, the app works well...

On IE when is proxied (like SQUID) connection shows the server IP to
route... if there's a way to put it on conn string maybe it'll work. But I
dont think I can do it.... thanks!

"Ralph" <nt_consulting64@xxxxxxxxx> escreveu na mensagem
news:eXEK%23UT8JHA.4176@xxxxxxxxxxxxxxxxxxxxxxx

"Paulo" <eris_paulo@xxxxxxxxxxxx> wrote in message
news:%23O%23Pn$Q8JHA.4608@xxxxxxxxxxxxxxxxxxxxxxx
Hi, I've ConnStr that points to a external IP, like: "SQLOleDB...
host=200.138.0.10"... but if I'm on some place that has a proxy to go
outside, the VB6 app can not reach the external SQL SERVER port 1433...
do
you have any hints to solve it ?

Using VB6 + ADO

Many thanks!



Always go to this spot first with any connection string issues. <smile>
http://www.connectionstrings.com/

The general form is:
Data Source= tcp:<IPAddress>, <port number>;[ Network Library=XXXXXXX]

If that doesn't work, then there is likely something else in play, and you
will have to check with network administration (may need to adjust
security,
permissions, another port?). In other words, there is little else you can
do
with a connection string.

-ralph




.

Relevant Pages

  • Re: SQL2005: Cannot connect error 11001
    ... I believe the complete Windows auth user access is too complicate, ... which trusted connection is meant? ... it would still be listening on the old port. ... Microsoft, SQL Server Books Online ...
    (microsoft.public.sqlserver.connect)
  • Re: Installing Sql Server Express on Vista Home Premium
    ... It seems that your SQL Server instances are Named Instances, ... Default Instances uses 1433 TCP port by default as a Static Port but not the ... If you change your Connection String as following, ...
    (microsoft.public.sqlserver.setup)
  • Re: Sql Remote Connection issue
    ... port 1433 TCP Allow ... Copyright 2006 Microsoft Corporation. ... osql does not support all features of SQL Server 2005. ... Sqlcmd: Error: Microsoft SQL Native Client: An error has occurred while establishing a connection to the server. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server 2005 Connection Problems
    ... - it is't completely clear what the SQL Server Browser is for. ... connection reqest was being rejected. ... I think the problem is still likely the the port is blocked by some ... firewall between the server and that client. ...
    (microsoft.public.sqlserver.setup)
  • Re: Recommended Approach
    ... Have the vb6 app do a xmlhttp post to your web server and have it do the ... The SQL Server resides locally behind the company's firewall. ... > make a direct ADO connection from the user's PC to our SQL Server. ... > Both alternatives require opening up a port on our firewall to allow SQL ...
    (microsoft.public.sqlserver.security)