OLE exception

Hi. I try to run the following query with DBD:ADO driver: - set nocount on declare @beforedate datetime, @date datetime, @casinoid int, @playertype INT, @gamingserverID int, @date2order datetime,

Re: DBI::Informix On WinnT

Hi Bart I have had exactly the same experience on Win NT / 2000. Are you using ActiveState Perl by any chance ? Unfortunately the only way I managed to get DBD::Informix to work was to recompile Perl from the source making sure that the Flavour=ActiveState line in the makefile

Re: Calling DBI from C

On Thu, Oct 25, 2001 at 05:35:41AM -, p j j wrote: Hi, I am trying to call the DBI routines of perl from a C-program. Like this eval_pv(use DBI;my $dbh = DBI-connect('DBI:Oracle:mydatabase','scott','tiger'),TRUE); It gives the following error while executing (compilation

rows not returned when last column contains null

I've got a dbi application which is currently running happily on Oracle. However, we have to port it to MySQL for some customers who don't have Oracle and can't afford Oracle licenses. I'm trying to do this is 2 stages. The first stage is to replace any Oracle-specific SQL with generic SQL,

Re: rows not returned when last column contains null

On Thu, 25 Oct 2001 11:49:53 +0100 (BST), Maria Quinn wrote: However, I've noticed that where the final column of the select clause contains a null, the row is not returned, and in fact, no subsequent rows are returned. The same query in sqlplus gives me all the rows I need. So what am I

ANN: SQL::Catalog - test, label, store, search and retrieve SQL queries

The URL http://princepawn.perlmonk.org/domains/semantic- elements.com/cpan/SQL-Catalog-0.01.tar.gz has entered CPAN as file: $CPAN/authors/id/T/TB/TBONE/SQL-Catalog-0.01.tar.gz NAME SQL::Catalog - test, label, store, search and retrieve SQL queries SYNOPSIS shell% cd

Re: Hello, Regarding Oracle SQLNet??

Unfortunately, setting up an oracle client is (sort of) confusing to the inexperienced (and beyond the scope of DBI, but there is lots of stuff published on the web). In short you do NOT need to install the oracle database. But you do have to download the entire database software (when you are

Re: OLE exception

Konstantin Berman writes: Hi. I try to run the following query with DBD:ADO driver: - set nocount on declare @beforedate datetime, @date datetime, @casinoid int, @playertype INT, @gamingserverID int,

RE: OLE exception

Thanks for your response. Do you have any idea why the query analyzer says the query is ok? -Original Message- From: Michael Peppler [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 4:44 PM To: Konstantin Berman Cc: '[EMAIL PROTECTED]' Subject: Re: OLE exception Konstantin

Inserting Rows into Access 2000 with DBD::ODBC

Hello, Sorry if this is a terribly stupid question. I've looked around and can't find the answer to this question. I'd really appreciate any help or pointers to the information I need. I'm trying to write a program that will update a simple Access 2000 table. Whenever I try to run the insert

Timeout expired

How to set timeout unlimited in DBD::ADO connection? Thanks in advance

RE: Inserting Rows into Access 2000 with DBD::ODBC

Does your table have a primary key? -Original Message- From: Alan Hogue [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 11:03 AM To: [EMAIL PROTECTED] Subject: Inserting Rows into Access 2000 with DBD::ODBC Hello, Sorry if this is a terribly stupid question. I've looked

make test fails for DBD-ORACLE-1.06

Hi All, Sorry for the repost but I never received the first post myself. This is the result of make test: make test PERL_DL_NONLAZY=1 /usr/perl5/bin/perl -Iblib/arch -Iblib/lib -I/usr/perl5/5.00503/sun4-solaris -I/usr/perl5/5.00503 -e 'use Test::Harness qw(runtests $verbose); $verbose=0;

RE: Inserting Rows into Access 2000 with DBD::ODBC

Perl/DBI out of the picture, I ran into this problem (updateable query) and it related to user permissions on the table. Try Admin uid with its password or estab. another user. Use Access to access Access DB first and try updating. Then go over to your PL/ODBC script. Also, try turning on

Re: make test fails for DBD-ORACLE-1.06

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Try DBD::Oracle 1.12. - -- Stephen Clouse [EMAIL PROTECTED] Senior Programmer, IQ Coordinator Project Lead The IQ Group, Inc. http://www.theiqgroup.com/ -BEGIN PGP SIGNATURE- Version: PGP 6.5.8

DBD::Pg breaks with embedded ASCII nulls

The following code fails with an 'Unterminated quote string' error. #!/usr/bin/perl -w use strict; use DBI; use Carp; my $dbh = DBI-connect('dbi:Pg:dbname=nexcerpt', '', '', {AutoCommit=0, RaiseError=0,

DBI Install Error on AIX

trying to install dbi-1.20. make won't finish due to 127 error, please help! running: perl 5.6.1 dbi-1.20 aix 4.3 output: make cc_r -c -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 - DPERL_POLLUTE -DNEED_PTHREAD_INIT -I/usr/local/include -q32 -D_LARGE_FILES - qlon glong -O

escaping SQL statements properly DBD::mysql

Hello, sorry if this is not the right place for this question or if it has been asked before: I need to escape this sql statement properly and I cannot seem to get it to work. the SQL statement as entered on the command line is : grant usage, SELECT, INSERT, UPDATE, DELETE, CREATE, DROP,

Re: DBI Install Error on AIX

On Thu, 25 Oct 2001, Sean Abrahams - FABS ITC wrote: trying to install dbi-1.20. make won't finish due to 127 error, please help! running: perl 5.6.1 dbi-1.20 aix 4.3 output: make cc_r -c -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 - DPERL_POLLUTE

Re: escaping SQL statements properly DBD::mysql

What I would do is something like this: my $dbname = 'some_database' my $user = 'some_user@localhost'; my $pass = 'some_pass'; my $grant_db = qq|GRANT USAGE, SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER on ?.* TO ? IDENTIFIED BY ?|; $dbh-do($grant_db,undef,$dbname,$user,$pass) or die

RE: OLE exception

What you are running is not a query. It is an ISQL script. It will work fine in Query analyzer, but DBI can only prepare and execute one statement at a time (Read Perldoc DBI). If you want to use a script like that, create a stored procedure then you can execute it and get the results into your

Fw: escaping SQL statements properly DBD::mysql

Thanks for the reply, It still does not like the username@'%' Can this be done? again here is the full command that works from the command line : grant usage, SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER on database_name.* TO username@'%' IDENTIFIED BY 'password'; here's the

Mysql DBI / DBD

Hi Tim I install your Mysql DBI/DBD on a HP-UX 10.20. After that I execute a PERL program and got following errors: $ ./Send_trap.plx install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /opt/perl5/lib/PA-RISC1.1/5.00404 /opt/perl5/lib

Re: php vs perl again (reposted - original post was incomplete)

Comparison of languages: Description C C++ Perl Python Tcl Shell PHP Lisp Forth Can anyone add java? (I can't) -- Hirosi Taguti [EMAIL PROTECTED]

Building DBI on Win98

Hi, I'm experiencing problems building DBI on Windows 98. After executing perl Makefile.PL, I can't use make on the generated Makefile as there is a syntax error in it. Any ideas? Thanks very much. Regards. Gary Revell.

Help for install DBI.zip

Hi, There: I downloaded the DBI.zip from http://www.activestate.com/PPMPackages/zips/5xx-builds-only/ and installed it as instruction. But, I got: Error installing package 'dbi.ppd': could not locate a ppm binary of 'dbi.ppd' for this plateform I use Window98 Second Edition and

Re: Building DBI on Win98

Hi. If you use ActivePerl, how about use PPM? ActivePerl FAQ2 - PPM http://aspn.activestate.com/ASPN/Reference/Products/ActivePerl/faq/ActivePer l-faq2.html == Kawai, Takanori(Hippo2000) Mail: [EMAIL PROTECTED] [EMAIL PROTECTED]

Re: Help for install DBI.zip

Hi. - Original Message - From: Bin Tang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 25, 2001 2:30 PM Subject: Help for install DBI.zip Hi, There: I downloaded the DBI.zip from http://www.activestate.com/PPMPackages/zips/5xx-builds-only/ and installed it as

[ANNOUNCE] SPOPS 0.52 released

SPOPS 0.52 has been released to CPAN and is available on Sourceforge. It fixes a bug in SPOPS::ClassFactory family that broke old rules. This release also contains additional examples, enhancements to SPOPS::LDAP::MultiDatasource and, as a result of discussions on the poop-group list, some

RE: php vs perl again (reposted - original post was incomplete)

-Original Message- From: Hirosi Taguti [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 11:32 PM To: [EMAIL PROTECTED] Subject: Re: php vs perl again (reposted - original post was incomplete) Comparison of languages: Description C C++ Perl

Re: Timeout expired

Use 0 as the Timeout Value. I'll make a note to add this to the docs. use DBI; $dbh = DBI-connect(dbi:ADO:dsn, $user, $passwd); Options in the connect string: dbi:ADO:dsn;CommandTimeout=60 (your number) dbi:ADO:dsn;ConnectTimeout=60 (your number) or include both

Re: Q: Out of memory

You may want to check the release notes for the current versions of both DBI and DBD::Oracle. This may be addressed. I know Tim, with help, has plugged a number leaks. Tom On Tue, Oct 23, 2001 at 02:07:08PM +0200, Jan Schubert wrote: There is still my Out of Memory Problem using DBI 1.18,

Re: php vs perl again (reposted - original post was incomplete)

In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Scott R. Godin) wrote: Well post the script and we can look. Please eliminate the parts that are not relevant if you script is big. it's about 255 lines of code incuding comments.. I'll remove the comments from the file to shorten it a

Re: php vs perl again (reposted - original post was incomplete)

On Wed, Oct 24, 2001 at 04:56:19PM -0500, Scott T. Hildreth wrote: Well I'm not a web developer, never used mod_perl, there is the article on Perl.com describing how they built e-toys with mod_perl. I think at the time it was the 3rd busiest web site at the time. I don't know if the

DBI installation error

Hello I am compiling DBI-1.20 using gcc 2.95.3 and perl 5.6.1 and I am geeting a core dump when it runs the t/examp tests. I have attached a file with the errors. What are the t/examp tests testing. I want to know in case it is not relevant and I can ignore it. dbierror.txt (:=)