You are not logged in.
Pages: 1
hello,
i am trying to connect to oracle direct driver OCI, and get the following message:
projet synDBEXplorer raise exception in the class TSQLDBOracleLib error OCI-21560
argument null, non valide ou Hors limite.
I am using instantclient 12.1 connect to Oracle server 11g
thanks for your help
eric g.
Last edited by ericgarcia (2015-07-08 00:07:26)
Offline
I am really sorry, but i did a mistake in the settings.
I used :TSQLDBOracleConnectionProperties.Create(//ip-address:port,'SID','USER','PWD'); and get the issue.
but when using
TSQLDBOracleConnectionProperties.Create('TNSDEF','SID','USER','PWD'); it works well.
thanks
eric
Offline
Nope. finally i get errors when trying to connect.
I'd like to connect directly to my database without any tnsname.
But even the tnsnames is defines i get errors.
for instance my tnsnames.ora is as below
lsp45=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 54.85.217.118)(PORT = 1521))
)
(CONNECT_DATA =
(SID = DFCASB)
)
)
I am tying the sample 16 (client server). when executing the clientexe, I get the following results:
- server = lsp45
- database= blank or DFCASB
20150712 20384047 ! EXC ESQLDBOracle {"Message":"TSQLDBOracleLib error: OCI-2
1560: argument 10 Null, non valide ou hors limites"} at 00705931 stack trace AP
I 005C0571 005C05A5 00007FFDC7299AB2 00007FFDC72982D3 00007FFDC729762D 00007FFDC
45A606C 00410526 004105A8 007083EB 006CA6E0 006C9AAA 006CF347 00739E63 006B3A88
006B3B55 00515AE5 005A7FC5 00742632 00007FFDC54A16AD 00007FFDC72AE954
server: my_ip_address
database: DFCASB
20150712 20424412 ! EXC ESQLDBOracle {"Message":"TSQLDBOracleLib error: ORA-1
2504: TNS : le processus d'Ǹcoute n'a pas obtenu de SERVICE_NAME dans CONNECT_D
ATA"} at 00705931 stack trace API 005C0571 005C05A5 00007FFDC7299AB2 00007FFDC7
2982D3 00007FFDC729762D 00007FFDC45A606C 00410526 004105A8 007083EB 006CA6E0 006
C9AAA 006CF347 00739E63 006B3A88 006B3B55 00515AE5 005A7FC5 00742632 00007FFDC54
A16AD 00007FFDC72AE954
server : my_ip_address:1521/DFCASB
database:NULL
20150712 20445940 ! EXC ESQLDBOracle {"Message":"TSQLDBOracleLib error: OCI-2
1560: argument 10 Null, non valide ou hors limites"} at 00705931 stack trace AP
I 005C0571 005C05A5 00007FFDC7299AB2 00007FFDC72982D3 00007FFDC729762D 00007FFDC
45A606C 00410526 004105A8 007083EB 006CA6E0 006C9AAA 006CF347 00739E63 006B3A88
006B3B55 00515AE5 005A7FC5 00742632 00007FFDC54A16AD 00007FFDC72AE954
thanks for your help
Offline
Pages: 1