Date/time conversion with DBD::ODBC and Access database

I posted this last week but didn't get a single reply. I thought someone could at least give me a clue about where to look. Using DBD::ODBC with MS Access 97 (not my choice but that's where the data is). The database has date_of_birth in a date/time field with -MM-DD as the Access display form

Early Query on date/time functions

I found sort of a solution to my query which involved calling an ODBC function (actually I am very new to this level of ODBC and learned that there are a set of functions supported. I tried using {fn MONTHNAME(Date_of_Birth)} for a test and it worked. The only problem I see now is the it always see

RE: Date/time conversion with DBD::ODBC and Access database

AM To: 'Dennis M. Gray'; [EMAIL PROTECTED] Subject: RE: Date/time conversion with DBD::ODBC and Access database > > > I posted this last week but didn't get a single reply. I > thought someone could at least give me a clue about where to look. How about google. Wi

RE: Remote MS ODBC connection syntax? (Maybe OT?)

The syntax is ...'DBI:ODBC:DSName...' where DSName is the data source name you previously defined for the ODBC connection. It's under Control Panel/Administrative tools for XP and various other places for other OSs. The name or name or IP address of the remote host is specified when you configure t

RE: ODBC + MSAccess + Perl + Linux or FreeBSD question.

David, There are many issues that must be considered before one can make a generalised statement that the data should be transferred. I am not especially fond of MS Access as a DBMS but it has a reasonable UI and can link to other databases via ODBC. In my situation, I develop test data on an Orac

RE: Why won't my script terminate?

When faced when a similar problem I killed the script, ran it again and it worked fine. It usually happens at the end of the day when I want to go home but run the script just one more time. I think a table lock or network problems could be a reason too but would be interested in the results of Ti

RE: getting table structure out of MS-Access

It worked just fine for me with no changes. Dennis -Original Message- From: David N Murray [mailto:[EMAIL PROTECTED] Sent: Thursday, 25 March 2004 2:38 PM To: Bart Lateur Cc: [EMAIL PROTECTED] Subject: Re: getting table structure out of MS-Access I thought this worked, but when I test

dbish under Windows

The Programming the Perl DBI book talks about dbish but I don't seem to find it in my Windows installation. -- Dennis M. Gray Far East Information Resources Pty. Ltd. 91 Queen Street BEACONSFIELD NSW 2015 AUSTRALIA Sydney Phone: (02) 9310 7907 Sydney Fax: (02) 9310 7917 M

RE: dbish under Windows

I thought it should have been there but I have installed AS Perl on work and home systems and dbish wasn't there. I installed from PPM last night. Dennis -Original Message- From: Vonnahme, Nathan [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 4:18 AM To: Dennis M. Gray; [

Installing dbish causing problems

toformat.pm line 9. Compilation failed in require at C:\Perl\bin\ppm3-bin line 12. BEGIN failed--compilation aborted at C:\Perl\bin\ppm3-bin line 12. Anyone know what I should do next? -- Dennis M. Gray Far East Information Resources Pty. Ltd. 91 Queen Street BEACONSFIELD NSW 2015 AUSTRALIA Sydney Phone

RE: Installing dbish causing problems

I was about to re-install ActiveState Perl, opened the Control Panel and saw there was a repair button so I tried that first. I can run ppm and dbish now. Dennis -Original Message- From: Bart Lateur [mailto:[EMAIL PROTECTED] Sent: 02 April, 2004 8:07 PM To: Dennis M. Gray Cc: [EMAIL

Perl and SSA_NAME3 software

I'm looking for someone with experience in using Perl with SSA_NAME3 software, any DBI. Thanks, Dennis

DBD::ODBC Connection no longer working

scripts and data\DATA\DENNIS\make_request.pl line 18. -- Dennis M. Gray Far East Information Resources Pty. Ltd. 91 Queen Street BEACONSFIELD NSW 2015 AUSTRALIA Sydney Phone: (02) 9310 7907 Sydney Fax: (02) 9310 7917 Mobile: (0418) 646267 Canberra Phone: (02) 6258 7917

Source for DBD-Oracle.ppd file

I am having trouble finding an archive with the latest DBD-Oracle. Can someone point me to a reliable source? Regards -- Dennis M. Gray Far East Information Resources Pty. Ltd. 91 Queen Street BEACONSFIELD NSW 2015 AUSTRALIA Sydney Phone: (02) 9310 7907 Sydney Fax: (02) 9310 7917 Mobile

Same error again with ppm

I had this error before but don't recall what I did to solve it: "break_at" is not exported by the Text::Reform module Can't continue after import errors at C:/Perl/site/lib/Text/Reform.pm line 43 BEGIN failed--compilation aborted at C:/Perl/site/lib/Text/Autoformat.pm line 9. Compilation failed i