How can I connect to pervasive database in ruby on rails?

I have installed Pervasive V10 server x86 and odbc gem. Whenever I make a request to fetch data from the database, I get the following error "IM003 (160) Specified driver could not be loaded due to system error 1114: A dynamic link library (DLL) initialization routine failed. (Pervasive ODBC Client Interface, C:\Program Files (x86)\Pervasive Software\PSQL\bin\w3odbcci.dll)"

I tried installing Pervasive v10 x64 but still it did not work

Solution

You must be running on 32 bit ruby when using x86 pervasive, I used to scratch my head a lot over this exact issue

Ruby on Rails: getting the max value from a DB column
How to use x-www-form-urlencoded in rails
Can Anemone crawl html files stored locally on my hard drive?
Convert a Ruby on Rails app from sqlite to MySQL?
Installing mysql2 gem for Ruby on Rails with Mac OSX 10.6
Dry-validation how to allow array of hashes with nil value
How can I parse these hashes turned string, from my Ruby on Rails API so that it's accessible as an object in Javascript?
Rails 4.2.6 - Devise 4.2.2 - Default Auth
Generate Rails models with mandatory/required fields (i.e not null) from command line
libsndfile.so.1: cannot open shared object file: No such file or directory
Azure Mac hosted agent: installing gem install, downloading old version gems
Using Rails, how can I set my primary key to not be an integer-typed column?
Strange bundle update issue: disappearing net-pop (0.1.2) dependency
How to create a Ruby DateTime from existing Time.zone for Rails?
Why use /app/lib instead of /lib in Rails?
Set raw value with Rails.cache.write
In rails controllers, how to prevent double submit (when user double-clic submit button or hit enter twice)?
How to use Rails and Hotwire Turbo Streaming to Stream a Long Page?
How to disable a form submit button "a là Ruby on Rails Way"?
How do I correctly render images via Hotwire Turbo streams?
How to get url of Active Storage image
input type=number not possible to insert negative numbers on mobile phone
mini_racer gem 0.8.0 fails bundle install with Ruby 3.1.x
Running bundle install on my Ruby on Rails application is generating errors on sqlite3 and nio4r
How to deploy Rails sqlite3 database with Capistrano?
Rails : uninitialized constant error on Active Record destroy
Accessing the app name from inside a rails template when generating rails app
How to serve an image from S3?
Rails 7 with Import Maps and CSS Bundling: Assets Not Served from /builds Directory
Invalid scope error in Doorkeeper assertion flow