Post reply

vb6 and sql2000/msde

  • January 15, 2004 at 2:43 pm

    #162950

    using vb6,is there any way to determine whether a connection is to sql server 2000 or msde?

  • January 15, 2004 at 3:08 pm

    #490294

    You can search the version string for "MSDE".  You can get the version string via DMO (the VersionString property of the SQLServer object) or by executing a SQL query like

    SELECT @@VERSION



    --Jonathan

  • January 15, 2004 at 3:24 pm

    #490298

    excellent!!! that works perfect!!

    thanks!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply