I've developed a web project that works on an ms sql server database. The problem is caused by the fact that i have to sincronize some my table using an oracle view that i can see from my web server.

I've developed a dll that do this for me, and when i call it from the browser of my web server it works fine, but otherwise from other browser in the lan it doesn't works.

The main action in the dll that i suspect can create problema are:

1) i open a connection with the ms sql DB, this is the same connection of the main program, so i don't think is the point

2) i open a log file in "C:\Users\Public\Documents\". i'm not sure this is allowed to the program, maybe this is the point?

3) i create an ODBC connection to oracle :

serv = CreateObject("ADODB.Connection")
Dim prov As String = "DSN=PAI;Uid=PAI;Pwd=PAI2016;"

All works fine if i open my program from the broser of my server, but it doesn't works from other clien!

thanks for any suggestion!