SQL2071N error occured while accessing libdb2licm.so
Hi all, SQL2071N error occured while accessing libdb2licm.so When I start db2 under suse7.2 this error occured: SQL2071N error occured while accessing libdb2licm.so I have libdb2licm.so and libdb2licm.so.1 in db2\lib directory. Thanks in advance, --Maryam Hasan
Re: SQL2071N error occured while accessing libdb2licm.so
SQL2071N An error occurred while accessing the shared library shr-lib-name. Reason code: reason-code Cause: An unexpected error occurred while accessing a vendor shared library during the processing of a database utility. The following is a list of reason codes: 1 An invalid shared library path was encountered. 2 An attempt to load the backup shared library failed. 3 An error was encountered while unloading the shared library. The utility stops processing. Action: Ensure the shared library provided is valid and resubmit the utility command or use another supported media. Greetings, Paul. [EMAIL PROTECTED] f.eduTo: [EMAIL PROTECTED] cc: 18-09-2002 Subject: SQL2071N error occured while accessing libdb2licm.so 09:52 Hi all, SQL2071N error occured while accessing libdb2licm.so When I start db2 under suse7.2 this error occured: SQL2071N error occured while accessing libdb2licm.so I have libdb2licm.so and libdb2licm.so.1 in db2\lib directory. Thanks in advance, --Maryam Hasan
Problems with using DBD-ODBC
Hi Tim and Jeff, We are having problems with using DBD-ODBC. The ODBC driver is installed on our server and can connect to our Redbrick Db, but the DBD-ODBC can not connect when running the Maketest. 1. The log of all step of the built is attached in the zip file. 2. Perl: v5.6.1 built for aix Database: Redbrick v6.11 Server: AIX 4.3.3.0 If you require any additional information not in the attached files please don't hesitate to ask. Your assistance with our problem will be greatly appreciated. Kind Regards, Alex Cerantonio output.zip Description: Zip compressed data
RE: Quirky problem with DBI
Hello,
I have a similar problem to Brad some days ago, but the solution that
worked for him leads to new error messages for me. I am trying to insert
values into an Access database, conc_name and definition are of type
Memo. The error message I get is:
[Microsoft][ODBC Microsoft Access Driver]COUNT-Feld ungültig.
(SQL-07001)(DBD: st_execute/SQLExecute err=-1) at PerlModule/Database.pm
line 110.
Here an excerpt of my code with the possibly relevant information:
use DBI qw(:sql_types);
my $dbh = DBI-connect(DBI:ODBC:MLTD,
{
'RaiseError' = 1,
'LongReadLen' = 2048,
'LongTruncOk' = 1
}
);
my $sql .= INSERT INTO tbl_concepts_wn
(conc_name,definition,source) VALUES (?,?,?);
my $sth = $dbh-prepare($sql);
$sth-bind_param(1, $conc_name, SQL_LONGVARCHAR);
$sth-bind_param(2, $definition, SQL_LONGVARCHAR);
$sth-execute or die $dbh-errstr;
I also tried the following variation:
$sth-bind_param(1, $conc_name, DBI::SQL_LONGVARCHAR);
$sth-bind_param(2, $definition, DBI::SQL_LONGVARCHAR);
What could I be doing wrong?
TIA, Uli
PS: Quirky problem with DBI
Ulrike Schmidt wrote: The error message I get is: [Microsoft][ODBC Microsoft Access Driver]COUNT-Feld ungültig. (SQL-07001)(DBD: st_execute/SQLExecute err=-1) at PerlModule/Database.pm line 110. This probalby translates to invalid COUNT-field. Uli
Error while running odbctest
After installing the Single-Tier lite driver and iODBC , i get error while running odbctest. Error: janarthp@sys1:/u/janarthp/Tar/iODBC/bin odbctest iODBC Demonstration program This program shows an interactive SQL processor Enter ODBC connect string (? shows list): DSN=gel [iODBC][Driver Manager]Specified driver could not be loaded, SQLSTATE=IM003 [iODBC][Driver Manager]ld.so.1: odbctest: fatal: /tmp_mnt/home/hyd/fs1/u5/janarthp/Tar/Single-Tier/lib/sql_st_lt.so: open failed: No such file or directory, SQLSTATE=0 Have a nice day.janarthp@sys1:/u/janarthp/Tar/iODBC/bin janarthp@sys1:/u/janarthp/Tar/iODBC/bin I have the 'gel' entry in the odbc.ini file which points to the NTmachime having the database. Also i have sql_lt.lic (eval licence) put in the bin directory of the driver. if i try puting the username and password in the existing DSN (sql_lite), it gives me another error telling... Error: janarthp@sys1:/u/janarthp/Tar/iODBC/bin odbctest iODBC Demonstration program This program shows an interactive SQL processor Enter ODBC connect string (? shows list): DSN=sql_lite Wed Sep 18 2002 16:12:58 ERROR: No valid license was found 16:12:58 ERROR: Please contact OpenLink Customer Support [OpenLink][ODBC][Driver]No valid license was found, SQLSTATE=08004 Have a nice day.janarthp@sys1:/u/janarthp/Tar/iODBC/bin what could be the reason for this. help! thanks Prassana
RE: Quirky problem with DBI
Hi Ulrike,
Try the following.
use DBI ;
use DBD::ODBC qw(:sql_types) ;
$sth-bind_param(1, $conc_name, { TYPE = SQL_LONGVARCHAR });
$sth-bind_param(2, $definition, { TYPE = SQL_LONGVARCHAR });
Greetings,
Paul.
Ulrike Schmidt
ulrike.schmidt@uni- To: [EMAIL PROTECTED]
erfurt.de cc:
Subject: RE: Quirky problem with
DBI
18-09-2002 12:30
Hello,
I have a similar problem to Brad some days ago, but the solution that
worked for him leads to new error messages for me. I am trying to insert
values into an Access database, conc_name and definition are of type
Memo. The error message I get is:
[Microsoft][ODBC Microsoft Access Driver]COUNT-Feld ungültig.
(SQL-07001)(DBD: st_execute/SQLExecute err=-1) at PerlModule/Database..pm
line 110.
Here an excerpt of my code with the possibly relevant information:
use DBI qw(:sql_types);
my $dbh = DBI-connect(DBI:ODBC:MLTD,
{
'RaiseError' = 1,
'LongReadLen' = 2048,
'LongTruncOk' = 1
}
);
my $sql .= INSERT INTO tbl_concepts_wn
(conc_name,definition,source) VALUES (?,?,?);
my $sth = $dbh-prepare($sql);
$sth-bind_param(1, $conc_name, SQL_LONGVARCHAR);
$sth-bind_param(2, $definition, SQL_LONGVARCHAR);
$sth-execute or die $dbh-errstr;
I also tried the following variation:
$sth-bind_param(1, $conc_name, DBI::SQL_LONGVARCHAR);
$sth-bind_param(2, $definition, DBI::SQL_LONGVARCHAR);
What could I be doing wrong?
TIA, Uli
RE: Quirky problem with DBI
But don't you have an invalid count? 3 parameters in the SQL (3 question marks)
and onlt 2 bound parameters (two calls to bind_param for params 1 and 2).
Martin
On 18-Sep-2002 Ulrike Schmidt wrote:
Hello,
I have a similar problem to Brad some days ago, but the solution that
worked for him leads to new error messages for me. I am trying to insert
values into an Access database, conc_name and definition are of type
Memo. The error message I get is:
[Microsoft][ODBC Microsoft Access Driver]COUNT-Feld ungültig.
(SQL-07001)(DBD: st_execute/SQLExecute err=-1) at PerlModule/Database.pm
line 110.
Here an excerpt of my code with the possibly relevant information:
use DBI qw(:sql_types);
my $dbh = DBI-connect(DBI:ODBC:MLTD,
{
'RaiseError' = 1,
'LongReadLen' = 2048,
'LongTruncOk' = 1
}
);
my $sql .= INSERT INTO tbl_concepts_wn
(conc_name,definition,source) VALUES (?,?,?);
my $sth = $dbh-prepare($sql);
$sth-bind_param(1, $conc_name, SQL_LONGVARCHAR);
$sth-bind_param(2, $definition, SQL_LONGVARCHAR);
$sth-execute or die $dbh-errstr;
I also tried the following variation:
$sth-bind_param(1, $conc_name, DBI::SQL_LONGVARCHAR);
$sth-bind_param(2, $definition, DBI::SQL_LONGVARCHAR);
What could I be doing wrong?
TIA, Uli
--
Martin J. Evans
Easysoft Ltd, UK
Development
RE: Error while running odbctest
I suggest you talk to OpenLink directly regarding this. (That is, if this is still the openlink driver that you mentioned you were using in prior e-mails). Regards, Jeff After installing the Single-Tier lite driver and iODBC , i get error while running odbctest. Error: janarthp@sys1:/u/janarthp/Tar/iODBC/bin odbctest iODBC Demonstration program This program shows an interactive SQL processor Enter ODBC connect string (? shows list): DSN=gel [iODBC][Driver Manager]Specified driver could not be loaded, SQLSTATE=IM003 [iODBC][Driver Manager]ld.so.1: odbctest: fatal: /tmp_mnt/home/hyd/fs1/u5/janarthp/Tar/Single-Tier/lib/sql_st_lt.so: open failed: No such file or directory, SQLSTATE=0 Have a nice day.janarthp@sys1:/u/janarthp/Tar/iODBC/bin janarthp@sys1:/u/janarthp/Tar/iODBC/bin I have the 'gel' entry in the odbc.ini file which points to the NTmachime having the database. Also i have sql_lt.lic (eval licence) put in the bin directory of the driver. if i try puting the username and password in the existing DSN (sql_lite), it gives me another error telling... Error: janarthp@sys1:/u/janarthp/Tar/iODBC/bin odbctest iODBC Demonstration program This program shows an interactive SQL processor Enter ODBC connect string (? shows list): DSN=sql_lite Wed Sep 18 2002 16:12:58 ERROR: No valid license was found 16:12:58 ERROR: Please contact OpenLink Customer Support [OpenLink][ODBC][Driver]No valid license was found, SQLSTATE=08004 Have a nice day.janarthp@sys1:/u/janarthp/Tar/iODBC/bin what could be the reason for this. help! thanks Prassana
RE: Problems with using DBD-ODBC
Hi Tim and Jeff, We are having problems with using DBD-ODBC. The ODBC driver is installed on our server and can connect to our Redbrick Db, but the DBD-ODBC can not connect when running the Maketest. 1. The log of all step of the built is attached in the zip file. 2. Perl: v5.6.1 built for aix Database: Redbrick v6.11 Server: AIX 4.3.3.0 If you require any additional information not in the attached files please don't hesitate to ask. Your assistance with our problem will be greatly appreciated. What version of DBD::ODBC are you using (probably not important yet, but may be)? Are you really using unixODBC as your driver manager? (good, if you are)? Did you test connecting to the database before testing DBD::ODBC? UnixODBC includes odbctest. You should allocate an environment handle then connect. If that works, then DBD::ODBC should work. Regards, Jeff Kind Regards, Alex Cerantonio
RE: Error while running odbctest
Ya, iam not getting any reply from their technical support. I thought that someone else in this group also wud have experienced this. Was anyone successful in using the iODCB manager with single tier lite driver? help! thanks Prassana -Original Message- From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 5:48 PM To: Janarthanan, Prasanna; [EMAIL PROTECTED] Subject: RE: Error while running odbctest I suggest you talk to OpenLink directly regarding this. (That is, if this is still the openlink driver that you mentioned you were using in prior e-mails). Regards, Jeff After installing the Single-Tier lite driver and iODBC , i get error while running odbctest. Error: janarthp@sys1:/u/janarthp/Tar/iODBC/bin odbctest iODBC Demonstration program This program shows an interactive SQL processor Enter ODBC connect string (? shows list): DSN=gel [iODBC][Driver Manager]Specified driver could not be loaded, SQLSTATE=IM003 [iODBC][Driver Manager]ld.so.1: odbctest: fatal: /tmp_mnt/home/hyd/fs1/u5/janarthp/Tar/Single-Tier/lib/sql_st_lt.so: open failed: No such file or directory, SQLSTATE=0 Have a nice day.janarthp@sys1:/u/janarthp/Tar/iODBC/bin janarthp@sys1:/u/janarthp/Tar/iODBC/bin I have the 'gel' entry in the odbc.ini file which points to the NTmachime having the database. Also i have sql_lt.lic (eval licence) put in the bin directory of the driver. if i try puting the username and password in the existing DSN (sql_lite), it gives me another error telling... Error: janarthp@sys1:/u/janarthp/Tar/iODBC/bin odbctest iODBC Demonstration program This program shows an interactive SQL processor Enter ODBC connect string (? shows list): DSN=sql_lite Wed Sep 18 2002 16:12:58 ERROR: No valid license was found 16:12:58 ERROR: Please contact OpenLink Customer Support [OpenLink][ODBC][Driver]No valid license was found, SQLSTATE=08004 Have a nice day.janarthp@sys1:/u/janarthp/Tar/iODBC/bin what could be the reason for this. help! thanks Prassana
RE: Problems with using DBD-ODBC
On 18-Sep-2002 Jeff Urlwin wrote: Hi Tim and Jeff, We are having problems with using DBD-ODBC. The ODBC driver is installed on our server and can connect to our Redbrick Db, but the DBD-ODBC can not connect when running the Maketest. 1. The log of all step of the built is attached in the zip file. 2. Perl: v5.6.1 built for aix Database: Redbrick v6.11 Server: AIX 4.3.3.0 If you require any additional information not in the attached files please don't hesitate to ask. Your assistance with our problem will be greatly appreciated. What version of DBD::ODBC are you using (probably not important yet, but may be)? Are you really using unixODBC as your driver manager? (good, if you are)? Did you test connecting to the database before testing DBD::ODBC? UnixODBC includes odbctest. You should allocate an environment handle then connect. If that works, then DBD::ODBC should work. odbctest might bot be built when unixODBC is built. You need QT and the configure for unixODBC needs to find QT. However, isql (in bin dir) is (to my knowledge) always built so if you have not got odbctest, use isql (and use the -v verbose option as the error is output if it does not work). Martin -- Martin J. Evans Easysoft Ltd, UK Development
Connecting to Oracle through Perl.
Hi, Can somebody tell me where the Perl exactly look for tnsnames.ora while connecting to Oracle ? (like home, oracle_home, tns_admin etc ...). I want to know the order in which it looks the directories ? Thanks Regards Sridhar
RE: Connecting to Oracle through Perl.
I am pretty sure this is supposed to reside in /etc. I know that on our HP-UX boxes the tnsnames.ora is in /etc and we use Perl for some database access. -Original Message- From: Sridhar Saragu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 8:24 AM To: [EMAIL PROTECTED] Subject: Connecting to Oracle through Perl. Hi, Can somebody tell me where the Perl exactly look for tnsnames.ora while connecting to Oracle ? (like home, oracle_home, tns_admin etc ...). I want to know the order in which it looks the directories ? Thanks Regards Sridhar
Re: Connecting to Oracle through Perl.
on the Tru64 unix box we are using it is found at : /usr/app/oracle/product/7.3.4/network/admin/tnsnames.ora hope this helps cheers Edd Sridhar Saragu [EMAIL PROTECTED] 09/18/02 14:21 PM Hi, Can somebody tell me where the Perl exactly look for tnsnames.ora while connecting to Oracle ? (like home, oracle_home, tns_admin etc ...). I want to know the order in which it looks the directories ? Thanks Regards Sridhar
RE: Connecting to Oracle through Perl.
The Oracle client looks for tnsnames.ora in the
$ORACLE_HOME/network/admin directory. We typically set the Perl
variable $ENV{ORACLE_HOME} to the location of the Oracle installation in
our database connection modules prior to any attempt to open a database
connection.
-dpf-
---
David P. Fannin
Database Administrator [EMAIL PROTECTED]
UM-Rolla Computing and Information Services FAX (573) 341-4216
URL http://www.umr.edu/~dpf PHONE (573) 341-4841
---
-Original Message-
From: Sridhar Saragu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 8:24 AM
To: [EMAIL PROTECTED]
Subject: Connecting to Oracle through Perl.
Hi,
Can somebody tell me where the Perl exactly look for tnsnames.ora
while connecting to Oracle ? (like home, oracle_home, tns_admin etc
). I want to
know the order in which it looks the directories ?
Thanks Regards
Sridhar
Re: Connecting to Oracle through Perl.
On Wed, Sep 18, 2002 at 06:54:13PM +0530, Sridhar Saragu wrote: Hi, Can somebody tell me where the Perl exactly look for tnsnames.ora while connecting to Oracle ? (like home, oracle_home, tns_admin etc ...). I want to know the order in which it looks the directories ? To quote Star Wars: Use the source, Luke! See load_dbnames() in Oracle.pm Tim.
Re: Quirky problem with DBI
Oops, yes, now everything works fine, thanks a lot! (embarassing ...)
Uli
[EMAIL PROTECTED] wrote:
But don't you have an invalid count? 3 parameters in the SQL (3 question marks)
and onlt 2 bound parameters (two calls to bind_param for params 1 and 2).
Martin
On 18-Sep-2002 Ulrike Schmidt wrote:
Hello,
I have a similar problem to Brad some days ago, but the solution that
worked for him leads to new error messages for me. I am trying to insert
values into an Access database, conc_name and definition are of type
Memo. The error message I get is:
[Microsoft][ODBC Microsoft Access Driver]COUNT-Feld ungültig.
(SQL-07001)(DBD: st_execute/SQLExecute err=-1) at PerlModule/Database.pm
line 110.
Here an excerpt of my code with the possibly relevant information:
use DBI qw(:sql_types);
my $dbh = DBI-connect(DBI:ODBC:MLTD,
{
'RaiseError' = 1,
'LongReadLen' = 2048,
'LongTruncOk' = 1
}
);
my $sql .= INSERT INTO tbl_concepts_wn
(conc_name,definition,source) VALUES (?,?,?);
my $sth = $dbh-prepare($sql);
$sth-bind_param(1, $conc_name, SQL_LONGVARCHAR);
$sth-bind_param(2, $definition, SQL_LONGVARCHAR);
$sth-execute or die $dbh-errstr;
I also tried the following variation:
$sth-bind_param(1, $conc_name, DBI::SQL_LONGVARCHAR);
$sth-bind_param(2, $definition, DBI::SQL_LONGVARCHAR);
What could I be doing wrong?
TIA, Uli
--
Martin J. Evans
Easysoft Ltd, UK
Development
DBD DBI for Oracle7 8
Hi, Can somebody tell the location( i mean Perl sites ) and version of DBI and DBD which will work on both Oracle7 8 ( i have to work on both databases simultaneously ). Thanks Regards Sridhar
RE: Error while running odbctest
Hi, Have you set the value of LD_LIBRARY_PATH? Have you installed an ODBC driver manager as well as an ODBC driver? Try to you connect to the DB using 'odbctest', a provided test program, before you attempt your make. Have you defined top_srcdir via 'configure? Pete -Original Message- From: Janarthanan, Prasanna [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 7:38 AM To: Levine, Peter W Subject: RE: Error while running odbctest thanks really for supporting me .. Can u just tell me the Driver manager and its installation procedure.. I will tell u what i did .. 1. Driver (Openlinksw single-Tier Driver for SQLserver): installation info: It installed the driver janarthp@sys1:/u/janarthp/Tar/ODBC/Single-Tier/lite/lib l total 2514 -rwxr-xr-x 1 janarthp staff775 Sep 13 01:54 sql_st_lt.la -rwxr-xr-x 1 janarthp staff1277520 Sep 13 01:54 sql_st_lt.so janarthp@sys1:/u/janarthp/Tar/ODBC/Single-Tier/lite/lib cd ../bin/ janarthp@sys1:/u/janarthp/Tar/ODBC/Single-Tier/lite/bin l total 150 -rw-r--r-- 1 janarthp staff 1516 Sep 17 15:45 freetds.conf -rw-r--r-- 1 janarthp staff 1413 Sep 13 01:54 freetds.conf.sample -rwxr-xr-x 1 janarthp staff 53848 Sep 13 01:54 inifile -rw-r--r-- 1 janarthp staff 1245 Sep 17 15:46 odbc.ini -rw-r--r-- 1 janarthp staff476 Sep 13 01:54 odbc.ini.sample -rw-r--r-- 1 janarthp staff728 Sep 17 15:29 odbcinst.ini -rw-r--r-- 1 janarthp staff478 Sep 13 01:54 odbcinst.ini.sample -rw-r--r-- 1 janarthp staff 6172 Sep 17 15:50 openlink.ini -rw-r--r-- 1 janarthp staff 5662 Sep 13 01:54 openlink.ini.sample I got the driver as listed above at lib directory and entries are made in to the odbc.ini file. All the required setenv has been done. 2. Driver Manager (iODBC from www.iodbc.org (libiodbc-3.0.6)) Installation Info: To install this I ran the Following command as given in its Documentations a. ./configure --prefix=/u/janarthp --with-iodbc-inidir=/u/janarthp/Tar/ODBC/Single-Tier/lite/bin * here i give the odbc location as the location of the odbc.ini file i got after installing the driver. b. make c. make install It got installed. 3. DBD:ODBC (0.45.x) Installation info: ran makefile.PL and installed at /u/janarthp/Tar/ODBC/DBD_ODBC/DBD I have set the Env_variables DBI_DSN , DBI_USER , DBI_PASS as 'gel(as defined in the odbc.ini file of the driver)' , 'sa' , '' ( Database is a SQL.) My basic doubt arised here: should i ran the makefile.PL with ODBCHOME variable set? I did it but gave some error like this when i tested with a Perl script. error: install_driver(ODBC) failed: Can't locate loadable object for module DBD::ODBC in @INC (@INC contains: /u/janarthp/Tar/ODBC/DBD_ODBC /usr/local/lib/perl5/5.6.1/sun4-solaris /usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris /usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl /prod/tools/packages/lib/perl5/5.6.1/sun4-solaris /prod/tools/packages/lib/perl5/5.6.1 /prod/tools/packages/lib/perl5 .) at (eval 1) line 3 Compilation failed in require at (eval 1) line 3. Perhaps a module that DBD::ODBC requires hasn't been fully installed at test.pl line 6 Please clear me out here. Also i need to know as how there is a link between all these three components. what i understood while installing is: driver--($driver/bin/odbc.ini) -- Driver Manager (ODBCHOME= $iODBC_location) --- DBD:ODBC -- (used by perl) [Is this what the happenings inside ] As it is telling that it couldn't load the perl module (included it in the @INC also), i don;t think that DBD:ODBC is having any problem. help needed... thanks, Prassana -Original Message- From: Levine, Peter W [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 8:03 PM To: Janarthanan, Prasanna Subject: RE: Error while running odbctest It worked for me connecting to MS SQL server. I found their tech support to be very helpful. Pete -Original Message- From: Janarthanan, Prasanna [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 5:27 AM To: 'Jeff Urlwin'; [EMAIL PROTECTED] Subject: RE: Error while running odbctest Ya, iam not getting any reply from their technical support. I thought that someone else in this group also wud have experienced this. Was anyone successful in using the iODCB manager with single tier lite driver? help! thanks Prassana -Original Message- From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 5:48 PM To: Janarthanan, Prasanna; [EMAIL PROTECTED] Subject: RE: Error while running odbctest I suggest you talk to OpenLink directly regarding this. (That is, if this is still the openlink driver that you mentioned you were using in prior e-mails). Regards, Jeff After installing the Single-Tier lite driver and iODBC , i get error while running odbctest. Error:
DBIx::Recordset question
Greetings-
I'm new to this list, but I hope that someone here can help me.
I am trying to write a page which returns the results from a simple select
with a like clause: Here is the snippet:
*set = DBIx::Recordset - Search ({%fdat,
('!DataSource' = $DSN,
'!Username' = $user,
'!Password' = $passwd,
'!Table' = $table,
'$where' = 'address like',
'$values' = $domain,)}) ; -]
So, I would assume that this would create something like:
select * from table where address like $domain.
But, when I query the result set, there is nothing. On a related note, how
can i get DBIx::Recordset to show me the query it passes to mysql.
So, is the above snippet doing what i would expect it to do?
Thanks,
Dan
Shared Library Woes
I have oracle 8.0.6 and 8.1.7 installed on a server and a perl program that I run on instances of both versions on this server. The env variables, including LD_LIBRARY_PATH, are set in .profile files which I run for the specific db version before I run the script. The 8.0.6 version runs without any problems, but the 8.1.7 version gives the following error. I had a similar problem last week (unrelated to this script) and setting the LD_LIBRARY_PATH fixed the problem. In this case, perl is complaining about a lib file that does not exist in my $ORACLE_HOME/lib of version 8.1.7. install_driver(Oracle) failed: Can't load '/usr/local/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBD/Oracle/Oracle..so' for module DBD::Oracle: ld.so.1: /usr/local/bin/perl: fatal: libclntsh.so.1.0: open failed: No such file or directory at /usr/local/lib/perl5/5.00503/sun4-solaris/DynaLoader.pm line 169, STDIN chunk 1. at (eval 2) line 3 Perhaps a required shared library or dll isn't installed where expected Here's what I have in the 8.0.6 and 8.1.7 libs: ls -l /epm01/app/oracle/product/817/lib/libclntsh* lrwxrwxrwx 1 oracle dba 16 Sep 18 09:56 /epm01/app/oracle/product/817/lib/libclntsh.so - libclntsh.so.8.0 -rwxrwxr-x 1 oracle dba 10193172 Jan 7 2002 /epm01/app/oracle/product/817/lib/libclntsh.so.8.0 ls -l /fin01/app/oracle/product/806/lib/libclntsh* lrwxrwxrwx 1 oracle dba 16 Jun 10 2001 /fin01/app/oracle/product/806/lib/libclntsh.so - libclntsh.so.1.0 -rwxr-xr-x 1 oracle dba 6538704 Jul 17 2000 /fin01/app/oracle/product/806/lib/libclntsh.so.1.0 Shouldn't perl look for libclntsh.so.8.0 instead of libclntsh.so.1.0 for version 8.1.7? All other oracle-related env variables are set to 8.1.7 home by .profile. Thanks in advance, - Mahtaj Khamneian University of Missouri - ASP Phone : (573) 884-2281 1805 East Walnut Fax : (573) 884-3070 Columbia, MO 65201-6425 [EMAIL PROTECTED]
Can't save oracle BLOB with DBI::Oracle
Hello,
I am using the following code to update a BLOB field into
our Oracle database:
$sql = UPDATE CMSDOCUMENT SET CONTENT=? WHERE CMSDOCUMENTID=$cmsid;
$sth = $oradbh-prepare($sql);
$sth-bind_param(1, $html, {ora_type = ORA_BLOB});
$sth-execute() or die update of topic content failed.\n;
This code works for small size saves. However, when value
of $html gets large, the code just hungs.
I'd appreciate any ideas.
Thank you,
Chris Lambrek.
Problem populating execute using @array.
I am trying to update a table in an Oracle database. I am reading an
input file which has
the column names for the database as the first record in the file. The
data begins in the second row. I read the first record to pull off the
column names. I create the sql using placeholders. I then read the rest
of the file. At the end of the loop I attempt to perform the 'execute'
using the statement handle of the database. I get the following error.
DBD::Oracle::st execute failed: ORA-01722: invalid number (DBD ERROR:
OCIStmtExecute) at ./ins line 61, $FH line 1.
At the time of the execute ins = 20, 2, Hello, Dolly, 000,
01, 022
# assume sth is a valid statement handle
# assume $FH is a handle to an opened file
my $columns = $FH;
#
# read first record of input file
# split the column headers
#
my $columnitem;
chomp($columns);
ins = split /\|/, $columns;
foreach $columnitem (ins) {
$columnitem = \.$columnitem.\;
}
my $formatcolumns=join ( ', ', ins );
my $valstring= join ( ', ' , ('?') x scalar ins );
my $sql= INSERT INTO $table ( $formatcolumns ) VALUES ( $valstring) ;
while ( my $line = $FH )
{
#
# split the data fields
#
chomp($line);
my $field;
ins = split /\|/, $line;
foreach $field (ins) {
$field = \.$field.\,;
}
chop($ins[-1]); # remove comma from last item in array
#the actual sequence
$sth-execute(ins) or $err++;
}
RE: Can't save oracle BLOB with DBI::Oracle
LongReadLen (unsigned integer, inherited)
This attribute may be used to control the maximum
length of long fields (blob, memo, etc.) which the
driver will read from the database automatically when
it fetches each row of data. The LongReadLen
attribute only relates to fetching and reading long
values; it is not involved in inserting or updating
them.
... so set $dbh-LongReadLen(32767) before the prepare.
/\
||
Or whatever size you want.
On 18-Sep-2002 [EMAIL PROTECTED] wrote:
Hello,
I am using the following code to update a BLOB field into
our Oracle database:
$sql = UPDATE CMSDOCUMENT SET CONTENT=? WHERE CMSDOCUMENTID=$cmsid;
$sth = $oradbh-prepare($sql);
$sth-bind_param(1, $html, {ora_type = ORA_BLOB});
$sth-execute() or die update of topic content failed.\n;
This code works for small size saves. However, when value
of $html gets large, the code just hungs.
I'd appreciate any ideas.
Thank you,
Chris Lambrek.
--
E-Mail: [EMAIL PROTECTED]
Date: 18-Sep-2002
Time: 13:49:54
--
Re: Problem populating execute using @array.
What are the columns defined as(data types)? Looks to me like
at least one of the columns is defined as an INTEGER, or another
form of a number, and you are trying to feed it a string value.
HTH.
--
Hardy Merrill
Senior Software Engineer
Red Hat, Inc.
Dolan, Mark [[EMAIL PROTECTED]] wrote:
I am trying to update a table in an Oracle database. I am reading an
input file which has
the column names for the database as the first record in the file. The
data begins in the second row. I read the first record to pull off the
column names. I create the sql using placeholders. I then read the rest
of the file. At the end of the loop I attempt to perform the 'execute'
using the statement handle of the database. I get the following error.
DBD::Oracle::st execute failed: ORA-01722: invalid number (DBD ERROR:
OCIStmtExecute) at ./ins line 61, $FH line 1.
At the time of the execute @ins = 20, 2, Hello, Dolly, 000,
01, 022
# assume sth is a valid statement handle
# assume $FH is a handle to an opened file
my $columns = $FH;
#
# read first record of input file
# split the column headers
#
my $columnitem;
chomp($columns);
@ins = split /\|/, $columns;
foreach $columnitem (@ins) {
$columnitem = \.$columnitem.\;
}
my $formatcolumns=join ( ', ', @ins );
my $valstring= join ( ', ' , ('?') x scalar @ins );
my $sql= INSERT INTO $table ( $formatcolumns ) VALUES ( $valstring) ;
while ( my $line = $FH )
{
#
# split the data fields
#
chomp($line);
my $field;
@ins = split /\|/, $line;
foreach $field (@ins) {
$field = \.$field.\,;
}
chop($ins[-1]); # remove comma from last item in array
#the actual sequence
$sth-execute(@ins) or $err++;
}
MUMPS Web access
Hi all, i´m going to work (probably) with a new type of data format i never had done before, this is, Mumps. I´ve read some info out there but I havent found anything about how to access Mumps files and show information in a web browser (i think it´s stored as DBM file), please, could you recommend some perl modules to do the task metioned before or some URL to get more info? I know too that exist an ODBC driver (opensystem? or something like) but i heard that it´s very slow retrieving data. Could i work with DBD-Chart or Write::Excel to export or show some statistics? I think perl is my destiny and I LIKE IT !!! Really thanks to all. __ Juan Jose Baeza Lopez [EMAIL PROTECTED] Murcia(Spain) Programador Perl, RDBMS Administrador de Sistemas Network Systems Admin. Linux User: 91468 __
RE: Problem populating execute using @array.
1. the prepare is missing, so $sth is not defined
2. the quoting loop is probably not doing what you want (its quoting the
tempoary variable field, not the elements of @ins) - but with placeholders
you probably don't want the fields quoted anyway
-Original Message-
From: Dolan, Mark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 4:35 AM
To: Perl Users Help (E-mail)
Subject: Problem populating execute using @array.
I am trying to update a table in an Oracle database. I am reading an
input file which has
the column names for the database as the first record in the file. The
data begins in the second row. I read the first record to pull off the
column names. I create the sql using placeholders. I then read the rest
of the file. At the end of the loop I attempt to perform the 'execute'
using the statement handle of the database. I get the following error.
DBD::Oracle::st execute failed: ORA-01722: invalid number (DBD ERROR:
OCIStmtExecute) at ./ins line 61, $FH line 1.
At the time of the execute @ins = 20, 2, Hello, Dolly, 000,
01, 022
# assume sth is a valid statement handle
# assume $FH is a handle to an opened file
my $columns = $FH;
#
# read first record of input file
# split the column headers
#
my $columnitem;
chomp($columns);
@ins = split /\|/, $columns;
foreach $columnitem (@ins) {
$columnitem = \.$columnitem.\;
}
my $formatcolumns=join ( ', ', @ins );
my $valstring= join ( ', ' , ('?') x scalar @ins );
my $sql= INSERT INTO $table ( $formatcolumns ) VALUES ( $valstring) ;
while ( my $line = $FH )
{
#
# split the data fields
#
chomp($line);
my $field;
@ins = split /\|/, $line;
foreach $field (@ins) {
$field = \.$field.\,;
}
chop($ins[-1]); # remove comma from last item in array
#the actual sequence
$sth-execute(@ins) or $err++;
}
Australia Post is committed to providing our customers with excellent service. If we
can assist you in any way please either telephone 13 13 18 or visit our website
www.auspost.com.au.
CAUTION
This e-mail and any files transmitted with it are privileged and confidential
information intended for the use of the addressee. The confidentiality and/or
privilege in this e-mail is not waived, lost or destroyed if it has been transmitted
to you in error. If you have received this e-mail in error you must (a) not
disseminate, copy or take any action in reliance on it; (b) please notify Australia
Post immediately by return e-mail to the sender; and (c) please delete the original
e-mail.
Re: Can't save oracle BLOB with DBI::Oracle
On Wed, 18 Sep 2002 12:24:52 -0500 [EMAIL PROTECTED] wrote:
I am using the following code to update a BLOB field into
our Oracle database:
$sql = UPDATE CMSDOCUMENT SET CONTENT=? WHERE CMSDOCUMENTID=$cmsid;
$sth = $oradbh-prepare($sql);
$sth-bind_param(1, $html, {ora_type = ORA_BLOB});
$sth-execute() or die update of topic content failed.\n;
This code works for small size saves. However, when value
of $html gets large, the code just hungs.
Add $oradbh-trace( 4, trace.file ); before the prepare() so you can
see what DBI thinks is happening.
If you don't have them, add '-w' to the '#!' line and use strict; to the
top of your program. They help you catch errors before they get too big to
find.
The error message in the 'or die' after execute() doesn't tell you what the
problem was. $DBI::errstr in the message would do that for you.
You aren't checking for errors from prepare(). Either add an 'or' clause
like the execute() or set $oradbh-{RaiseError} to 1.
Is there a reason you are pasting $cmsid into the SQL? If you execute this
more than once or from more than one process, Oracle has to replan it every
time. A placeholder would prevent that.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
RE: Problems with using DBD-ODBC
Yes, but the driver manager is important. I suggest you get unixODBC and configure your odbc.ini to 'point to' the redbrick driver. Then, connect with odbctest or isql (in unixODBC) to test. Then, with your ODBCHOME set to where unixODBC is installed, test DBD::ODBC. Jeff -Original Message- From: Alex Cerantonio [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 6:26 PM To: Jeff Urlwin; [EMAIL PROTECTED] Cc: Darren Edgerton Subject: RE: Problems with using DBD-ODBC Hi Jeff, We very much appreciate your prompt reply. In answer to your questions: 1. DBI v1.30 2. DBD::ODBC v0.43 3. We are using the ODBC driver supplied with the Redbrick Db Client SDK, this includes a test C program which compiles and runs connecting to the Db okay. I've attached this C program to this e-mail to have a look at. Kind Regards, Alex -Original Message- From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 10:25 PM To: Alex Cerantonio; [EMAIL PROTECTED] Cc: Darren Edgerton; [EMAIL PROTECTED] Subject: RE: Problems with using DBD-ODBC Hi Tim and Jeff, We are having problems with using DBD-ODBC. The ODBC driver is installed on our server and can connect to our Redbrick Db, but the DBD-ODBC can not connect when running the Maketest. 1. The log of all step of the built is attached in the zip file. 2. Perl: v5.6.1 built for aix Database: Redbrick v6.11 Server: AIX 4.3.3.0 If you require any additional information not in the attached files please don't hesitate to ask. Your assistance with our problem will be greatly appreciated. What version of DBD::ODBC are you using (probably not important yet, but may be)? Are you really using unixODBC as your driver manager? (good, if you are)? Did you test connecting to the database before testing DBD::ODBC? UnixODBC includes odbctest. You should allocate an environment handle then connect. If that works, then DBD::ODBC should work. Regards, Jeff Kind Regards, Alex Cerantonio
AnyData error
I'm getting this error (on execute) when I try to use DBI and AnyData
(.5).
DBD::AnyData::st execute failed: Undefined subroutine AnyData::adTable
I've used this on other servers without trouble, what dumb mistake am I
making?
code snip:
use DBI;
my $dbh = DBI-connect('dbi:AnyData(RaiseError=1):');
$dbh-func('searchdata','Pipe',searchdata.dta,'ad_catalog');
my $sql='SELECT * FROM searchdata';
my $sth=$dbh-prepare($sql);
$sth-execute() or die Cannot execute: $DBI::errstr\n;
Jeff
How to query for an apostrophe
Hiya. How can I search for the following?: D'Silva If I try to search for it, with the following query string: SELECT * FROM Players WHERE LName LIKE `%D'Silva%` I get the following error: Died while executing:[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. (SQL-07001)(DBD: st_execute/SQLExecute err=-1) at c:\inetpub\wwwroot\EBA\cgi-bin\player_search.pl line 709. Is there a way to escape the apostrophe? Thanks for your help! Nick Hoffman [EMAIL PROTECTED] The wireless telegraph is not difficult to understand. The ordinary telegraph is like a very long cat. You pull the tail in New York, and it meows in Los Angeles. The wireless is the same, only without the cat. -Albert Einstein
