Connecting to a Sybase ASA database using Ruby

I have Sybase ASA (10) installed locally on my Windows XP Pro machine.

I have followed the instructions on http://wiki.rubyonrails.com/rails/pages/SybaseASA.

My database.yml is as follows:
development:
  adapter: sybaseanywhere
  username: dba
  password: sql
  host: localhost
  mode: ADO
  dsn: depot_development

But when i try to create a new scaffold i get the following error:
Open
    OLE error code:800A0E7A in ADODB.Connection
      Provider cannot be found. It may not be properly installed.
    HRESULT error code:0x80020009
      Exception occurred.

Has anyone managed to have a Sybase ASA db running against Ruby?

Thanks,  Mike
altlogicAsked:
Who is Participating?
 
fridomCEO/ProgrammerCommented:
You probably does not have modified the ODBC setup that this database can be connected to via ODBC.
Regards
Friedrich
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.