Installing DBI under win32

Hey my name is Geoffrey and I am trying to get the DBI module and/or DB_File module to work under win32 for perl programming purposes. I can't seem to find out how to do it. Could somebody help? Thanks.

RE: Oracle & DBI

Also, set DBI trace and post the results ( inline with your email not as an attachment or it will get removed by the listserver) DBI->trace( 2, "script_name.trace" ); > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Tony Foiani > Sent: Friday, Febr

Oracle & DBI

I've tried everything I can think of to get placeholders to work in a select statement through DBI. We're using Oracle 8.1.5, DBD-Oracle 1.06, DBI 1.14, perl 5.004_04, all running under Solaris 2.8. Placeholders (i.e. ?) work fine in inserts, just not selects. For example, $sth = $dbh->prepare

Re: MySQL Limit Clause/MS-SQL 7 Equivalent

Justin Kelley writes: > I know that in MySQL there is a LIMIT Clause (LIMIT 21,30). MS SQL however, > appears to have no equivalent that I have found. Does anyone know > differently or have an answer for this problem? The only other I've found > suggests using unique ID numbers and using a

MySQL Limit Clause/MS-SQL 7 Equivalent

Hello all, I'm connecting to MS SQL 7 via perl using DBD:ODBC and openlink. I'm returning massive amounts of data through it which and its slowing the loading of webpages down massively so I don't want to use the perl to cut off the first however many results when I go to a next screen. (for ex

Re: use strict

To see for yourself how much you want to use strict, write a large ap without it, then add it in and see what pops up. Its amazing how many silly mistakes it prevents. I've written aps where I forgot it initially and when I installed it it was a nightmare to go back and fix everything. Even mo

Re: use strict

On Fri, 2 Feb 2001, Stewart, Clay wrote: > What are the exact disadvantages of not placing 'use strict' when using DBI > with DBD::Oracle ? > > I read a lot everywhere to 'use it or else', 'always use it', 'you really . > . . really should use it' . . . but have not been able to find an > explana

Re: use strict

it helps you find bugs in your code. it makes run time errors into compile time errors. it has saved me a lot of time at work. marc - Original Message - From: "Stewart, Clay" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 9:54 AM Subject: use strict > What a

use strict

What are the exact disadvantages of not placing 'use strict' when using DBI with DBD::Oracle ? I read a lot everywhere to 'use it or else', 'always use it', 'you really . . . really should use it' . . . but have not been able to find an explanation of why in detail. Thanks. Clay Stewart Sr. We

RE: DBI code problem!

snip 8< It creates table 'employees', but can't do insert in this table. What is wrong?! If this table is create and populate will be recognize by Oracle, SQL as SQL table, or I have to use DBD::Oracle? Thanks for any help! Livia The DBD::CSV module actually just creates another .csv file, b

RE: DBI code problem!

I'm just guessing, but I'd say that you can't insert because 1) you have called $dbh->disconnect() before doing your inserts and 2) you haven't opened the filehandle CSV that you are trying to read from -Original Message- From: TIBA, LIVIA [mailto:[EMAIL PROTECTED]] Sent: Friday, Februar

Re: DBI code problem!

Livia, see my comments below... TIBA, LIVIA [[EMAIL PROTECTED]] wrote: > Hi, > Could someone help me with this code?! > > ## > # Read a CSV file with "," as the separator, as exported by > # MS Excel. > ## > require DBI; > my $dbh = DBI->connect("

Re: DBI code problem!

On Fri, 2 Feb 2001, TIBA, LIVIA wrote: > ## > # Read a CSV file with "," as the separator, as exported by > # MS Excel. > ## You should also have 'use strict'. > require DBI; > my $dbh = DBI->connect("DBI:CSV:"); > $dbh->{'csv_tables'}->{'employee

Re: DBI code problem!

it appears that you called '$dbh->disconnect' alittle prematurely. move this method to the end of your code block and all should work "TIBA, LIVIA" wrote: > Hi, > Could someone help me with this code?! > > ## > # Read a CSV file with "," as the separator, as exported b

DBI code problem!

Hi, Could someone help me with this code?! ## # Read a CSV file with "," as the separator, as exported by # MS Excel. ## require DBI; my $dbh = DBI->connect("DBI:CSV:"); $dbh->{'csv_tables'}->{'employees'} = { 'eol' => "\n", 'sep_char'

Re: Report for Oraperl

If you are writing new code, you'd be better off using the DBI method calls instead of the Oraperl ones. Under Perl 5, Oraperl is just an emulation layer over DBI and DBD::Oracle. The people here, including me, are more likely to be able to help with DBI calls. I'm not sure I understand what is