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

Resolved Connect to Sybase12 from Java

  1. New
  2. How-to
0
Votes
Undo
  1. Jordi Ferrer
    Jordi Ferrer
  2. PowerBuilder
  3. Tuesday, 12 November 2024 09:54 AM UTC

I know it has nothing to do with the current Powerbuilder, but since we come from where we come from we have a problem that we don't know how to solve.

We need to connect from Java through a jar connector to a database in Sybase12.

We are trying all the jars we have found: jodbc4.jar, sajdbc4.jar

But we are missing the correct connection string. We are trying jdbc:sybase:Tds:192.168.4.1:5000/dbName

Could you help us or direct us to someone who can help us with this?

Thank you in advance.

WMI thread issue
How can I make my PowerServer app listen for a ret...
Who is viewing this page
Jordi Ferrer
Responses (2)
Arnd Schmidt
Arnd Schmidt Accepted Answer Pending Moderation
  1. Tuesday, 12 November 2024 22:19 PM UTC
  2. PowerBuilder
  3. # 1

Hi,

normally you get an error including an error message.
If you want to connect via sajdbc4.jar to an SQL Anywhere Database you need to use jdbc:sqlanywhere.

Connecting to SQL Anywhere using JDBC:
https://community.sap.com/t5/technology-blogs-by-sap/connecting-to-sql-anywhere-using-jdbc/ba-p/13083493

what is your error message?!

Comment
There are no comments made yet.
David Peace (Powersoft)
David Peace (Powersoft) Accepted Answer Pending Moderation
  1. Tuesday, 12 November 2024 10:51 AM UTC
  2. PowerBuilder
  3. # 2

Hi

I think you need to be contacting Sybase support for this specific question. I did a quick search and found this which might help:

https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sqlanywhere.12.0.1/dbprogramming/connecting-establishing-jdbc.html

Good luck

David

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 12 November 2024 15:41 PM UTC
Hi David;

He will need a lot of luck as Sybase no longer exists.

@Jordi - You can try SAP for this support as they bought out Sybase out in the 2014 time frame.

Regards .. Chris
  1. Helpful
David Peace (Powersoft)
  1. David Peace (Powersoft)
  2. Tuesday, 12 November 2024 15:43 PM UTC
Ha Ha, yes Chris.

I meant SAP, but you need a lot of luck with them too....
  1. Helpful 1
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.