On Mon, Sep 23, 2002 at 02:56:55PM -0400, Jeff Urlwin wrote: > Prasanna, > > 1) please always copy dbi-users. > 2) in Makefile, (not Makefile.PL) change: > # --- MakeMaker const_cccmd section: > CCCMD = $(CC) -c $(INC) $(CCFLAGS) $(OPTIMIZE) \ > $(PERLTYPE) $(MPOLLUTE) $(DEFINE_VERSION) \ > $(XS_DEFINE_VERSION) > > to: > # --- MakeMaker const_cccmd section: > CCCMD = $(CC) -c $(DEFINE) $(INC) $(CCFLAGS) $(OPTIMIZE) \ > $(PERLTYPE) $(MPOLLUTE) $(DEFINE_VERSION) \ > $(XS_DEFINE_VERSION) > > > This will make sure unixODBC comes first. Every time you run Makefile.PL, > you will have to perform this edit. I do not believe that changing > Makefile.PL in any way will help this.
Makefile.PL can edit just about anything that goes into the Makefile. See the const_cccmd() sub in the 'package MY;' in DBI's Makefile.PL Tim. > Regards, > > Jeff > > > -----Original Message----- > > From: Janarthanan, Prasanna [mailto:[EMAIL PROTECTED]] > > Sent: Monday, September 23, 2002 12:30 PM > > To: 'Jeff Urlwin' > > Subject: RE: Problem installing DBD:ODBC(UnixODBC). > > > > > > > > >You can edit the makefile directly to add a -I/your/path/to/unixODBC (in > > >fact, that may be a good candidate to patch Makefile.PL directly, to add > > >that "automatically", but it's certainly easier to patch that first. > > > > Which file i should add this. In MakeFile.PL ?? The 'MakeFile' > > generated after MakeFile.PL Has the location correctly as > > -I/u/janarthp/ODBC/unixODBC ( correct path to the unixODBC) > > Can u please have a look at my files? > > > > > > > You > > >will probably have to add your path to unixODBC libraries to your > > >LD_LIBRARY_PATH and to the linker path, too... > > > > This is already done. > > > > Jeff > > > > > -----Original Message----- > > > From: Janarthanan, Prasanna [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, September 23, 2002 11:20 AM > > > To: 'Jeff Urlwin' > > > Subject: RE: Problem installing DBD:ODBC(UnixODBC). > > > > > > > > > I understood. Is there anyother way to get rid of installing in > > > /usr/local/ > > > as iam not having permission over there. > > > Yes, there is a sqlext.h at my /usr/local/include. Can't i make > > it to get > > > the sqlext.h at $UNIXODBC/include? > > > > > > thanks > > > Prassana > > > > > > > > > -----Original Message----- > > > From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, September 23, 2002 7:58 PM > > > To: Janarthanan, Prasanna; 'Jeff Urlwin'; [EMAIL PROTECTED] > > > Subject: RE: Problem installing DBD:ODBC(UnixODBC). > > > > > > > > > Prasanna, > > > > > > I'm not sure what's really happening other than there must be > > > some sqlext.h > > > in your /usr/include or /usr/local/include *before* it gets to sqlext.h > > > that's defined by unixODBC. It looks as if it's not looking in > > > ODBCHOME...I > > > think, if you haven't, try *installing* unixODBC into > > > /usr/local/include and > > > that should do it. > > > > > > I clearly have the definition of SQL_API_ODBC3_ALL_FUNCTIONS_SIZE in my > > > sqlext.h and I can make and test this under Linux with no > > problems, but I > > > have installed unixODBC into /usr/local... > > > > > > Regards, > > > > > > Jeff > > > > > > > > > > > Here is the complete perl MakeFile and make. > > > > > > > > Iam able to connect to the database using isql. > > > > ------- > > > > > > > > janarthp@sys1:/u/janarthp/DBD> perl Makefile.PL -o > > > > /u/janarthp/ODBC/unixODBC > > > > > > > > Configuring DBD::ODBC ... > > > > > > > > >>> Remember to actually *READ* the README file! > > > > And re-read it if you have any problems. > > > > > > > > Using DBI 1.21 installed in > > > > /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI > > > > Using ODBC in /u/janarthp/ODBC/unixODBC > > > > janarthp@sys1:/u/janarthp/DBD> perl Makefile.PL -o > > > > /u/janarthp/ODBC/unixODBC > > > > > > > > Configuring DBD::ODBC ... > > > > > > > > >>> Remember to actually *READ* the README file! > > > > And re-read it if you have any problems. > > > > > > > > Using DBI 1.21 installed in > > > > /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI > > > > Using ODBC in /u/janarthp/ODBC/unixODBC > > > > > > > > Umm, this looks like a unixodbc type of driver manager. > > > > We expect to find the sql.h, sqlext.h and (which were > > > > supplied with unixODBC) in $ODBCHOME/include directory alongside > > > > the /u/janarthp/ODBC/unixODBC/lib/libodbc.so library. in $ODBCHOME/lib > > > > > > > > > > > > Using DBI 1.21 installed in > > > > /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI > > > > Writing Makefile for DBD::ODBC > > > > > > > > The DBD::ODBC tests will use these values for the database connection: > > > > DBI_DSN=dbi:ODBC:sql_lite e.g. dbi:ODBC:demo > > > > DBI_USER=sa > > > > DBI_PASS= > > > > Warning: not all required environment variables are set. > > > > > > > > janarthp@sys1:/u/janarthp/DBD> make > > > > cc -c -I. -I/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI > > > > -I/usr/local/include -I/usr/include -I/usr/local/gnu/include > > > > -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"0.45_17\" > > > > -DXS_VERSION=\"0.45_17\" -KPIC > > > > -I/usr/local/lib/perl5/5.6.1/sun4-solaris/CORE > > > > -I/u/janarthp/ODBC/unixODBC/include ODBC.c > > > > "ODBC.xs", line 172: undefined symbol: > > SQL_API_ODBC3_ALL_FUNCTIONS_SIZE > > > > "ODBC.xs", line 185: undefined symbol: SQL_API_ODBC3_ALL_FUNCTIONS > > > > "ODBC.xs", line 185: integral constant expression expected > > > > "ODBC.xs", line 232: warning: argument #1 is incompatible with > > > prototype: > > > > prototype: pointer to char : > > > "/usr/include/iso/string_iso.h", line > > > > 66 > > > > argument : pointer to unsigned char > > > > "ODBC.xs", line 252: warning: argument #1 is incompatible with > > > prototype: > > > > prototype: pointer to const char : > > > > "/usr/local/lib/perl5/5.6.1/sun4-solaris/CORE/proto.h", line 550 > > > > argument : pointer to unsigned char > > > > cc: acomp failed for ODBC.c > > > > *** Error code 2 > > > > make: Fatal error: Command failed for target `ODBC.o' > > > > janarthp@sys1:/u/janarthp/DBD> > > > > ------ > > > > > > > > Also i have all setenv correctly. > > > > ODBCINI, LD_LIBRARY_PATH > > > > > > > > > > > > help! > > > > > > > > thanks > > > > Prassana > > > > > > > > > > > > -----Original Message----- > > > > From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] > > > > Sent: Monday, September 23, 2002 6:55 PM > > > > To: Janarthanan, Prasanna; [EMAIL PROTECTED]; > > [EMAIL PROTECTED] > > > > Subject: RE: Problem installing DBD:ODBC(UnixODBC). > > > > > > > > > > > > Please post the output of makeifle.pl and all of make. I > > > believe it's not > > > > properly picking up the unixODBC headers. > > > > > > > > regards, > > > > > > > > Jeff > > > > > > > > > -----Original Message----- > > > > > From: Janarthanan, Prasanna [mailto:[EMAIL PROTECTED]] > > > > > Sent: Saturday, September 21, 2002 5:09 AM > > > > > To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' > > > > > Subject: Problem installing DBD:ODBC(UnixODBC). > > > > > > > > > > > > > > > hi, > > > > > > > > > > I now installed the unixODBC Driver manager and tested with > > isql. Its > > > > > working fine. Still get problem when running 'make' after > > > makeFile.PL of > > > > > DBD:ODBC. > > > > > > > > > > A piece of that error: > > > > > > > > > > "dbdimp.c", line 1232: warning: improper pointer/integer > > > > > combination: arg #1 > > > > > "dbdimp.c", line 1244: warning: improper pointer/integer > > > > > combination: arg #1 > > > > > "dbdimp.c", line 1259: undefined symbol: SQL_AM_STATEMENT > > > > > "dbdimp.c", line 1261: undefined symbol: SQL_ATTR_ASYNC_ENABLE > > > > > "dbdimp.c", line 1264: undefined symbol: SQL_IS_UINTEGER > > > > > "dbdimp.c", line 1310: undefined symbol: SQL_TYPE_DATE > > > > > "dbdimp.c", line 1310: integral constant expression expected > > > > > "dbdimp.c", line 1310: duplicate case in switch: 1 > > > > > "dbdimp.c", line 1312: undefined symbol: SQL_TYPE_TIME > > > > > "dbdimp.c", line 1312: integral constant expression expected > > > > > "dbdimp.c", line 1312: duplicate case in switch: 1 > > > > > "dbdimp.c", line 1314: undefined symbol: SQL_TYPE_TIMESTAMP > > > > > "dbdimp.c", line 1314: integral constant expression expected > > > > > "dbdimp.c", line 1314: duplicate case in switch: 1 > > > > > "dbdimp.c", line 1345: undefined symbol: SQL_C_TYPE_DATE > > > > > "dbdimp.c", line 1345: integral constant expression expected > > > > > "dbdimp.c", line 1345: duplicate case in switch: 1 > > > > > "dbdimp.c", line 1346: undefined symbol: SQL_C_TYPE_TIME > > > > > "dbdimp.c", line 1346: integral constant expression expected > > > > > "dbdimp.c", line 1346: duplicate case in switch: 1 > > > > > "dbdimp.c", line 1347: undefined symbol: SQL_C_TYPE_TIMESTAMP > > > > > "dbdimp.c", line 1347: integral constant expression expected > > > > > "dbdimp.c", line 1347: duplicate case in switch: 1 > > > > > > > > > > i installed > > > > > janarthp@sys1:/u/janarthp/ODBC/unixODBC/bin> odbcinst --version > > > > > unixODBC 2.2.3 > > > > > > > > > > > > > > > support! > > > > > > > > > > thanks > > > > > Prassana > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
