Post reply

ODBC vs SQL Client

  • September 26, 2005 at 9:48 am

    #68491

    Hi All,

    Quick Question! My company is switching PC machines (Approx. Dec 1 2005) and would rather not load the SQL Client on each machine. I have currently reworked my code to Connect using ODBC (DSN-less)-- to SQL Server. Is there a way from SQL server to chck which connections to the Database are made VIA ODBC and those still being made via the SQL Client?

    Thanks

    Brian

  • September 26, 2005 at 10:49 am

    #593074

    Why would you need the client tools on each pc?

    MDAC 2.8 or later should be sufficient.

  • September 26, 2005 at 11:29 am

    #593086

    Correct.... Either way ... My question is really How can I tell the method a workstation used to connect to my SQL server via SQL Server?

  • September 26, 2005 at 4:47 pm

    #593147

    Easiest method I can think of would be to set something like the application name in the DSN-Less connection. This will show up in sysprocesses as the Program Name. Then you can query sysprocesses on the server and extract the hostnames.

     

    --------------------
    Colt 45 - the original point and click interface

  • September 27, 2005 at 9:53 am

    #593341

    This can be useful in identifying the host AND the program connecting to you SQL Server database.

    In Query Analyzer execute

    exec sp_who2

    Note the "PorgramName" column.

Viewing 5 posts - 1 through 4 (of 4 total)

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