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 > > > > > >
