[thelist] ADOX question
Chris Blessing
webguy at mail.rit.edu
Fri Oct 11 09:41:01 CDT 2002
Dave,
IIRC the ;1 is how SP versions are denoted. You can have multiple versions
of the same stored proc with this. So:
add_event;1 is the 1st version of the add_event sp. You could also have an
add_event;2 and ;3 and so-on. How did you create these stored procs?
Sorry I can't help ya with the Procedure properties issues.
HTH!
Chris Blessing
webguy at mail.rit.edu
http://www.330i.net
> I am tinkering with ADOX in ASP, and was wondering if anybody knows why my
> stored procedure names all have ";1" appended to them?
>
> For instance, all procedure names look like this:
>
> add_event;1
> get_eventbyid;1
> add_feed;1
> ...
>
> I am using SQL Server 2000 as the provider, ADO 2.7 on the server.
>
> I haven't seen this in any of the docs or tutorials I've read so far. :(
>
> Also, I'm getting empty values for Procedure.DateCreated and
> Procedure.DateModified. The MSDN docs say the Procedure object supports
> DateCreated and DateModified, but the value is Null if the
> provider doesn't
> support this. I'm having trouble believing SQL Server 2000 doesn't support
> Microsoft's own properties...
>
> Thanks!
> -dave
More information about the thelist
mailing list