Vargk
asked on
Authentication through VBA- instructions
I have made an Access VBA application that runs on my local PC. The appl. is connected to an external MS SQL-database on a server. The connection use an IP-adr, a username and a password and it works fine. But before I can conntact the SQL-server I have to do a Authentication on the web with username and password,looks like this:http://aut.agdernett.no:2000/. I think it is a fireWall or something. I have got the the username/password and it works fine when I run this on the browswer manualy before I run my application.
My questiion is: How can I give this authentication in my application instead of manualy on the web. Is it possible to do this by instructons(VBA) ?
Thank you.
Varg
My questiion is: How can I give this authentication in my application instead of manualy on the web. Is it possible to do this by instructons(VBA) ?
Thank you.
Varg
ASKER
The firewall is on theirs side and I am allowed to go through. I have got the nessesary username and password. The question is how I can automate this login in my application. I want to put : http://aut.agdernett.no:2000/ + username + password in my code(VBS or VB) code(instructions), how can I do that.
Thank you
Varg
Thank you
Varg
I've pinged some other experts to take a look at this.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
mostly seems to work, but not quite. Tested with both FF 1.5 and IE 6
No objections.
What you need to do is create (or have the remote end) a passthrough on the firewall. What a passthrough essentially does is say that anything coming from or to a given address is allowed to go through without authentication, but only if it it comes from this IP address.