Re: RE: RE: RE: tourble migrating from linux/Apache/postgresql/perl to win2000/IIS/postgresql/perl - Mailing list pgsql-cygwin

From s0lao@netscape.net (S. L.)
Subject Re: RE: RE: RE: tourble migrating from linux/Apache/postgresql/perl to win2000/IIS/postgresql/perl
Date
Msg-id 2CE3EF5D.239DE283.00013D13@netscape.net
Whole thread Raw
In response to RE: RE: RE: tourble migrating from linux/Apache/postgres ql/perl to win2000/IIS/postgresql/perl  (Rishi Sharma <rsharma@Bigstep.net>)
List pgsql-cygwin
Rishi Sharma <rsharma@Bigstep.net> wrote:
>
> Just wondering if I need to install ODBC?
>
> CGI will not need ODBC correct?
>

To quote from README in src/interfaces/perl5:

"This has been done by using the Perl5 application programming interface for C extensions which calls the Postgres
programmer'sinterface LIBPQ." 

It's nothing mentioned about ODBC, and it shouldn't, as ODBC is also based on LIBPQ.

The bottom line is you don't need ODBC. You need ODBC only for ODBC calls in your applications or for ODBC based
applications.

A few hints about your CGI problem:

1. Are you sure you use perl distribution included with cygwin ? (you posted a message where your @INC pointed to some
d:/Perl/[...]paths) 

2. If you use the ActivePerl distribution I'm quite curious how's that my Pg.dll worked in your perl -w.

3. If your perl is located in d:/Perl/bin/perl.exe, then so should the #!  line of your scripts, i.e.
#!d:/Perl/bin/perl.exe.

4. If you have 2 versions of perl installed (the ActivePerl and the cygwin one), you should be careful that your
scriptsget a sane environment for the one they use (as it happened with your PostgreSQL building attempts). 

5. I'd recommend that your scripts use only the cygwin version of perl -- with a proper MIME configured (i.e. for .pl
files,the server should execute d:/cygwin/usr/local/bin/perl.exe rather than d:/Perl/bin/perl); at least those scripts
thatuse the Pg driver. 


                             SLao
__________________________________________________________________
Get your own FREE, personal Netscape Webmail account today at http://webmail.netscape.com/

pgsql-cygwin by date:

Previous
From: Rishi Sharma
Date:
Subject: Why cant I load Pg module from my perl CGI under IIS?
Next
From: Rishi Sharma
Date:
Subject: RE: RE: RE: RE: tourble migrating from linux/Apache/post gresql/perl to win2000/IIS/postgresql/perl