First of all, undo the changes recommended by the MS KB article by running "csript adsutil.vbs DELETE w3svc/createprocessasuser". MS's suggestion breaks COM application security.
Next, configure the DSN as follows:
Login tab: specify user and password as described in the Symantec KB article.
Database tab: specify your server name and put "sem5" as the database name.
Network tab: check TCP/IP and specify TCP/IP parameters: host=<yourservername>;UseUDP=no
Click OK, then open DSN configuration window again and click Test Connection. (This is something that's not obvious: Test Connection button doesn't use the new parameters until you save them by closing the configuration window.)
I'm sure this is not the way Symantec wanted to use this ODBC connection, but it works for me, so who cares.
Message Edited by ynguldyn on
11-02-2007 12:27 PM