Can Stored Procedures be used with VB5/DAO/SQL Server 6.5?
Quote:
> Is it possible to use stored procedures in a VB5, DAO and SQL Server 6.5
> environment?
> I have no trouble coding the stored procedures in the database but cannot
> find any doco on how to run the stored procedures from my VB client. I have
> done this previously in the VB6/ADO/SQL Server 7.0 environment, and now need
> to do it in the environment detailed above. Can anyone point me in the right
> direction?
If the stored procedure returns its results in a recordset, you can use
passthrough queries. See the dbSQLPassThrough option to OpenRecordset.
--
WARNING: I cannot be held responsible for the above They're coming to
because my cats have apparently learned to type. take me away, ha ha!
