Silk Agent connect remote oracle server
we are connect oracle server through public ip(like remote machine) and get the values from the database.
can i use statement db_connect in silk editor for getting the database values from the remote server.
I tried to config DSN in my loacl machine using same above ip but in my local system i don't have any oracle client. so am unable to config DSN in my local machine(if i can install oracle client i need license version). is it possible without using oracle client can i config dSN?
Please let me know how i can get the values from the database through any remote agent/ any solustions....
Re: Silk Agent connect remote oracle server
>can i use statement db_connect in silk editor for getting the database values from the remote server.
Yes, but that will just open the connection. You'll need DB_ExecuteSQL statements to query the instance, and return data.
>is it possible without using oracle client can i config dSN?
It depends on which Oracle version you're running, (and what you want to do), you might be able to use the M$ Oracle driver, which should/might connect successfully to a remote Oracle instance. If not, try installing the Instant Client. It's free, and although it probably lack some of the tools you get if you install an Adminstrator-level client, it may be enough to do what you want. I have never needed to try it as we are fully licensed for Oracle.