• You are here:  
  • Home
  • Q&A
  • Q&A
  • SnapDevelop
  • Error when connecting SnapDevelop to Oracle database that works in PB

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (4)

Resolved Error when connecting SnapDevelop to Oracle database that works in PB

  1. Issue
0
Votes
Undo
  1. Alex Hernandez
    Alex Hernandez
  2. SnapDevelop
  3. Thursday, 20 May 2021 09:33 AM UTC

Hello,

I'm trying to create a database connection in SnapDevelop 2019 R3 (I tried in R2 also) to an Oracle database, but I get the error "ORA-12537: Network Session: End of file". It's strange because I can connect to this database in Powerbuilder without any trouble. This database is in Oracle's cloud, and the service name is a bit long (38 characters).

I haven't found how to solve this issue so I'm stuck here and cannot continue the customer's project. Can anybody help me please?

Kind regards.

  1. Oracle
  2. PowerBuilder (Appeon)
  3. SnapDevelop
ASP.NET Core Web API targeting .NET Core 5.0
Issue with SnapDevelop tutorial
Responses (4)
Francisco Martinez @Appeon
Francisco Martinez @Appeon Accepted Answer Pending Moderation
  1. Thursday, 17 June 2021 13:22 PM UTC
  2. SnapDevelop
  3. # 1

Hi Alex,

Please check it this ticket addresses the same issue you're describing

Regards,
Francisco

Comment
There are no comments made yet.
Francisco Martinez @Appeon
Francisco Martinez @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 2 June 2021 19:05 PM UTC
  2. SnapDevelop
  3. # 2

Hi Alex!

We're currently looking into this issue. What's your Oracle version?

Regards,
Francisco

Comment
Alex Hernandez
  1. Alex Hernandez
  2. Thursday, 3 June 2021 07:44 AM UTC
Hi Francisco!



It's an Oracle 12.2.0.1.0 - 64bit. I'm trying that the DBA team creates a new an shorter service name but I'm still waiting for it.



Thanks!
  1. Helpful
Francisco Martinez @Appeon
  1. Francisco Martinez @Appeon
  2. Thursday, 3 June 2021 13:07 PM UTC
Alex, someone suggested that the issue might be the service name having periods in it. Could you maybe try a service name without periods?



Regards,

Francisco
  1. Helpful
Alex Hernandez
  1. Alex Hernandez
  2. Thursday, 17 June 2021 12:07 PM UTC
Hi,



Finally it seems that is not possible to create a shorter service name without periods in Oracle Cloud databases. I'll open a support ticket then to see if something can be done.



Thanks!
  1. Helpful
There are no comments made yet.
Alex Hernandez
Alex Hernandez Accepted Answer Pending Moderation
  1. Tuesday, 25 May 2021 07:45 AM UTC
  2. SnapDevelop
  3. # 3

Hi Francisco,

Thanks for your reply. That list of workarounds are for the case in which the Oracle TNS names path is too long but, if I'm not wrong, SnapDevelop does not use TNSNames does it? I mean, Powerbuilder do use TNSNames for the connection and in my case it works, but when I try to connect SnapDevelop to the same database it fails.

This is the connection dialog in SnapDevelop where I have the error:

It's the same information that can be found in tnsnames.ora:

This configuration works in Powerbuilder.

Kind regards.

 

Comment
Francisco Martinez @Appeon
  1. Francisco Martinez @Appeon
  2. Thursday, 27 May 2021 13:11 PM UTC
Try shortening the service name, maybe that will help
  1. Helpful
Logan Liu @Appeon
  1. Logan Liu @Appeon
  2. Tuesday, 1 June 2021 08:54 AM UTC
Hi Alex,

TNSNames hasn't been supported in SnapDevelop.

If this the error "ORA-12537: Network Session: End of file" is still existing, please report your issue via our support ticketing system to ensure it is being properly received by our tech support and tracked at: https://www.appeon.com/standardsupport/.

Regards, Logan
  1. Helpful
There are no comments made yet.
Francisco Martinez @Appeon
Francisco Martinez @Appeon Accepted Answer Pending Moderation
  1. Thursday, 20 May 2021 17:29 PM UTC
  2. SnapDevelop
  3. # 4

Hi Alex,

According to this page, it certainly seems that the connection string might be a little bit too long. The same page suggests, among other things:

  1. Install the exe in a shorter named directory.
  2. Modify the TNS Names entry so that it is shorter.
  3. Replace domain names with IP Addresses if that shortens and vice versa.

Please let me know if this helps

Regards,
Francisco

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.