i should have mentioned one other thing..i know that i'm getting a connection to the sql server, because i can call 2 other api's with no problems. it's just this one api that seems to give me fits. :)