Hi All,

When I try to create a dynaset with the SQL string "EXEC joe" where "joe"
is the stored procedure, it gives me an error. Anyone know how to execute
stored procedures from Visual Basic?

Cheers,
Dan

If I remember correctly (which I may not), VB3 does not allow you to
create snapshots or dynasets from stored procedures... VB4 only allows
you to create snapshots, so VB3 certainly does not allow creation of
dynasets...

Unfortunately, you didn't mention which SQL server you are using nor which
error message exactly appeared.

If you simply want to execute a stored procedure which
_does_not_return_a_resultset_, you may use the EXECUTE method of your
database object.

If you are using a SQL server and the stored procedure _does_ return a
resultset, you need to specify the dbSQLPassThrough value as option
parameter when running CreateDynaset (dbSQLPassThrough has the numeric
value 64, e.g. &H40).

My wishes are with you,

*str