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?
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.
answered 03 Aug '11, 20:49