RE: How to check a DBI installation?

2002-07-18 Thread Mark Charshaf
Here is what I use to check things out on my Perl installation. Mark use strict; use DBI; # List directories in @INC. foreach my $dir (@INC) { print "$dir\n"; } print "DBI Version $DBI::VERSION\n"; # ### Probe DBI for the installed drivers my @drivers = DBI->available_drivers(); ### Iterate t

RE: MS Access

2002-06-25 Thread Mark Charshaf
Below is a reply I made to someone wanted to access Oracle on NT from a Linux box (client perl pgm). The same situation could apply to accessing MS Access from a Unix or Linux machine. Why fool around with installing ODBC drivers on Unix/Linux when you have a great pass-through facility like DBI:P

RE: Using Linux and Perl to Access Oracle on NT

2002-06-21 Thread Mark Charshaf
I have a similar situation here with my Oracle 8i database residing on W2k and my client Perl program running on a Linux/RedHat 7.2 machine. After reading about how DBI:Proxy works, I took the existing Perl program and changed the connect to look like this: ### Build Connect Parame

RE: best way to insert date/time into oracle table

2002-06-14 Thread Mark Charshaf
Some date inserts I have experience with regarding Oracle and mssql (if this helps). Mark --Oracle insert into order_details (OrderID, ProductID, UnitPrice, Quantity, Discount, OrderDate, ProductName) VALUES (5,1,1,1,1,TO_DATE ('4/01/1953', 'MM/DD/'),'name') ; --mssql insert into "order

Best pa\lace to get started with DB2 7.1 and Perl on Linux?

2002-05-05 Thread Mark Charshaf
Hello, I just installed DB2 v7.1 (PE) on my RedHat Linux machine. I'm familiar with ADO on the Microsoft side with connecting to various DB's, but I'm very new to the Linux/Unix programming side. Where is the best place for a intermediate Perl programmer type to pick up on the DBI information rel