itmanager223
asked on
pervasive sql odbc link to ruby on rails
Hey guys i am wondering how is it possible to either sync pervasive sql to another database or directly connect it to ruby on rails?
My accounting system uses pervasive sql and at the moment i am trying to use an ODBC connection from the database to my ruby application.
I am currently working with this website:
http://odbc-rails.rubyforge.org/
Has anyone made this happen before because so far i am getting really confused with how to do the connection and get data from the remote database.
My accounting system uses pervasive sql and at the moment i am trying to use an ODBC connection from the database to my ruby application.
I am currently working with this website:
http://odbc-rails.rubyforge.org/
Has anyone made this happen before because so far i am getting really confused with how to do the connection and get data from the remote database.
ASKER
my database is running on windows server 2008 R2, so you mean i need to be running ruby and this whole setup on that same server first? I cannot be running it where my ruby app resides? (ubuntu 12.04 setup)
Sorry if I missled you...you need the driver and data source ON the coputer where the Ruby code is running not where the database is..
You configure the ODBC connection to the pervasive database (test it to make sure is working), then you create a data source and use that data source in your Ruby on rails code.
You configure the ODBC connection to the pervasive database (test it to make sure is working), then you create a data source and use that data source in your Ruby on rails code.
ASKER
ah ok, that makes sense now. Do you know of any pervasive drivers for mac or linux? So far i am just finding windows versions.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
no i don't plan to use mac but i was asking maybe if that was one of the ways i would have to go.
Let me look into your links and suggestions il get back to you.
Thanks
Let me look into your links and suggestions il get back to you.
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
For Ruby to connect/run queries against Pervasive that should work without any issues once you have connection to your DB tested.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You need to get that driver to match your OS and configure a ODBC data source to connect to your database then you will use that ODBC DSN name in your code to access the database from Ruby code.