Hi

Question:

Why do you use ADODB instead of ADO.NET?

Could you please wrap your code with the following exception handler and post the result. Maybe this helps to find the problem:

try

{

////////////////////////////////////////

// YOUR CODE

int i = int.Parse("blah");

////////////////////////////////////////

}

catch (Exception ex)

{

System.IO.StringWriter sw = new System.IO.StringWriter();

sw.WriteLine("======================================");

sw.WriteLine("Exception");

sw.WriteLine("Type: {0}", ex.GetType());

sw.WriteLine("Message: {0}", ex.Message);

Exception e = ex.InnerException;

while (e != null)

{

sw.WriteLine();

sw.WriteLine("-------------------------");

sw.WriteLine("Inner Exception");

sw.WriteLine("Type: {0}", e.GetType());

sw.WriteLine("Message: {1}", e.Message);

e = e.InnerException;

}

System.Diagnostics.StackTrace stack;

stack = new System.Diagnostics.StackTrace(ex, true);

sw.WriteLine();

sw.WriteLine("-------------------------");

sw.WriteLine("Target");

for (int i = stack.FrameCount - 1; i >= 0; i--)

{

System.Diagnostics.StackFrame frame = stack.GetFrame(i);

sw.WriteLine("({0}) :: {1} | File(Line:Column): {2} ({3}:{4})",

(frame.GetMethod().DeclaringType == null ? "" : frame.GetMethod().DeclaringType.ToString()),

frame.GetMethod().ToString(),

string.IsNullOrEmpty(frame.GetFileName()) ? "" : frame.GetFileName(),

frame.GetFileLineNumber(),

frame.GetFileColumnNumber());

}

stack = new System.Diagnostics.StackTrace(1, true);

sw.WriteLine();

sw.WriteLine("-------------------------");

sw.WriteLine("Origin");

for (int i = 0; i < stack.FrameCount; i++)

{

System.Diagnostics.StackFrame frame = stack.GetFrame(i);

sw.WriteLine("({0}) :: {1} | File(Line:Column): {2} ({3}:{4})",

(frame.GetMethod().DeclaringType == null ? "" : frame.GetMethod().DeclaringType.ToString()),

frame.GetMethod().ToString(),

string.IsNullOrEmpty(frame.GetFileName()) ? "" : frame.GetFileName(),

frame.GetFileLineNumber(),

frame.GetFileColumnNumber());

}

SqlContext.Pipe.Send(sw.GetStringBuilder().ToString());

}

Thanks

Flo