SQL Database Integration

Re: Calling xp_fixeddrives from IP form

Jimmy — Tue, 16 Aug 2011 03:29:17 GMT

If you use InfoPath's built-in data connection features to access your own web service, domain trust should be fine as long as the form is published to the same domain as the web service. I think domain trust will still work if they're not on the same domain, though the user will probably be prompted for approval.

Re: Calling xp_fixeddrives from IP form

lisaa — Mon, 15 Aug 2011 17:06:39 GMT

Thanks for the info. That did allow me to get the values from the stored procedure output. If I develop my own web service and then simply call it via the InfoPath form, can my form remain Domain trusted? Or does the form still need to be full trust to call my web service? I ask because I've only called SharePoint web services from InfoPath to stuff data from the form into a SharePoint list (or read it).

Re: Calling xp_fixeddrives from IP form

Jimmy — Mon, 15 Aug 2011 16:46:15 GMT

Typically, forms have to be full trust to execute SQL from code. One way around this is to create and use a web service, which doesn't require having any code in your form at all.

Calling xp_fixeddrives from IP form

lisaa — Mon, 15 Aug 2011 13:17:21 GMT

I'm trying to call the stored procedure, xp_fixeddrives, from an InfoPath 2010 but need to make it 2003 compatible if possible. I'm familiar with doing C# coding in the form but calling this stored procedure has me stumped. I'm getting the following exception on the connection.Open() statement below. I'm an admin on the development machine (Win 7/SharePoint installed directly on it) and I have db_owner permissions on the database.

System.Security.SecurityException was unhandled by user code
Message="Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed."
Source="mscorlib"

Code sample:

string connString = "Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=WSS_NTLMOnlyContent;Data Source=.\\Sharepoint;";using (SqlConnection connection = new SqlConnection(connString))

{

// Create the command and set its properties.

SqlCommand command = new SqlCommand();

command.Connection = connection;

command.CommandText = "xp_fixeddrives";

command.CommandType = CommandType.StoredProcedure;

// Open the connection and execute the reader.

connection.Open(); // getting permissions issue

SqlDataReader reader = command.ExecuteReader();if (reader.HasRows)

{

while (reader.Read())

{

Console.WriteLine("{0}: {1:C}", reader[0], reader[1]);

}

else

{

Console.WriteLine("No rows found.");

}

reader.Close();

} // end using

Does anyone have ideas?