Help!!!

Can anyone tell me if it is possible to execute MS SQL stored procedures using VBScript written in Outlook forms?

I am attempting to use the string below to execute the stored procedure but this results in an "DAO.connection ODBC--Call Failed" error.

Set Rs = conDB.OpenRecordset("EXECUTE storedprocname", dbOpenSnapshot)

If I use the same string to execute a query in a replica MS Access database then it works fine. Its only when I connect to the SQL database. I know for sure that the connection isn't the problem because the string below works fine:

Set Rs = conDB.OpenRecordset("SELECT something FROM thedatabase", dbOpenSnapshot)

Its only a problem when trying to excute a MS SQL stored procedure by refering to its name.

If anyone can shed any light on this it would be hugely appreciated.

Thank you !!!!

Mike.