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