Interbase users, please help me! I know there are some Interbase users out there and I'm hoping to get in contact with some because I have a problem I notice someone else had just 2 weeks ago and follow-up wasn't posted to this list..
I use Solaris 8, but this might not be OS-dependent, so I left it out of the subject (hoping for a response, here, Interbase users). This email is broken into three sections here: The first is a short description of the three dbi-users emails that relate to my problem and another fellow's problem in late April. The second is a short response to the only follow-up to either his or my email. The third is the documentation of my problem as I sent it to dbi-users yesterday under a different subject. ############## Section 1) Both dbi-users emails (A previous one from 4/22 and mine from 5/8) are at http:[EMAIL PROTECTED]/msg11363.html and http:[EMAIL PROTECTED]/msg11054.html. A short reply asking whether or not the client libraries are installed on the system was his only response (http:[EMAIL PROTECTED]/msg11058.html) and an email to the author of the 4/22 message has not been returned. ############## Section 2) I would like to add that I did not perform the Interbase install but I am sure that the client is installed. I'm not sure if the client libraries are installed or how to find out. Here are the files in my interbase include directory: landsat: /opt/interbase/include a> ls gds.f gds.h gds.hxx ibase.h interbase.a perf.h Here are the files in my interclient directory. I do not have an interclient/include. Should I? landsat: /opt/interclient a> ls CommDiag.html examples interclient-res.jar java40.jar VERSION.TXT ic_license.dat interclient-utils.jar bin interclient interclient.jar docs interclient-core.jar interserver.log ############## Section 3) Here is the email I sent to dbi-users that documents my problem (same as the first link above): Hello, I installed perl 5.6.1 and DBI-1.2.1 and have Interbase 5.0 running. Perhaps the problem is that I have Interbase 5.0, but I noticed a similar post a few weeks ago with no posted resolution. here is the problem: I have aproblem installing DBD::Interbase-0.30. ------------------------------ The output of "perl Makefile.PL CC=gcc" is this: ------------------------------ hyperion: /opt/dial/software/perl_5.6.1/DBD-InterBase-0.30 r> perl Makefile.PL CC=gcc InterBase bin directory : [/opt/interbase/bin] InterBase include directory : [/opt/interbase/include] Reading cached test configuration... Full path to your test database : [/opt/interbase/isc4.gdb] .... Checking if your kit is complete... Looks good Note (probably harmless): No library found for -lgdsmt Using DBI 1.21 installed in /opt/dial/software/perl_5.6.1/lib/site_perl/5.6.1/sun4-solaris/auto/DBI Writing Makefile for DBD::InterBase ------------------------------ The output of "make" is this: ------------------------------ cp lib/Bundle/DBD/InterBase.pm blib/lib/Bundle/DBD/InterBase.pm cp InterBase.pm blib/lib/DBD/InterBase.pm cp lib/DBD/InterBase/FAQ.pm blib/lib/DBD/InterBase/FAQ.pm /opt/dial/software/bin/perl -p -e "s/~DRIVER~/InterBase/g" < /opt/dial/software/perl_5.6.1/lib/site_perl/5.6.1/sun4-solaris/auto/DBI/Driver.xst > InterBase.xsi /opt/dial/software/bin/perl -I/opt/dial/software/perl_5.6.1/lib/5.6.1/sun4-solaris -I/opt/dial/software/perl_5.6.1/lib/5.6.1 /opt/dial/software/perl_5.6.1/lib/5.6.1/ExtUtils/xsubpp -noprototypes -typemap /opt/dial/software/perl_5.6.1/lib/5.6.1/ExtUtils/typemap InterBase.xs > InterBase.xsc && mv InterBase.xsc InterBase.c gcc -c -I/opt/interbase/include -I/opt/dial/software/perl_5.6.1/lib/site_perl/5.6.1/sun4-solaris/auto/DBI -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"0.30\" -DXS_VERSION=\"0.30\" -fPIC -I/opt/dial/software/perl_5.6.1/lib/5.6.1/sun4-solaris/CORE InterBase.c gcc -c -I/opt/interbase/include -I/opt/dial/software/perl_5.6.1/lib/site_perl/5.6.1/sun4-solaris/auto/DBI -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"0.30\" -DXS_VERSION=\"0.30\" -fPIC -I/opt/dial/software/perl_5.6.1/lib/5.6.1/sun4-solaris/CORE dbdimp.c In file included from dbdimp.c:14: dbdimp.h:30: redefinition of `DBI_SQL_CHAR' dbdimp.h:30: `DBI_SQL_CHAR' previously defined here dbdimp.h:30: `SQL_CHAR' undeclared here (not in a function) dbdimp.h:31: redefinition of `DBI_SQL_NUMERIC' dbdimp.h:31: `DBI_SQL_NUMERIC' previously defined here dbdimp.h:31: `SQL_NUMERIC' undeclared here (not in a function) dbdimp.h:32: redefinition of `DBI_SQL_DECIMAL' dbdimp.h:32: `DBI_SQL_DECIMAL' previously defined here dbdimp.h:32: `SQL_DECIMAL' undeclared here (not in a function) dbdimp.h:33: redefinition of `DBI_SQL_INTEGER' dbdimp.h:33: `DBI_SQL_INTEGER' previously defined here dbdimp.h:33: `SQL_INTEGER' undeclared here (not in a function) dbdimp.h:34: redefinition of `DBI_SQL_SMALLINT' dbdimp.h:34: `DBI_SQL_SMALLINT' previously defined here dbdimp.h:34: `SQL_SMALLINT' undeclared here (not in a function) dbdimp.h:35: redefinition of `DBI_SQL_FLOAT' dbdimp.h:35: `DBI_SQL_FLOAT' previously defined here dbdimp.h:36: redefinition of `DBI_SQL_REAL' dbdimp.h:36: `DBI_SQL_REAL' previously defined here dbdimp.h:36: `SQL_REAL' undeclared here (not in a function) dbdimp.h:37: redefinition of `DBI_SQL_DOUBLE' dbdimp.h:37: `DBI_SQL_DOUBLE' previously defined here dbdimp.h:38: redefinition of `DBI_SQL_DATE' dbdimp.h:38: `DBI_SQL_DATE' previously defined here dbdimp.h:39: redefinition of `DBI_SQL_TIME' dbdimp.h:39: `DBI_SQL_TIME' previously defined here dbdimp.h:39: `SQL_TIME' undeclared here (not in a function) dbdimp.h:40: redefinition of `DBI_SQL_TIMESTAMP' dbdimp.h:40: `DBI_SQL_TIMESTAMP' previously defined here dbdimp.h:40: `SQL_TIMESTAMP' undeclared here (not in a function) dbdimp.h:41: redefinition of `DBI_SQL_VARCHAR' dbdimp.h:41: `DBI_SQL_VARCHAR' previously defined here dbdimp.h:41: `SQL_VARCHAR' undeclared here (not in a function) dbdimp.h:42: redefinition of `DBI_SQL_TYPE_TIME' dbdimp.h:42: `DBI_SQL_TYPE_TIME' previously defined here dbdimp.h:43: redefinition of `DBI_SQL_TYPE_DATE' dbdimp.h:43: `DBI_SQL_TYPE_DATE' previously defined here dbdimp.h:44: redefinition of `DBI_SQL_ARRAY' dbdimp.h:44: `DBI_SQL_ARRAY' previously defined here dbdimp.h:45: redefinition of `DBI_SQL_BLOB' dbdimp.h:45: `DBI_SQL_BLOB' previously defined here dbdimp.h:141: redefinition of `struct imp_drh_st' dbdimp.h:147: redefinition of `struct imp_dbh_st' dbdimp.h:164: redefinition of `struct imp_sth_st' dbdimp.h:184: redefinition of `struct vary' dbdimp.h:187: redefinition of `VARY' dbdimp.h:187: `VARY' previously declared here dbdimp.c: In function `ib2sql_type': dbdimp.c:222: `SQL_FLOAT' undeclared (first use in this function) dbdimp.c:222: (Each undeclared identifier is reported only once dbdimp.c:222: for each function it appears in.) dbdimp.c:226: `SQL_DOUBLE' undeclared (first use in this function) dbdimp.c:230: `SQL_TYPE_DATE' undeclared (first use in this function) dbdimp.c:234: `SQL_TYPE_TIME' undeclared (first use in this function) dbdimp.c:238: `SQL_TIMESTAMP' undeclared (first use in this function) dbdimp.c: In function `dbd_db_login6': dbdimp.c:445: `isc_dpb_SQL_dialect' undeclared (first use in this function) dbdimp.c: In function `ib_st_prepare': dbdimp.c:1062: `SQL_TYPE_DATE' undeclared (first use in this function) dbdimp.c:1084: `SQL_TIMESTAMP' undeclared (first use in this function) dbdimp.c:1097: `SQL_TYPE_TIME' undeclared (first use in this function) dbdimp.c:1063: warning: unreachable code at beginning of switch statement dbdimp.c: In function `ib_st_fetch': dbdimp.c:1492: `SQL_FLOAT' undeclared (first use in this function) dbdimp.c:1496: `SQL_DOUBLE' undeclared (first use in this function) dbdimp.c:1562: `SQL_DATE' undeclared (first use in this function) dbdimp.c:1685: `SQL_BLOB' undeclared (first use in this function) dbdimp.c:1836: `SQL_ARRAY' undeclared (first use in this function) dbdimp.c: In function `ib_fill_isqlda': dbdimp.c:2421: `SQL_TIMESTAMP' undeclared (first use in this function) dbdimp.c:2429: `SQL_TYPE_DATE' undeclared (first use in this function) dbdimp.c:2437: `SQL_TYPE_TIME' undeclared (first use in this function) dbdimp.c:2422: warning: unreachable code at beginning of switch statement dbdimp.c:2737: `SQL_FLOAT' undeclared (first use in this function) dbdimp.c:2754: `SQL_DOUBLE' undeclared (first use in this function) dbdimp.c:2771: `SQL_DATE' undeclared (first use in this function) dbdimp.c:2783: warning: unreachable code at beginning of switch statement dbdimp.c:2845: `SQL_BLOB' undeclared (first use in this function) dbdimp.c:2856: `SQL_ARRAY' undeclared (first use in this function) make: *** [dbdimp.o] Error 1 ------------------------------ Thanks for taking the time to read this. I hope this is a simple problem. I look forward to interacting with my database with the DBI module! --Aaryn
