Re: ADODB ............HELP PLEASE

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

From: alpine (alpine_don'tsendspam_at_mvps.org)
Date: 06/14/04


Date: Mon, 14 Jun 2004 01:45:09 -0600

On Mon, 14 Jun 2004 08:07:45 +0100, "NEWS" <newsgroup@questinfo.com>
wrote:

>I have some simple VB6 ADO code to open a database across the internet.
>
>This code failes on one client - I suspect because they have a Proxy
>server.
>
>What paramaters are there in the connection.open to specify a Proxy server
>IP address or Port No.
>
>Any ideas please.
>
>THIS IS THE CODE:-
>
>I have some VB6 code (which works fine) :-
>
>Dim cn As ADODB.Connection
>Set cn = New ADODB.Connection
>cn.Open "Driver={SQL Server};" & "Server=myserver.com;" &
>"Database=clients;network=dbmssocn;"
>cn.Close
>
>Thanks
>
>Garry

You might want to have a look at Carl Prothman's connection strings
page....

  http://www.able-consulting.com/ADO_Conn.htm

HTH,
Bryan
____________________________________________________________
New Vision Software "When the going gets weird,"
Bryan Stafford "the weird turn pro."
alpine_don'tsendspam@mvps.org Hunter S. Thompson -
Microsoft MVP-Visual Basic Fear and Loathing in LasVegas



Relevant Pages

  • Re: Mozilla Firefox: Forbidden page
    ... Marvin Gerardo Aguero Salazar wrote: ... w3m is installed on my computer, but I cannot find a way to specify ... runs your proxy server doesn't like people downloading free software. ...
    (Debian-User)
  • Re: 85010008 - The proxy server you have specified is incompatible...
    ... see anywhere in the settings/options for IE on here to set a username ... Error code 85010008 ... "The proxy server you have specified is incompatible with your ... Specify the correct proxy server in your connection ...
    (microsoft.public.pocketpc.activesync)
  • Re: Localhost:Port? Curious!!
    ... Check here under P for Proxy Server: ... Troubleshooting Windows XP ... If we don't specify the connection will be direct. ... > case browser connecting to which Ip name or Ip address and which port ...
    (microsoft.public.windowsxp.general)
  • Re: imap4_SSL from behind a proxy server
    ... I suspect there are some environment ... So "I need to direct all non-HTTP traffic through a proxy server." ... there is no such thing as general proxying, and thus no support in any library e.g. imaplib or such. ...
    (comp.lang.python)
  • Re: Software updates download fails
    ... smsbus as the proxy server and 80 as the port to use. ... need to run the tool again and specify an account which does have access. ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.sms.tools)