Very Computer

Has anyone experience with a plug-in that handles the interface to MS SQL?

Need something that could execute stored procedures and return results to
arrays and variables as well as handling or reporting errors.

Noticed that there is at least one vendor that offers something like this.

Any experiences or recommendations?

Thanks in advance

Roy

Quote:> Has anyone experience with a plug-in that handles the interface to MS SQL?

> Need something that could execute stored procedures and return results to
> arrays and variables as well as handling or reporting errors.

> Noticed that there is at least one vendor that offers something like this.

> Any experiences or recommendations?

> Thanks in advance

> Roy

I made one on my own. If you want it, just email me.
You will have to extra functions in VB:

1.     xxx =
SelectStoredProc(NameOfStoredProc,ArrayOfParamNames,ArrayOfParamValues,Adodb
RecordSet)
        when xxx returns true, the storedproc succeeded, and you can do all
kind of things with the AdodbRecordSet like
        you are probably used to be.

2.      xxx =
ActionStoredProc(NameOfStoredProc,ArrayOfParamNames,ArrayOfParamValues)
         when xxx return true, the actionstoredproc (delete,insert,update)
did succeed

--
Wauters Kris
Creator of the *free* Vision Command ActiveX  >>
http://www.snoozysplace.be.tf  <<
Home enthousiast Dreamcast developer  >>  http://www.snoozys-dc-stuff.be.tf
<<
*** Remove .nospam from emailadres before sending me email ***