I need some assistance configuring Oracle Express on my system. If someone has some experience setting it up on Windows and then connecting a Xojo apps (Mac/Windows) please let me know. I’m kind of lost and the moment.
I am willing to barter some consulting/training time…
I have it running since about a year. As far as i can remember it was a straight forward installation.
What is your problem, maybe my memory isn’t totally gone.
When I tried it last year, installing Oracle Express was easy enough. But figuring out the proper connection string proved to be a challenge. What ended up working for me is in the Example on the OracleDatabase page in the LR:
I used to use Oracle a lot 10-15 years ago, but most of that knowledge has left me. Frankly, I would think that with proper TNSNAMES.ORA configuration, the Xojo connection string would just be the DB instance name, but I could not get that working.
@Paul Lefebvre
In your explanation you connect with this string:
db.DatabaseName = “(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.1.14)(PORT=1521))(CONNECT_DATA=(SID=XE)))”
This works too:
[code]Dim db As OracleDatabase
db = New OracleDatabase
db.host=“127.0.0.1:1521/XE” //= IP-number of the server + : + Portnumber + / + Databasename