Re: help please

, October 03, 2007 4:06 AM Subject: Re: help please Ron Savage wrote: Samuel_Zheng wrote: Hi Sam Hi, Can Somebody help me?This is my perl scrip:#!/usr/local/bin/perl use Sorry, but no. This is a DBI-related mailing list, and for your post to be relevant you'd have to tell us what why you think

Re: help please

Hi, Can Somebody help me?This is my perl scrip:#!/usr/local/bin/perl use CGI;use CGI::Carp fatalsToBrowser;use DBI;use strict;my $q = new CGI;my $fname;my $sql;my $ordnum=$q-param('ordernum');my $usertype=$q-param('usertype');my $starter =STARTER;htmlheadtitle綪扳虫/titlemeta

Re: perl date

: Nelson, Erick [HDS] [EMAIL PROTECTED] To: Samuel_Zheng [EMAIL PROTECTED] Sent: Wednesday, August 29, 2007 11:53 AM Subject: RE: perl date [EMAIL PROTECTED]:/home/erickn perl test.pl 1 = 20071202 [EMAIL PROTECTED]:/home/erickn cat test.pl use strict; use warnings; use DBI; use DBD::XBase; my

Re: perl date

] To: Samuel_Zheng [EMAIL PROTECTED] Sent: Wednesday, August 29, 2007 11:53 AM Subject: RE: perl date [EMAIL PROTECTED]:/home/erickn perl test.pl 1 = 20071202 [EMAIL PROTECTED]:/home/erickn cat test.pl use strict; use warnings; use DBI; use DBD::XBase; my $xbase_dbh = DBI-connect(DBI:XBase:., undef

Re: perl date

I see now the file location should be specify after DBI:XBase:, not in front of the file name. Thank you. Samuel - Original Message - From: Nelson, Erick [HDS] [EMAIL PROTECTED] To: Samuel_Zheng [EMAIL PROTECTED] Sent: Wednesday, August 29, 2007 11:53 AM Subject: RE: perl date

Re: perl date

Hi Nelson, Thanks for the codes. Please forgive my ignoracne, but how to update a date field in dbf ? thanks again. Samuel - Original Message - From: Nelson, Erick [HDS] [EMAIL PROTECTED] To: Samuel_Zheng [EMAIL PROTECTED] Sent: Tuesday, August 28, 2007 6:43 PM Subject: RE: perl date

perl date

Hi, I am using ODBC to convert an old clipper application to a web based application and I came across something seems simple but it's not. how can I save a date from perl to a date field in dbf file? can a perl expert helps out someone who is novice in perl like me? your help would be very

Re: DBI DBD-ODBC

Thank you Martin. Do you mean I should be using '*' for MSAccess file? - Original Message - From: Martin Evans [EMAIL PROTECTED] To: dbi-users dbi-users@perl.org Sent: Monday, August 20, 2007 4:43 AM Subject: Re: DBI DBD-ODBC Samuel_Zheng wrote: Martin, I did as you suggested

Re: DBI DBD-ODBC

I am having almost the same error on a windows 2003 server. Same set of scripts run fine on a Windows XP, the following is the error: DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access Driver] 囀湔祛堤 (SQL-22018)(DBD: st_execute/SQLExecute err=-1) at c:\web\factory.pl line 61. it

Re: DBI DBD-ODBC

of is the permision issue. BUT proper rights are given to the a/c runs the script. Samuel - Original Message - From: Martin Evans [EMAIL PROTECTED] To: dbi-users dbi-users@perl.org Sent: Wednesday, August 15, 2007 8:26 AM Subject: Re: DBI DBD-ODBC Samuel_Zheng wrote: I am having

Re: DBI DBD-ODBC

the server. Samuel - Original Message - From: Martin Evans [EMAIL PROTECTED] To: dbi-users dbi-users@perl.org Sent: Wednesday, August 15, 2007 10:59 AM Subject: Re: DBI DBD-ODBC Samuel_Zheng wrote: Thank you Martin for your response. 囀湔祛堤 is not readable, no one knows what it means. refno

Re: DBI DBD-ODBC

Thanks Ron. Problem fixed, I was able to run the script after I deleted the DNS server I tried to setup. (silly me) - Original Message - From: Ron Savage [EMAIL PROTECTED] To: dbi-users@perl.org Sent: Wednesday, August 15, 2007 7:59 PM Subject: Re: DBI DBD-ODBC Hi Sam Thank you

Re: DBI DBD-ODBC

- Original Message - From: Martin Evans [EMAIL PROTECTED] To: dbi-users dbi-users@perl.org Sent: Wednesday, August 15, 2007 10:59 AM Subject: Re: DBI DBD-ODBC Samuel_Zheng wrote: Thank you Martin for your response. 囀湔祛堤 is not readable, no one knows what it means. refno is a string type

error on a windows 2003 serv er

Hi, How can I allow my perl scripts to read an ODBC pointing to a access97 file? Can someone give me something to try? thanks in advanced. Everytime my script tries to read the file, it failed. it displays some unreadable characters and the error is SQL4200. Same set of script runs fine on a XP

Re: error

Sent: Wednesday, August 01, 2007 3:20 AM Subject: Re: error Samuel_Zheng wrote: this is the error message, Because it on a Chinese 2003 server and the chinese is missing some bytes. I cannot read what it says. Does anyone can tell what it means and suggest things to try? thanks, samuel

Re: dbi access ODBC

Hi Jenda, I think you are on the right direction. It is a brand new server running windows server 2003. It has not been accessed by anyone yet. The scripts were developed using a WindowsXP and it dose not have the any right issues. on the server, I don't know the a/c to create and try, please

dbi access ODBC

Hi Martin, you directed me to an article by microsotf to fix an error which is caused when my perl script access a access97 file.The article tell to chk the windows temp folders. that time I got the problem fixed on my XP machine. This time, I am having the same error on a windows server 2003.

Fw: dbi access ODBC

Hi Martin, the error is different this time. It said SQL-42000, please help! - Original Message - From: Samuel_Zheng To: dbi-users@perl.org Sent: Tuesday, July 31, 2007 11:04 PM Subject: dbi access ODBC Hi Martin, you directed me to an article by microsotf to fix an error which

error

this is the error message, Because it on a Chinese 2003 server and the chinese is missing some bytes. I cannot read what it says. Does anyone can tell what it means and suggest things to try? thanks, samuel Software error: DBI connect('btn','',...) failed: [Microsoft][ODBC Microsoft Access

DBF DBI

Hi, I am using activeperl 5.8.8 and DBI 1.58. If I want to use DBI to work with a legacy clipper application, meaning to update the index files, so the clipper application can continue to work. what module is available out there? Anyone has some success stories to share about using perl side

DBI and DBF Files

Hi Gurus, I need your help. I am using active perl 5.8.8, windowsXP second edition. I am trying to access an old app by using perl and odbc. I created a system DSN in ODBC data source administrator and I tested by using crstal report writer. Things are fine. I use DBI (1.58 dbd-odbc is 1.13)

Re: (Fwd) dbi help

Martin from easysoft has pointed me to the right direction and have the issue resolved. Thanks the dbi and odbc. They made Perl so much more powerful! - Original Message - From: Tim Bunce [EMAIL PROTECTED] To: dbi-users@perl.org Cc: [EMAIL PROTECTED] Sent: Sunday, July 15, 2007 5:24