Connect to Oracle
Am trying to connect to an oracle database using the following:
conn: open oracle://db-server-ip/service
...but am getting an INVALID PORT SPEC. I have all the requisite oracle client libs installed (and can connect to the db via sqlplus), but cannot use Rebol.
Any idea on how i can connect?
Rebol version: Rebol View 2.7.8
OS: Windows 7 professional
posted by: ecollage 10-Feb-2011/5:23:42-8:00
If you are using free version of Rebol View 2.7.8 then you can only use odbc scheme. Oracle & mysql supported only in pro versions.
Try creating a odbc dsn and connect using it which will work on View 2.7.8
conn: open odbc://odbc-data-source-to-oracle
db: first conn
insert db "select 3 * 5"
print copy db
posted by: Endo 10-Feb-2011/11:59:56-8:00
Thanks Endo. Silly of me to assume that everything was available in the new release! Connected via ODBC and it works...
Here's hoping Carl will release oracle:// and mysql:// with newer releases
posted by: ecollage 11-Feb-2011/4:31:51-8:00