I'm trying to connect to an oracle database using the odbc command. The database is remote and requires authentication, which means that I need to use the connectionstr() option. However, the odbc documentation doesn't actually detail which arguments can be used in the connectionstr. From examples online, I filled in the following, but I keep on getting an invalid username and password error. I am definitely putting in the correct username and password.
odbc load, table("some_table") conn("DRIVER={Oracle in OraDB12Home1};SERVER=[IP address];DATABASE=;UID=;PWD=;")
When I connect to this database using SQL developer, this is the information required:
hostname: [ip address]
port:
SID:
username:
password:
I've tried the following, and a bunch of other variations, but I get the same error:
odbc load, table("Students") conn("DRIVER={Oracle in OraDB12Home1};HOSTNAME=;SID=;PORT=;UID=;PWD=;")
How can I specify the connectionstr for this database?
odbc load, table("some_table") conn("DRIVER={Oracle in OraDB12Home1};SERVER=[IP address];DATABASE=;UID=;PWD=;")
When I connect to this database using SQL developer, this is the information required:
hostname: [ip address]
port:
SID:
username:
password:
I've tried the following, and a bunch of other variations, but I get the same error:
odbc load, table("Students") conn("DRIVER={Oracle in OraDB12Home1};HOSTNAME=;SID=;PORT=;UID=;PWD=;")
How can I specify the connectionstr for this database?
