Hi Gurus, We're beatin' our heads against the wall trying to figure this thing out and searching the web points to solutions in IQ - but not ASE. Therein lies the problem.

In Ruby this syntax:

dbh = DBI.connect("DBI:SQLAnywhere:DBN=xxx;HOST=host:port", user, pwd)

works great connecting to Sybase IQ - but when host:port is Sybase ASE it fails to connect.

Would anyone know if SQLAnywhere is the right adaptor for ASE and if so how might the connect string differ?

Thanks

asked 03 Aug '11, 19:20

spragues's gravatar image

spragues
16112
accept rate: 0%

edited 04 Aug '11, 15:36

Volker%20Barth's gravatar image

Volker Barth
40.0k361549819


Unfortunately, the SQL Anywhere adapter is not capable of connecting to Sybase ASE databases. The SQL Anywhere adapter is capable of connecting to SQL Anywhere and IQ, but it not yet supported by Sybase ASE. I am not aware of any Ruby-DBI support for Sybase ASE.

I am not sure of the constraints of your project, but one thing you could consider is using JRuby, and using ASE's JDBC driver to make the connection.

permanent link

answered 03 Aug '11, 20:49

Eric%20Farrar's gravatar image

Eric Farrar
92621320
accept rate: 30%

Thanks Eric for you response. Good to know at least it might not be me just being stupid with ASE. In the time after i posted a colleague of mine was able to finagle a Ruby-ODBC connection to work which as you suggested - ala JDBC - might be a workaround. So we'll take this as the solution until or if a DBI solution emerges.

Thanks again.

Steve

(03 Aug '11, 23:06) spragues
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×53
×14

question asked: 03 Aug '11, 19:20

question was seen: 3,776 times

last updated: 07 Feb '13, 10:44