Hello
I'm trying to use the SQL plugin to connect to an Oracle server. I'm
using the Oracle Connect sample.
Always get an SQLErrorExceptionMBS in con.Connect (SQLConnectionMBS).
I've tried the 10 and 11 Instant Client, both 32 and 64 bits.
I've set the kOptionLibraryOracle to the libclntsh.dylib, and even the
instantclient directory (even i know i must use the lib, just to try)
I've used as "server" these forms:
* name (as defined in tnsnames.ora
*
"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=machine)(PORT=1521))(CONNECT_DATA=(SID=DB11G)))"
(also SID=DB11G.WORLD)
* machine:1521/DB11G (also DB11G.WORLD)
I'm passing the kOptionLibraryOracle this way:
con.SetFileOption con.kOptionLibraryOracle,
getfolderitem("/Applications/instantclient_10_2/libclntsh.dylib.10.1",FolderItem.PathTypeShell)
(also with 11_2)
I've also tried creating a FolderItem before and passing it, also tried
the 3 form of Paths (Absolute, Shell and URL), and with passing path as
an string, as special folder, and as Volume(0).child.....
I tried the same with PostgreSQL Connect sample and got it at first, so
i think i understand how this works.
I've spent several hours with this and i'm unable to connect. With the
RS plugin i can connect without problems with the
"(DESCRIPTION=(ADDRESS....." server address.
I've also added these Environment Variables as i do in the RS Plugin
connection
System.EnvironmentVariable("DYLD_LIBRARY_PATH")="/Applications/instantclient_10_2"
System.EnvironmentVariable("ORACLE_HOME")=System.EnvironmentVariable("DYLD_LIBRARY_PATH")
System.EnvironmentVariable("TNS_ADMIN")="/Applications/instantclient_10_2/network/admin"
Can anyone tell me what i'm doing bad or what is the "trick"?. I think
the problem is setting the kOptionLibraryOracle or the server address,
but don't know what more to try
Thanks!
Bes,
_______________________________________________
Mbsplugins_monkeybreadsoftware.info mailing list
[email protected]
https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info
