Tell me the way to connect to Oracle

Please say ‘Yes’ who ever connect to oracle successfull?Maybe xojo like this mode to rise coder’s skill,i find it very hard to do.in fact,when xojo setup over,it should give user a list ,detailed told user what need install in your pc,it can do this ,but Its dos not.

Mac or Windows ?

https://forum.xojo.com/conversations/databases?search=oracle

ORACLE for MAC

OCI

1.) Install Oracle Instant Client 10.2 32bit (wherever you want)

2.) Duplicate libclntsh.dylib.10.1 and name it libclntsh.dylib

3.) Duplicate libocci.dylib.10.1 and name it libocci.dylib

4.) The folder looks like this

http://www.stefan-cyrus.de/Downloads/Oracle.png

5.) Try to connect with this program (used to demonstrate a bug , feedback 42956)

http://www.stefan-cyrus.de/Downloads/42956-CY.xojo_binary_project

6.) Set the Variables to your Oracle Folder (for example)

System.EnvironmentVariable("ORACLE_HOME")       = "/Library/ORACLE_10" // CY
System.EnvironmentVariable("DYLD_LIBRARY_PATH") = "/Library/ORACLE_10" // CY
System.EnvironmentVariable("TNS_ADMIN")         = "/Library/ORACLE_10" // CY

ODBC

1.) Install actualtech Oracle ODBC

2.) Define a DSN (for example)

http://www.stefan-cyrus.de/Downloads/ODBC.png

Xojo Code to connect:

dim ODBC_DB as ODBCDatabase
dim DataSource as string
dim result as boolean
//**
DataSource = “DSN=” + “DWHCY” + “;”
DataSource = DataSource + “UID=” + “DWHCY” + “;”
DataSource = DataSource + “PWD=” + “cyrus” + “;”
DataSource = DataSource + “USER_TYPE=” + “0” + “;”
DataSource = DataSource + “SERVER=” + “” + “;”
DataSource = DataSource + “PORT=” + “1521” + “;”
DataSource = DataSource + “DATABASE=” + “” + “;”
DataSource = DataSource + “TYPE=” + “” + “;”
//**
ODBC_DB = new ODBCDatabase
ODBC_DB.DataSource = DataSource
result = ODBC_DB.Connect

Stefan Cyrus

Connect via MBS SQL Plugin is also possible.

Windows desktop