Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    107

    Unanswered: ODBC Virtual Driver

    Hi,
    I have the following requirement :

    I need to have a way to intercept the SQL queries from an application written in VB and using a ODBC driver and modify the SQL queries before it goes through the ODBC driver and then to the database. This I need to do without modifying the original application.

    The solution I have in mind is to write a ODBC virtual driver and configure my application to use my virtual ODBC driver. The ODBC virtual driver in turn will use the actual ODBC driver to the database. The virtual driver will basically intercept the SQL queries, modify it and then give it to the real ODBC driver.

    My question is

    1. Is this a feasible solution?
    2. What should I do in order to implement the vitrtual ODBC driver.
    3. Any pointer will be appreciated.

    Thanks
    Jake.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    NEver heard of virtual odbc driver, but you may find some information from http://www.microsoft.com site.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Feb 2004
    Posts
    107
    Hi,
    What I meant by Virtual driver is basically a ODBC proxy which can sit between my application and the ODBC driver and intercept the SQL queries.

    Thanks
    Jake


    Originally posted by Satya
    NEver heard of virtual odbc driver, but you may find some information from http://www.microsoft.com site.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'm working from memory here, but I think an ODBC Proxy something like you are describing is included as a VC project in the ODBC Driver SDK.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •