EXECUTE Stored Procedures from VBA

[barlowm]

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.

[billwagnon]

I would check the references in the project. Microsoft has new versions of the DLL that I had to download to get my SQL connection to work.

The project needs to reference "msado15.dll". My version was 1.5 but I needed 2.1 for it to work.