imhofag

imhofag

  • NA
  • 1
  • 0

Infopath using a Webservice?

Feb 18 2005 1:28 PM
Hi, I am not really a programmer and yet I find myself having to complete a program without really knowing what I am doing or if it is possible. This is what I am trying to do. I created a form using Infopath which writes directly to an SQL database. Everything here is working fine. The problem is that now I need to capture the IP of the user and compare it to IP's listed in a SQL table to return a value from the table based on which IP is requesting this (does that make sense?). Basically, all users requesting this form will be using static IP's and the table has all of the IP's in it and returns a store number based on the IP address. I couldn't really find a good way to do this directly in Infopath so I thought that I would bind Infopath to a ASP Webservice to capture the IP and then bind it to the database from there. So, here is my real question, what is the best way to capture an IP and compare it to the database using a Webservice? Is this possible? Is there an easier way to do this that I am overlooking? Any help/insights would be greatly appreciated. Thanks