I am having a hard time trying to connect to an oracle database to retrieve some data in a table and then export to a file. Can anybody provide me a basic script that shows how to connect to an oracle database providing the hostname,DB name and username and password and the Table to select from and then export the result to a file.
Is it the same way to connect to an oracle DB and mysql?
I totally don't understand Oracle, but I installed the Express version and was able to connect using the following two methods. The first, I was able to connect to localhost using the .NET client
When attempting to connect from a remote machine, however, I ran into issues. I don't know enough about Oracle to know if it was just because the .NET client has been deprecated, but I ended up downloading the odp.net client, installing it to the GAC, then I used this technet post as a reference.
As for databases, check out the above referenced technet post. They mention connecting to database endpoints by changing the Data source (ex. localhost/XE)