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.
dotConnect not working with oracle xe
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: dotConnect not working with oracle xe
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:
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:
Please delete "/dapper" from your connection string and post here about the results.
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"
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"
-
- Posts: 9
- Joined: Tue 21 Aug 2018 13:56
Re: dotConnect not working with oracle xe
Thank you!
After this change in connection string worked!
After this change in connection string worked!