Time Field M$ Access

2003-06-26 Thread 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:

Re: Use of inherited AUTOLOAD for non-method DBI::DESTROY() is deprecated

2003-06-26 Thread William R Ward
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

Oracle Error

2003-06-26 Thread Spencar McCaa
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

Using perl for oracle db administration

2003-06-26 Thread Walker, Chris
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?

Re: Trouble using IPC adapter with Oracle 8

2003-06-26 Thread maddlework
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

RE: [dbi] Time Field M$ Access

2003-06-26 Thread Martin J. Evans
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

Re: Rounding errors storing numbers in MySQL text fields using DBI

2003-06-26 Thread Tim Bunce
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.

URGENT: DBD-DB2 Compile problems

2003-06-26 Thread Craig Sharp
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

Re: inserting special characters

2003-06-26 Thread Allan Juul
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

DB2 Total environment allocation failure on HP-UX

2003-06-26 Thread Craig Sharp
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

Re: DB2 Total environment allocation failure on HP-UX

2003-06-26 Thread johnnnnnn
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

RE: DB2 Total environment allocation failure on HP-UX

2003-06-26 Thread andy law (RI)
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

Re: DB2 Total environment allocation failure on HP-UX

2003-06-26 Thread Swen Schillig
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

Re: inserting special characters

2003-06-26 Thread Jonathan Leffler
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',

RE: Re: inserting special characters

2003-06-26 Thread Igor Korolev
æ 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]

Re: DB2 Total environment allocation failure on HP-UX

2003-06-26 Thread Craig Sharp
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:

DBD-DB2 No connect with HP-UX DB2WIN

2003-06-26 Thread Craig Sharp
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

error compiling DBD::mysql

2003-06-26 Thread Greg.Hering
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...

RE: PERL/DBI Help

2003-06-26 Thread Rudy Lippan
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

Re: Oracle Error

2003-06-26 Thread Andy Hassall
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)

Thanks Martin Re: [dbi] Time Field M$ Access

2003-06-26 Thread Clinton
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.

Re: Time Field M$ Access

2003-06-26 Thread Clinton
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'

RE: Time Field M$ Access

2003-06-26 Thread Jeff Urlwin
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: