Thanks Tim. I can make this a patch for the future, if it works for Prasanna.
Jeff > > > 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
