Hi List
I'm tring to insert a timestamp
Using DBI 1.14, ActiveState 5.6, Access 2000
SQL =INSERT INTO tblCar (date_now,time_now) VALUES (#06/23/2003#,#16:13#)
Results in
DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access Driver]COUNT field
incorrect (SQL-07001)(DBD:
Tim Bunce writes:
On Tue, Jun 24, 2003 at 06:18:41PM -0700, William R Ward wrote:
We recently installed Perl 5.8.0 and have started seeing this error.
I think it's an error in DBI but I'm not 100% sure. Has anyone else
seen this, and what can be done to remedy it?
Use of inherited AUTOLOAD
Has any figured how to get around this error.
failed: ORA-06401: NETCMN: invalid driver designator (DBD ERROR:
OCIServerAttach)
Spencar
~~~
Spencar D McCaa
System Software
MN Department of Health
I am an oracle dba using unix and will so be
using win nt/ win 2000.
I have just started using perl as a programming language
and I am unsure about the add-in modules.
Is there any doco you can point me to, to findout
what perl can do with the DB? DBI? modules?
Text1--- [EMAIL PROTECTED] wrote:
How does one use the IPC protocol when connecting to a database on the
same machine?
This used to work for Oracle 7...
$ENV{ORACLE_SID} = 'THE_SID';
$dbh = DBI-connect('dbi:Oracle:','ods',$passwd);
That is not using the IPC protocol.
When you
I could be wrong but I think it is the ':' in the time that is causing the
problem. The DBD thinks the ':' is a parameter.
Insert the dates/times with placeholders instead and I think you'll find it
works. e.g. INSERT INTO tblCar (date_now,time_now) VALUES(?,?)
Martin
--
Martin J. Evans
On Wed, Jun 25, 2003 at 07:55:24PM -0400, Rudy Lippan wrote:
$c-bind_param(1, 0., DBI::SQL_INTEGER);
Perhaps DBI::SQL_FLOAT or DBI::SQL_DOUBLE would be more descriptive :)
Tim.
Hello,
I am trying to compile DBD-DB2 on HP-UX 11.00, but I am having several
problems. The DB2 App Dev requirement is installed.
1. I am running perl 5.6.1 (installed from an HP software depot), but
the Makefile.PL is showing perl 5.006. This may not really be an issue.
I have modified the
hello,
thanks for the reply - still stuck.
i have tried all combs of use/no bytes and use/no utf8
to me it looks like my chars get altered around the execute method:
this trace exeample is one single danish letter
æ
which get converted to
æ
could it be something to do with collation
I have tried and tried to compile DBD-DB2 and although the compile works
once the nolimit is remove, I am not able to connect.
I have tried:
1. Remove nolimit in Makefiles (would not compile unless this was
removed)
2. Changed flags to +O0 from +O2.
3. Added +DAportable.
I have done multiple
On Thu, Jun 26, 2003 at 10:44:00AM -0400, Craig Sharp wrote:
I have done multiple combinations of #2 above but still get the
following error on connect:
DBI-connect(ISDEV) failed: Total Environment allocation failure!
Did you set up your DB2 client environment? at domain_ret.pl line 13
You
Craig,
Don't know if this helps any, but under Ingres, you need to have certain environment
variables set before you can get it to work. In our setup, we have to define II_SYSTEM
and LD_LIBRARY_PATH.
YMMV
Later,
Andy
-
Yada, yada, yada...
The information contained in this
Craig
Not sure how it works under HP-UX
but did you setup the DB2 environment for the account who is starting your
script
like
DB2DIR=/opt/IBM/db2/V8.1
DB2INSTANCE=db2inst1
INSTHOME=/home/db2inst1
..
and a few other things.
Usually this is done by calling the db2profile script from within
Allan Juul wrote:
i have tried all combs of use/no bytes and use/no utf8
to me it looks like my chars get altered around the execute method:
this trace exeample is one single danish letter
æ
which get converted to
æ
Try: perldoc Encode
use Encode;
my $new_text = encode('iso-8859-15',
æ are probably 2 bytes representing utf8 encoding for æ.
Try
use Unicode::String;
my $u = utf8($word);
$word = $u-latin1();
before insertion
-Original Message-
From: Allan Juul [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 5:58 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Everyone was right! I set the vars and now at least DB2 is rejecting
connection. That is another issue but I will send a different thread.
Thanks for the help,
Craig A. Sharp
Unix Systems Administrator
DNS Administrator
Security Administrator
Roush Industries
Office: 734-466-6286
Cell:
I now have the connect to db2 trying to work. We run HP-UX 11.00 and
DB2 runs in memory windows. In order to connect, I have to use db2win
to communicate with the instance. Since DBD-DB2 is not connecting via
memory windows, I cannot get a connect to the database.
I do not see a way to force
It gives me Illegal character in prototype for main::ErrMsg : @_ at t/lib.pl line 254.
The line it is complaining about is:
sub ErrMsg (@_) { print (@_); }
I tried backing up from 1.2218 to 1.2217 and 1.2216 but same problem.
I'm working so I wonder if I did a 'force' before...
You can also make sure that mysql-config is in your path. Then DBD::mysql
should be able to extract the information that it is looking for.
Rudy
On Tue, 24 Jun 2003 [EMAIL PROTECTED] wrote:
Date: Tue, 24 Jun 2003 10:21:12 -0500
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL
Spencar McCaa wrote:
Has any figured how to get around this error.
failed: ORA-06401: NETCMN: invalid driver designator (DBD ERROR:
OCIServerAttach)
http://www.google.com/search?hl=enq=ORA-06401+dbd%3A%3Aoracle
--
Andy Hassall ([EMAIL PROTECTED]) icq(5747695) (http://www.andyh.co.uk)
Cheers problem fixed Many Thanks Clinton
- Original Message -
From: Martin J. Evans [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 6:30 PM
Subject: RE: [dbi] Time Field M$ Access
I could be wrong but I think it is the ':' in the time that is causing the
problem.
Thanks Jeff
for opening up a wonderful opportunity. PPM doesn't seem to bring t files.
So I've never heard of them. Now I'm scurrying around looking for them in
other modules. What a great resource!
Regards
Clinton
- Original Message -
From: Jeff Urlwin [EMAIL PROTECTED]
To: 'Clinton'
Hi List
I'm tring to insert a timestamp
Using DBI 1.14, ActiveState 5.6, Access 2000
SQL =INSERT INTO tblCar (date_now,time_now) VALUES
(#06/23/2003#,#16:13#)
Results in
DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft
Access Driver]COUNT field incorrect (SQL-07001)(DBD:
23 matches
Mail list logo