Hi BiCoolGal,
That seems like an unusual error message you're getting. Did you trying running the query under "Query Type = Text" instead of stored procedure. You may be able to connect to your database (just the Test Connection did) but for some reason the SP is not being found.