Alexander,Thanks for the tip. We have an enterprise license. We run it on Sun servers, but my script is on a Linux box. If installing Personal Oracle is easy, then I'll do it. But to interface to the remote Oracle db, I'll still need ODBC, right? The script I'm writing is for a very simple db. I'm writing a utility that uses NSAPping to get availability and latency for our ATM network. Two small tables. I could use a flat file for output, but I'd like to automate Crystal Reports to build the monthly availability reports, and Crystal uses a db interface, so at db is the best solution ... besides, Oracle will do all the data maintenance, rollups, etc. Craig
> Date: Fri, 13 Jul 2007 21:29:50 +0200> From: [EMAIL PROTECTED]> To: [EMAIL > PROTECTED]> CC: [email protected]> Subject: Re: Trouble Installing DBD::ODBC > with postgresql> > Oh, I almost forgot: If your company has a licensed Oracle > server, you > can get "Personal Oracle" for free (as far as I know, perhaps > you can > even get it for free without a licensed server), so you can develop > and > run productive on the same DB engine. Don't get me wrong, PostgreSQL is > > a cool DB, but developing for more than one DB can be really painful.> > > Alexander> > On 13.07.2007 21:11, Craig Metzer wrote:> > Yes Alexander,> > > > > I'm only using the local pgsql server for the script development. After I > get my Perl script worked out, I'm going to move the db to our enterprise > Oracle server. I'll need ODBC for that.> > > > Craig> >> >> >> > > >> Date: > Fri, 13 Jul 2007 20:57:03 +0200> From: [EMAIL PROTECTED]> To: [EMAIL > PROTECTED]> CC: [email protected]> Subject: Re: Trouble Installing DBD::ODBC > with postgresql> > Is there a special reason why you do not use DBD::Pg? It > should be > faster because it has less overhead and it supports Unicode > better than > DBD::ODBC, should you need it. DBD::ODBC has seen no update > since about > three years, while the current DBD::Pg is just one year old.> > > Alexander> > On 13.07.2007 00:11, Craig Metzer wrote:> > I'm having trouble > installing DBD::ODBC 1.13 on a system with postgresql. It appears it's > because it can't find the sql.h, sqlext.h, etc. headers. I installed the > developer and library packages that were supposed to contain these headers. > Could someone please tell me what I'm doing wrong or where to find the > headers?> > > > TIA,> > Craig> > > > > > -- > Alexander Foken> mailto:[EMAIL > PROTECTED] http://www.foken.de/alexander/> > >> > > > _________________________________________________________________> > Don't > get caught with egg on your face. Play Chicktionary! > > > http://club.live.com/chicktionary.aspx?icid=chick_wlmailtextlink> > > > > -- > > Alexander Foken> mailto:[EMAIL PROTECTED] http://www.foken.de/alexander/> > _________________________________________________________________ PC Magazine’s 2007 editors’ choice for best web mail—award-winning Windows Live Hotmail. http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HMWL_mini_pcmag_0707
