Page fault after executing stored procedure on MSDE using ADO...

[jnabbott]

I have a simple form with a button, click the button and a few lines of code connect to an MSDE database using an ADO object and run a stored procedure, in this case to change a password. It runs fine, and I get the desired result. The code ends by closing the connection to the database. No errors...

When I close the form itself however, I get an invalid page fault in sqloledb.dll. Error only appears when I run the compiled exe, it does not appear inside the VB environment. Tried it on MSDE with SP2 and with SP3 with no success. However, there is no error running it on a computer with SQL 7.0 Desktop edition (SP3).

Form has a text box for messages, a button to run the code, a button to exit, and a hidden ADO control.

Any ideas?

 

[jnabbott]

Well, I fixed it anyway - I was using the execute method of the ADO connection object to run the stored procedure, I changed my code to create a command object and then used the command object to run the stored procedure - viola! No page fault, no problems...