Page 1 of 1

dotConnect not working with oracle xe

Posted: Mon 24 Sep 2018 17:37
by josue.agnese
Hi!

I was using dotConnect version 9.6.584 oracle xe in my integrated tests (container docker: wnameless / docker-oracle-xe-11g) and after upgrading to new version 9.6.597 I can no longer connect to the database

Throwed error
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

My Connection String:
User ID=dapper; Password=dapper; Direct=true; Data Source=127.0.0.1/dapper; Service Name=XE; Port=1521; license key= ...

PS: After downgrading to the old version 9.6.584, my integrated tests worked again.

Re: dotConnect not working with oracle xe

Posted: Mon 01 Oct 2018 11:25
by Pinturiccio
We have reproduced the issue, but we do not consider this behavior as a bug. We installed the following container: https://hub.docker.com/r/wnameless/oracle-xe-11g/
We have reproduced the issue with the following connection string:

Code: Select all

"host=192.168.10.181/dapper;port=49161;sid=xe;direct=true;uid=system;pwd=oracle"
We can connect with dotConnect for Oracle 9.6.584 and get the ORA-12514 error with dotConnect for Oracle 9.6.597.

However, if we delete "/dapper" from the connection string, we can connect with the latest dotConnect for Oracle version and with the following connection string:

Code: Select all

"host=192.168.10.181;port=49161;sid=xe;direct=true;uid=system;pwd=oracle"
Please delete "/dapper" from your connection string and post here about the results.

Re: dotConnect not working with oracle xe

Posted: Wed 03 Oct 2018 14:22
by josue.agnese
Thank you!

After this change in connection string worked!