>-Original Message-
>From: Jeff Urlwin [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, August 23, 2001 6:27 AM
>To: Neil Lunn; 'Timothy C. Phan'; [EMAIL PROTECTED]
>Subject: RE: [Patch] RE: DBD-ODBC 0.28 for Cygwin
>
>
>Neil,
>
>To confirm: you don
Terry,
I am going to answer your question in the braod strokes rather than in the
context of you message as this seems to have a need to be said.
There seems to be a gross misunderstanding in the community in general of
what exactly ODBC and therefore DBD::ODBC is.
Questions like this frequent
Allen,
It might help if you told people which version of perl you were using and
for which platform.
It seems like you statements though at least say something. You should never
run test.pl.
What you should be doing is:
perl Makefile.PL
make
make test
make install
as per the standard perl modu
>-Original Message-
>From: NYIMI Jose (BMB) [mailto:[EMAIL PROTECTED]]
>Sent: Saturday, August 18, 2001 1:02 AM
>To: '[EMAIL PROTECTED]'
>Subject: Remote DB Connection
>
>
>How I can connect to a remote Informix database ?
>
>The database from which I would like to extract
>data (a simple
is probably the cause you should use {
RaiseError => 1} in the attributes of your database connection.
--Neil
>Regards
>CCJ
>- Original Message -
>From: "Neil Lunn" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Friday, August 17, 2001 3:2
>-Original Message-
>From: Clinton [mailto:[EMAIL PROTECTED]]
>Sent: Friday, August 17, 2001 3:11 PM
>To: [EMAIL PROTECTED]
>Subject: Wildcards
>
>
>My problem is if I run the query from perl I get no response -
>the program
>runs to completion with no errors (using strict and w).
>
>my $
That's the fourth time. Enough is enough. Stop posting this. Someone will
answer [maybe] in their own time.
Perhaps you may think that prodding a tiger with a stick is also a wise
thing to do?
--Neil
>-Original Message-
>From: Falk [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, August 16,
>-Original Message-
>From: gopinath r [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, August 15, 2001 4:52 PM
>To: [EMAIL PROTECTED]
>Cc: [EMAIL PROTECTED]
>Subject: Database connection
>
>
>Hello
>
>I have some doubts about connecting oracle 8.4
>database from perl 5
>
>I installed Indigoper
>-Original Message-
>From: Bart Lateur [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, August 14, 2001 8:30 PM
>To: [EMAIL PROTECTED]
>Subject: Re: Removing duplicate records - OT
>
>
>On Tue, 14 Aug 2001 11:12:23 +1000, Neil Lunn wrote:
>
>>Use something l
>-Original Message-
>From: Jon Barker [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, August 14, 2001 8:28 PM
>To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
>Subject: Re: SQL Statement - Selecting details if they exist if not...
>
>
>
>I'm not completely sure I understand you but:-
>
>select * fro
>-Original Message-
>From: Konstantin [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, August 14, 2001 5:38 PM
>To: [EMAIL PROTECTED]
>Subject: rollback
>
>
>Hi.
>
>I'm trying to use the rollback function but I get the error:
You've been moved to dbi-users where this sort of enquiry belongs.
While I can read that the person who posted this message has solved their
issue, this might be worthwhile still.
One thing I notice is that all responses are processing very record to see
if a duplicate record is there. Hopefully though the database server is a
little more powerful than the machi
>-Original Message-
>From: Falk [mailto:[EMAIL PROTECTED]]
>Sent: Friday, August 10, 2001 6:15 PM
>To: [EMAIL PROTECTED]
>Subject: ActivePerl DBI Setup
>
>
>Hi,
>I'm using Active Perl on WinNT.
>I tried to setup the DBI Module - so far without success. I tried make,
>nmake, ppm.
>None of
>-Original Message-
>From: Veeresh [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, August 09, 2001 2:36 PM
>To: [EMAIL PROTECTED]
>Subject: Can't locate DBD/Oracle.pm
>
>
>Hi All,
>I'm using the Oracle 8.1.6 version. I was trying to run the
>Perl script i got this error.
>
>install_driver(
>-Original Message-
>From: Tim Bunce [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, August 08, 2001 8:58 PM
>To: Neil Lunn
>Cc: 'Timothy C. Phan'; [EMAIL PROTECTED]; Jeff Urlwin
>Subject: Re: [Patch] RE: DBD-ODBC 0.28 for Cygwin
>
>
>Can't th
>-Original Message-
>From: Veeresh [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, August 08, 2001 2:07 AM
>To: [EMAIL PROTECTED]
>Subject: "Can't locate loadable object for module DBI "
>
>Then I installed the DBI.pm as per instructions in the
>website.The following
> is the result
>
>Ca
Hmm. Not really a DBI question but I feel charitable. Beside this might stop
people asking in the future. See the code below.
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, August 08, 2001 12:50 PM
>To: [EMAIL PROTECTED]
>Subject: Exporting Data
> I have this problem during 'make test'. Is it good/bad? Thanks
>
>t/02simple..ok 7/14DBD::ODBC::st fetchrow failed:
>[Microsoft][ODBC
>Micro
>soft Access Driver]String data, right truncated on column number 2 (C)
>(SQL-0100
>4)(DBD: st_fetch/SQLFetch (long truncated) err=1) at
>t/02s
>-Original Message-
>From: Jonathan Leffler [mailto:[EMAIL PROTECTED]]
>Neil Lunn wrote:
>
>> It's off by defualt. But the documentation should help more here.
>
>Are you sure? I think you'll find it is on by default,
>because that's the onl
>-Original Message-
>From: Timothy C. Phan [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, August 07, 2001 6:20 AM
>To: [EMAIL PROTECTED]
>Subject: RE: DBD-ODBC 0.28 for Cygwin
>
>
>Hi,
>
> I'm actually using ActiveState Perl for a couple of years now.
> I, however, wanted to try diff versio
It's off by defualt. But the documentation should help more here.
--Neil
>-Original Message-
>From: Anurag Minocha [mailto:[EMAIL PROTECTED]]
>Sent: Saturday, August 04, 2001 4:33 AM
>To: [EMAIL PROTECTED]
>Subject: Turning autocommit off
>
>
>Hi,
>How do i turn off autocommit in dbi::Or
Yes. While the soolution below is correct it might help to tell the person
who oringally posted this question why they where getting an error.
The difference is in:
$sth = $dbh->do("insert "
$sth->bind_param(" ...
and
$sth = $dbh->prepare("insert
$sth->bind_param(" ...
Essentially th
>If I use something like:
>my $data= $sth->fetchall_arrayref;
> foreach (@$data){
> print qq(@$_);
> }
>
>
>I get all the data, but how the hell do I access the specific
>elements in
>this array of arrays? Is there a better fetch method to use?
my $data = $sth->fetchall_arrayref;
# Prin
Use ppm for ActiveState perl.
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, July 31, 2001 3:34 PM
>To: [EMAIL PROTECTED]
>Subject: DBI on Win2k
>
>
>Hi all,
>
>I have installed ActivePerl on windows 2000 and want to
>install and configure DBI mod
Then use a dsnless connection. Look at perldoc DBD::ODBC for the examples
(connecting to Access) that are already listed.
--Neil
>-Original Message-
>From: Michael Blackmore [mailto:[EMAIL PROTECTED]]
>Sent: Monday, July 30, 2001 10:51 AM
>To: [EMAIL PROTECTED]
>Subject: DBI::ODBC config
>> How can we get this information to the CPAN page that shows
>what systems
>> these modules have been tested with?
>
>I'm not sure what 'CPAN page' you're refering to.
>
Probably the input from CPAN testers. See http://testers.cpan.org and or
subscribe to [EMAIL PROTECTED] if you have a platfo
Check your installation. It is definately there.
--Neil
>-Original Message-
>From: Alex Algard [mailto:[EMAIL PROTECTED]]
>Sent: Saturday, July 14, 2001 9:16 AM
>To: [EMAIL PROTECTED]
>Subject: fetchall_hashref() - does/will it exist?
>
>
>I just downloaded DBI 1.18, and although the
>"
Looks like your make is broken. Get an update from your nearest mirror under
/pub/gnu
-Neil
>-Original Message-
>From: ARCS (Wade) [mailto:[EMAIL PROTECTED]]
>Sent: Friday, July 13, 2001 4:22 PM
>To: [EMAIL PROTECTED]
>Subject: Problems installing DBI 1.14 on SunOS 5.6 (Solaris 2.6)
>
>
>-Original Message-
>From: Farouk Khawaja [mailto:[EMAIL PROTECTED]]
>Sent: Friday, July 13, 2001 7:09 AM
>To: Sterin, Ilya; '[EMAIL PROTECTED] '
>Subject: RE: Compile problems with DBD::ODBC
>
>
>also, opt/odbc/lib is defined in LD_LIBRARY_PATH
Looks like the wrong driver manager. This
t;Manifying blib/man1/dbiproxy.1
>Manifying blib/man3/DBI::W32ODBC.3pm
>Manifying blib/man3/DBI::DBD.3pm
>Manifying blib/man3/DBD::Multiplex.3pm
>
>
>
>log-test
>-
>
>PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
>-I/usr/lib/perl5/5.6.0/i386-
The Script is fine so ther is something wrong with your installation. The
output of perl -V and the output of your DBI build would be helpful.
If you don't know how to do this:
tar zxvf DBI-x.xx.tar.gz
cd DBI-x.xx
perl Makefile.PL 2>&1 | tee log-conf
make 2>&1 | tee log-make
make test 2>&1 | tee
You will do better to post an example of your script, the actual error
message(s) received, and the output of perl -V, as is suggested in the
documentation.
You are running your script with -w aren't you!
--Neil
>-Original Message-
>From: anshuman das [mailto:[EMAIL PROTECTED]]
>Sent:
>-Original Message-
>From: Deng Ruijie [mailto:[EMAIL PROTECTED]]
>Sent: Monday, July 02, 2001 6:26 PM
>To: [EMAIL PROTECTED]
>Subject: RE: compiling error
>
>
>Hi Neil Lunn,
>
>Following is the output for 'perl -V':
># perl -V
>Summ
Deng Ruijie [mailto:[EMAIL PROTECTED]]
>Sent: Monday, July 02, 2001 5:49 PM
>To: 'Neil Lunn'
>Subject: RE: compiling error
>
>
>Hi Neil Lunn,
>
>Thank a lot for your promtp reply.
>
>You mean the error will disappear if I install a newer version of perl?
>
Old Perl in your path!
>/bin/perl -I/usr/perl5/5.00503/sun4-solaris -I/usr/perl5/5.00503
^^^
>-Original Message-
>From: Deng Ruijie [mailto:[EMAIL PROTECTED]]
>Sent: Monday, July 02, 2001 4:23 PM
>To: [EMAIL PROTECTED]
>Subject: compiling error
>
>
>Hi everyb
>-Original Message-
>From: Chad [mailto:[EMAIL PROTECTED]]
>Sent: Monday, June 25, 2001 8:47 AM
>To: [EMAIL PROTECTED]
>Subject: CachedKids Attribute need help understanding
>
>
>I've just started implementing prepare_cached into my scripts
>and my code is
>similar to the example in the b
>-Original Message-
>From: Christine Kluka [mailto:[EMAIL PROTECTED]]
>Sent: Saturday, June 23, 2001 1:29 AM
>To: Rudy Lippan
>Cc: Ronald J Kimball; Chase Michael A.; Neil Lunn; [EMAIL PROTECTED]
>Subject: Re: DBI Connect Failure
>
>
>Rudy,
>
>I'm
>-Original Message-
>From: Christine Kluka [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, June 20, 2001 8:25 PM
>To: Ronald J Kimball
>Cc: [EMAIL PROTECTED]
>Subject: Re: DBI Connect Failure
>
>
>Ronald,
>
>Thanks for your reply. I:
>- declared $i=0; -- it still fails to import
That means
Try looking at the output from the Proxy Server using --debug and use DBI
trace on the client. This should tell you some more.
--Neil
>-Original Message-
>From: Douglas Smith [mailto:[EMAIL PROTECTED]]
>Sent: Friday, June 15, 2001 4:25 AM
>To: [EMAIL PROTECTED]
>Subject: Help- DBI::Prox
Check your Informix licencing requirements and dependancies for ESQL/C for
more information on this. You are also subject to the same criteria for Perl
and other modules as stated in the Perl Artistic licence and/or other
licence statements submitted with those modules.
--Neil
>-Original Mes
Contact ActiveState. But I would suggest ppm verify --upgrade DBI should
work.
--Neil
>-Original Message-
>From: John [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, June 13, 2001 8:35 PM
>To: [EMAIL PROTECTED]
>Subject: DBI and Perl 5.6.1.62x Application Error
>
>
>Suddenly Perl doesn't wo
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, June 13, 2001 6:29 PM
>To: [EMAIL PROTECTED]
>Subject: Strange Warning
>
>
>Hi,
>
>I get a strange warning in the following part of my code:
>
> my @zeile;
> while (@zeile = $sth->fetchrow_array())
> -Original Message-
> From: Michael A. Chase [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 08, 2001 1:50 PM
> To: Pei Du; [EMAIL PROTECTED]
> Subject: Re: install DBI problem
>
>
> It looks like you are using ActiveState Perl. If you are, use PPM to
> install DBI and DBD::xxx. The i
> -Original Message-
> From: Chouda, Prem [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 08, 2001 6:31 AM
> To: 'Sterin, Ilya'; 'Edward J. Sabol '; '[EMAIL PROTECTED] '
> Subject: RE: Anyone else experiencing problems with the dbi-* mailing
> list s?
>
>
> I am with Ilya.
> I am not fa
You realise you just posted to dbi-users when your not even using DBI!
You should be though. Look for the DBI and DBD-ODBC packages. There is a
slightly different syntax to use but get used to it.
On the other hand, this is perfectly viable for discussion here. Your JOIN
syntax is wrong and prett
Make is broken on AIX. Download gnu-make from your nearest mirror.
--Neil
> -Original Message-
> From: Tobias Hausmann [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 07, 2001 8:03 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: DBD-Oracle 1.0.7/AIX make problem
>
>
> Hi,
>
> -Original Message-
> From: Bart Lateur [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 07, 2001 7:48 AM
> To: mailing list
> Subject: Re: I want to unsuscribe
>
>
> On Wed, 6 Jun 2001 12:09:11 -0700 , Wilson, Doug wrote:
>
> >You have to remember, though, that alot of us use crippl
> -Original Message-
> From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 04, 2001 1:02 PM
> To: Neil Lunn; 'Guangzu Wang (Houston)'; [EMAIL PROTECTED]
> Subject: RE: Only return the FIRST field from DBD/ODBC/Sql
> Server stored
> pr
> -Original Message-
> From: Guangzu Wang (Houston) [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 04, 2001 3:57 AM
> To: [EMAIL PROTECTED]
> Subject: Only return the FIRST field from DBD/ODBC/Sql Server stored
> proce dure
>
>
> I use DBD::ODBC with Easysoft ODBC bridge to connect SQL
Unless fetchrow_array is in a loop that would imply to me that there are
more results to fetch. If it is in a loop, is it possible there is a loop
exit before all results are fetched?
-- Neil
> -Original Message-
> From: Hèctor Alòs i Font [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May
> -Original Message-
> From: Richard Castrios [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 15, 2001 3:14 AM
> To: '[EMAIL PROTECTED]'
> Cc: '[EMAIL PROTECTED]'
> Subject: Problems installing DBI on HP-UX 11.0 w/Perl 5.6.1
>
>
> Hello,
>
> I am getting the following error message whe
Well you did't say what the error was. Try this and at least you should get
an error that tells you something about why connect is failing.
use DBI; my $dsn = 'DBI:mysql:my_database:localhost';
my $db_user_name = 'admin';
my $db_password = 'secret';
my $dbh = DBI->connect($dsn, $db_user_name, $
perldoc DBD::ODBC
Connect without DSN The ability to connect without a full DSN is introduced
in version 0.21.
Example (using MS Access):
my $DSN = 'driver=Microsoft Access Driver
(*.mdb);dbq=cheese\\g$\\perltest.mdb';
my $dbh = DBI->connect("dbi:ODBC:$DSN", '','')
or die "$DBI
-
> From: Neil Lunn [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 11, 2001 2:58 PM
> To: [EMAIL PROTECTED]
> Subject: RE: ODBC connects, but queries fail.
>
>
>
> > -Original Message-
> > From: Jack McKinney [mailto:[EMAIL PROTECTED]]
> > Sent: Friday
> -Original Message-
> From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 11, 2001 1:58 PM
> To: Jack McKinney; [EMAIL PROTECTED]
> Subject: RE: ODBC connects, but queries fail.
>
>
> But what driver are you using, ODBC is a layer on top of
> other drivers, like
> Access
> -Original Message-
> From: Jack McKinney [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 11, 2001 1:24 PM
> To: [EMAIL PROTECTED]
> Subject: Re: ODBC connects, but queries fail.
>
>
> Big Brother tells me that Sterin, Ilya wrote:
> > DBI->connect(Driver=/usr/local/lib/odbc-i02.so;Se...
> -Original Message-
> From: Jack McKinney [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 11, 2001 12:27 AM
> To: '[EMAIL PROTECTED] '
> Subject: Re: ODBC connects, but queries fail.
>
>
> Big Brother tells me that Sterin, Ilya wrote:
> > $driver = "driver={Microsoft Access Driver
> > (
> -Original Message-
> From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 10, 2001 2:29 PM
> To: Neil Lunn; 'Trevor Webster'; [EMAIL PROTECTED]
> Subject: RE: Problem with DBI and Access newbie
>
>
> Neil, not that I'm an Acces
> -Original Message-
> From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 10, 2001 2:26 PM
> To: Neil Lunn; 'Trevor Webster'; [EMAIL PROTECTED]
> Subject: RE: Problem with DBI and Access newbie
>
>
> >>$SQL = qq|INS
Missed this before. My eyes hurt! Answer Below.
> -Original Message-
> From: Trevor Webster [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 09, 2001 5:03 PM
> To: [EMAIL PROTECTED]
> Subject: Problem with DBI and Access newbie
>
>
> Hello
>
> I am running a Perl script that is suppos
Jack,
Just as an extra check. What do you get if you fully qualify the DSN in the
dbi connect string?
(that is, a DSN'less connection) ie "dbi:ODBC:driver= 'etc'"
Neil
> -Original Message-
> From: Jack McKinney [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 10, 2001 6:12 AM
> To: [EMA
> > As long and the words 'warn' and 'die' are listed in the
> documentation I
> > agree that this should be very clear.
> > Umm. Does that just mean in the docs or :
> >
> > -if (!raise_error || (diehook && SvOK(diehook)))
> > +if (!raise_error)
>
> The internal code is
> -Original Message-
> From: Tim Bunce [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 10, 2001 7:07 AM
> To: Sterin, Ilya
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: executing atomic transactions in DBI
>
>
> but now I've changed it to say:
>
> : If you turn C on then yo
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 10, 2001 6:14 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: (Fwd) Oraperl Binary for Windows
>
>
> Thanks a lot for that 3 * 10 ** 8 m/sec response :)
You do not actually use Apache::DBI in your script. Please Read the
documentation.
> -Original Message-
> From: Mikael Hansen [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 09, 2001 4:38 PM
> To: Perl DBI users
> Subject: Problem with require_version via package DBI
>
>
> Hi I have
What do you think you are doing? I've recieved this same mail three times
already, do you really expect that this will prompt someone to help faster?
Talk about poking an aligator with a stick!
Perhaps if you told people what exactly is different about your "binary
field" output, (And waited pait
> -Original Message-
> From: Shah, Deepak K [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 10:32 AM
> To: '[EMAIL PROTECTED]'
> Subject: database query fails when run with Perl
>
>
> Hello,
>
> We are running a query against an Oracle database using Perl.
> This query has
>
Should this really be discussed off the list? Abolutely not.
Ilya, your connect string in this script uses PrintError, as you knowingly
mention yourself. I thought that this was made very clear in the docs.
>From the fine Manual:
""PrintError"" (boolean, inherited)
This attribute can be use
> Sorry to interfere so late in this thread, but
>
> if the commit() is placed here, won't it be always executed, because
> there are no die statements which stop code execution upon errors
> before ? Shouldn't committing be made dependent of the value of $@
> like
>
> if ($@) {
> warn
use DBD::ODBC
Neil
> -Original Message-
> From: David Blaikie [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 03, 2001 8:24 AM
> To: [EMAIL PROTECTED]
> Subject: DBD driver for Filemaker Pro
>
>
> Hi All,
>
> does anyone know if there is a DBD driver for Filemaker Pro?
>
> David
>
Excuse me. But what exactly is your code. I hope your not looping over both
of those lines of code.
-- Neil
> -Original Message-
> From: jeff knot [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 03, 2001 8:14 AM
> To: [EMAIL PROTECTED]
> Subject: DBI buffer commit
>
>
> Hi,
> I am new
> -Original Message-
> From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 02, 2001 10:56 PM
> To: 'Simon Oliver '
> Cc: '''[EMAIL PROTECTED]' ' '
> Subject: RE: Extract data from MS Excel Spreadsheets. Can it be done?
>
>
> Also I would think that this is a big enough i
> -Original Message-
> From: PD Miller [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 30, 2001 6:31 PM
> To: Sterin, Ilya; Mike Schienle; [EMAIL PROTECTED]
> Subject: RE: Easiest way to tell if a table already exists?
>
>
> At 21:56 -0400 25/4/01, Sterin, Ilya wrote:
> >Why would (sele
The Archives are your freind:
http://www.xray.mpe.mpg.de/mailing-lists/dbi/
Ask your question here and you will get tons of information ie "msql server
from linux"
hint :
perldoc DBI::ProxyServer
perldoc DBD::Proxy
Neil
> -Original Message-
> From: Joel Divekar [mailto:[EMAIL PROTECTE
Where did this go? Any resolution? There is Something about the Dynaloader
for 5.00503 from memory. I'd suggest rebuilding for 5.6.1.
Neil
> -Original Message-
> From: Paul Scott [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 26, 2001 11:03 PM
> To: [EMAIL PROTECTED]
> Subject: Prob
> Big Brother tells me that Bodo Eing wrote:
> > Jack,
> >
> > > Help! I cannot get DBD::ODBC to work. I am
> connecting to the
> > > MSSQL 2000 database with:
> > >
> > > $db = DBI->connect("dbi:odbc:MSSQLTEST");
> > >
> >
> > In the first place, try connecting with the correct
> capital
Hmmn. This appears to be normal. The tests are only faling on data_sources
and ping methods so
the driver should be able to be used otherwise.
Perhaps this needs someone to look at iODBC, or a different approach to the
implementation in DBD::ODBC. Not really for this discussion. Simply note
that
> -Original Message-
> From: Mike McPherson [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 27, 2001 2:21 PM
> To: [EMAIL PROTECTED]
> Subject: RE: I need a hand
>
>
> /usr/src/odbcsdk
Are you sure the headers and libraries (compiled) are in include and lib
under *this* directory. I ha
Mike,
Could you attach the output of perl Makefile.PL and make:
perl Makefile.PL 2>&1 | tee log-conf
make 2>&1 | tee log-make
Neil
> -Original Message-
> From: Mike McPherson [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 27, 2001 2:38 PM
> To: [EMAIL PROTECTED]
> Subject: RE: I nee
Where have you set ODBCHOME to:
> -Original Message-
> From: Mike McPherson [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 27, 2001 1:03 PM
> To: [EMAIL PROTECTED]
> Subject: I need a hand
>
>
> I need a hand cause I can't seam to figure this out.
>
> As much info I can give here:
>
> both return a single row indicating success or failure. The last
> two return a row for each record in the table. You'd probably be
> less than thrilled if you have a few million records.
No these means do not return any rows. They return sucess or faliure with
initiating
a fetch. In fact no
> -Original Message-
> From: Thomas von Elling Skifter Eibner [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 25, 2001 7:27 AM
> To: Mark Riehl
> >
> > The New Riders MySQL book has the following statements:
> > SELECT COUNT(*) FROM table_name
> > SELECT * FROM table_name WHERE 1=0
>
> -Original Message-
> From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 26, 2001 6:18 AM
> To: 'Steve Starer '; '[EMAIL PROTECTED] '
> Subject: RE: Install question
> for it to work, but I don't know if OLE modules were ever
> ported to other
> platforms? I wouldn't
> -Original Message-
> From: Joern Reder [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 23, 2001 7:47 PM
> To: Peter R. Wood - Lists
> Cc: [EMAIL PROTECTED]
> Subject: Re: fetchrow returns only nonzero ints?
> Yes. Your while condition is the problem. The 0 value is
> interpreted as
> f
Hmm. Seems you're right. Try this:
while ( my $grade = $sth->fetchrow_arrayref )
{
push(@grades,$grade->[0]);
}
> -Original Message-
> From: Peter R. Wood - Lists [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 23, 2001 1:19 PM
> To: [EMAIL PROTECTED]
> Subject: fetchrow returns only
> -Original Message-
> From: Michael Peppler [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 18, 2001 8:42 AM
> To: Neil Lunn
> Cc: 'Kutler, Christopher '; ''DBI User Group' '
> Subject: RE: Complex SQL statments - Do they work?
>
&g
> -Original Message-
> From: Xiaoxia Dong [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 18, 2001 6:48 AM
> To: [EMAIL PROTECTED]
> Subject: update multi row when i meant update single row
>
>
> Dear all:
>
> I tried to update a single row for the database, however, the
> query he
> -Original Message-
> From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 18, 2001 2:56 AM
> To: 'Kutler, Christopher '; ''DBI User Group' '
> Subject: RE: Complex SQL statments - Do they work?
>
>
> You sure that's an ANSI SQL statement. Looks like a
> procedure.
Roberto,
It was my message. Like I said many hands on much work.
If you deparately need conenctivity to Progress at least for development
work you may want to look at:
http://www.openlinksw.com
There are some pretty flexible ODBC connection options for just about any
platform.
-Original M
Paul,
Was the patch applied from this message.
http://sources.redhat.com/ml/cygwin/2000-08/msg00464.html
This should apply to a clean distribution of DBD-ODBC-0.28.
Neil
> -Original Message-
> From: Paul A. Chernoch [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, April 08, 2001 7:16 AM
gt; To: [EMAIL PROTECTED]
> Subject: RE: Storing and Retrieving Arrays
>
>
> Thanks for the help Neil and Bodo.
>
> However, I do not want to store a Perl array in multiple rows, but in
> a single SQL array.
>
> At 7:49 pm +1000 4/4/01, Neil Lunn wrote:
> >[...]
&
> -Original Message-
> From: Sean Carte [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 04, 2001 7:27 PM
> To: [EMAIL PROTECTED]
> Subject: Storing and Retrieving Arrays
You're right. You have misunderstood the concept
>
>
> I've asked for help on this topic before, but received no
> -Original Message-
> From: Tim Bunce [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 04, 2001 6:17 PM
> To: Tim Bunce; Jonathan Leffler; dbi-users
> Subject: Re: DBI 1.15 - regressed DBD::ADO driver?
>
>
>
> I'd be very happy for DBD::ADO to be released to CPAN (DBI::Shell and
> t
> the project fell through I never pursued it. Anyhow I did
> this through
> freetds (and I remember reading a lot about sybase at the time for
> some reason):
TDS has nothing to do with MS Access.
__
Please Note :
Only
This really should be a FAQ. But I am sure there is plenty of information in
the archives.
Look at 'perldoc DBD::Proxy' and 'perldoc dbiproxy' these should explain
what you are looking for.
Essentially you want to be running a Proxy server on the machine with the
Access Database. The DBD::ODBC m
Mike,
Look at DBI::Proxyserver. or perldoc dbiproxy.
But in short.
dbiproxy --localport=6969
> -Original Message-
> From: Vasquez, Mike [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 29, 2001 11:06 AM
> To: [EMAIL PROTECTED]
> Subject: RE: :OBDC
>
>
> I'll be using a Linux server
You should only need the client libraries for the machine you are on.
-Original Message-
From: Joe Grastara [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 9:59 AM
To: [EMAIL PROTECTED]
Subject: Installing DBD::MySql without MySql installed
Hi,
I would like to install the d
Phil,
Because I and others use DBD::ODBC with other drivers. I have no such
problem. That is why I ask the question.
-Original Message-
From: Phil R Lawrence [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 5:53 PM
To: Neil Lunn; [EMAIL PROTECTED]
Subject: Re: ODBC Error
As the archive suggests, this is not a Perl-DBI problem but one with the
Access product itself.
So What version of Access are you using?
-Original Message-
From: Phil R Lawrence [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 5:30 PM
To: [EMAIL PROTECTED]
Subject: ODBC Error -
>I already knew how to do this using fetchall_arrayref, but I don't
>believe there is any documentation on how to do this one fell swoop:
> return $sth->fetchall_arrayref($slice);
Which is documented eg. fetchall_arrayref({}).
the selectall functions and the like are only utility method
100 matches
Mail list logo