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
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
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
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
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
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
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.
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
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:
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
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
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
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
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
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 ?
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-
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
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
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
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-
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,
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
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;
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
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
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:
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
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
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});
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
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 =
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.
32 matches
Mail list logo