function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
lasw10lasw10 

Proxy Login

How do I configure the VBA  in the sforce_connector.xla to permit login over proxy?  Works fine with direct internet connection but fails when run on a network with proxy setup... (or do I configure the proxy settings themselves?)

Thanks
lasw10lasw10
Resolved by amending the DoLogin function

Public Function DoLogin(uname As String, pword As String) As Boolean
Dim M1 As Variant
M1 = MsgBox("Proxy Running", vbYesNo, "PROXY")
If M1 = vbYes Then sfApi.SetProxyInfo uname, pword, "", "http://locationofproxyfile"
m_isValid = sfApi.Login(uname, pword)
DoLogin = m_isValid
End Function
t anthonyt anthony
Are there any other settings to the proxy connection? I can log in and run simple queries... but if the result is larger then say 50 lines the session times out and never recovers. This happens consistently and if I run from a non proxy connection everything works fine. Is there something in the proxy or the macro I should be looking into?

thanks
crop1645crop1645
Public Function DoLogin(uname As String, pword As String) As Boolean
'   Added proxy login per http://community.salesforce.com/sforce/board/message?board.id=Excel_Connector&message.id=44&query.id=428665#M44
    Dim M1 As Variant
    M1 = MsgBox("Proxy Running", vbYesNo, "PROXY")
    If M1 = vbYes Then sfApi.SetProxyInfo uname, pword, "http://proxy.mydomain.com:myport", ""
    m_isValid = sfApi.Login(uname, pword)
    DoLogin = m_isValid
End Function
 
The above worked for me using a simple URL:port notation.  For newbies like me who don't edit VBA (ever), you get to this by going to Excel and hitting Alt+F11 and then locating the Class Module called CSession - then earch for DoLogin.
 
proxy.mydomain.com should be replaced by your proxy server and myport should be replaced by the port on your proxy server. Contact your network sysad or look on your site's intranet/wiki for these values.