Sorry if this is a little off topic but I have a question related to Infopath
form.

I am using web matrix to create a web service (asmx) file using VB and when
I use Firefox or Explorer I am able to access the web service but not run any
connections to the database unless I press F5 ( creating an 8080 virtual
port) on my local XP machine running the web server. I already tried moving
the asmx file to another server running IIS and the same result. I am not
sure what's causing this.

Do I need to create the DLL compile the source code and place the DLL inside
the BIN directory?

Here's the code from the file:

<%@ WebService language="VB" class="studentinfo" %>

Imports System
IMPORTS SYSTEM.DATA
Imports System.Web.Services
Imports System.Xml.Serialization

Public Class studentinfo

   <WebMethod> Public Function Add(a As Integer, b As Integer) As Integer
       Return a + b

   End Function

<WebMethod()> Public Function GetProfile( Studentid As long) As DataSet

       Dim dstProducts As Data.DataSet
       Dim connectionString As String = "server='server123';
trusted_connection=true; database='thedb'"
       Dim dbConnection As System.Data.IDbConnection = New
System.Data.SqlClient.SqlConnection(connectionString)

       Dim queryString As String = "SELECT [FIRST_NAME], [LAST_NAME],
[MIDDLE_NAME], [STUDENT from xyz where id =12344555"
       Dim dbCommand As System.Data.IDbCommand = New
System.Data.SqlClient.SqlCommand
       dbCommand.CommandText = queryString
       dbCommand.Connection = dbConnection

       Dim dataAdapter As System.Data.IDbDataAdapter = New
System.Data.SqlClient.SqlDataAdapter
       dataAdapter.SelectCommand = dbCommand
       Dim dataSet As System.Data.DataSet = New System.Data.DataSet
       dataAdapter.Fill(dataSet)

       Return dataSet

End Function
End Class

BTW:  the ADD function works fine. ;-)

This is the error when I try the GETPROFILE:
System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason:
Not associated with a trusted SQL Server connection.
  at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
  at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)