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!
JLCPCB – Prototype 10 PCBs for $2 (For Any Color)
China’s Largest PCB Prototype Enterprise, 600,000+ Customers & 10,000+ Online Orders Daily
How to Get PCB Cash Coupon from JLCPCB: https://bit.ly/2GMCH9w