good chemistry is complicated, and a little bit messy -LW |
|
PerlMonks |
Running a script on Windows to access a postgres database on Linuxby TASdvlper (Monk) |
on Mar 30, 2006 at 19:26 UTC ( [id://540253]=perlquestion: print w/replies, xml ) | Need Help?? |
TASdvlper has asked for the wisdom of the Perl Monks concerning the following question:
All,
I was hoping this would be a easy job, but I'm a bit stuck now. Let me give you a little background on what I'm trying to accomplish. Over the past few years I've written a web-based tool used for tracking test cases and results, it runs directly on Linux and there's a postgres db in the back end where everything is stored. I wrote a module specific for database transactions (queries, inserts, updates, etc). Anyway, we have a automation team that are writing scripts that mostly run on Windows, I was hoping I could give them my Database module, and they would integrate it into their scripts and then they would have direct access to the database. Currently, they are writing their results out to a flat file, I thought if they could write to our database directly, it would be must more efficient and we would get results from the scripts in "real-time". So, I write a little script on Windows, and included my db module (which I slightly modified). I installed ActivePerl 5.8 and installed the DBI module (using ppm). But now it's complaining about a DBD::pg.pm module (see below). I've looked in ppm, and searched on DBD and got the following: So, at this point I'm not sure what else I can do ??? I don't see a DBD::pg.pm module. I did try to load the PgPP driver, but that didn't help. If anybody has any ideas I would greatly appreciate it. UPDATE: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ok, I've installed the DBD::PgPP driver and I'm trying to run my script, and I'm getting the following error: DBD::PgPP::db selectall_arrayref failed: Unknown message type: ' at DataBaseActions.pm line 124. I know my code is ok because it's the same code that runs on Linux. Any thoughts ?
Back to
Seekers of Perl Wisdom
|
|