Re: Using DBI::Proxy with DBIx::Procedure::Oracle

2002-12-20 Thread Tim Bunce
On Thu, Dec 19, 2002 at 03:58:45PM -0500, Ted Gilchrist wrote: Hello, I have been happily using DBD::Proxy for some time now. But now I would like to expand my horizons and use something like DBIx::Procedure::Oracle. Is this possible? I'd guess you haven't tried. Always the best way to

RE: crash with nested handles

2002-12-20 Thread extern . Lars . Oeschey
No, it shouldn't -- but I can't see the crash message -- what does the dialog box say?. Please update to DBD::ODBC 1.01 as there were some problems in prior versions with memory overwrites. If you can, send a small sample with create tables, etc, which reproduces this. For example script1

Does DBD::Pg 1.20 require PostgreSQL 7.3?

2002-12-20 Thread KAWAI,Takanori
Hi. I have a question about DBD::Pg 1.20 README. It requires PostgreSQL at least 7.3. quote REQUIREMENTS: - build, test and install Perl 5 (at least 5.005) build, test and install the DBI module (at least 1.30) build, test and install

Stored Procedures with DBD::Sybase and FreeTDS

2002-12-20 Thread RWilbert
Has anyone had a problem calling to a stored procedure that performs an insert and returns no data ? I am currently having that and the error that I am getting is: dbih_setup_fbav: invalid number of fields: 0, NUM_OF_FIELDS attribute probably not set right at

Re: DBD::ODBC V 1.01 MySQL 3.23.51

2002-12-20 Thread alex
hi this driver will not realy work with MySQL. i have tryed to compile the ODBC with a MySQL and get the following. Using C:/.cpan/build/DBD-ODBC-1.01/blib t\01baseok t\02simple..FAILED tests 4, 9 Failed 2/17 tests, 88.24% okay t\03dbatt...ok 6/16BD driver has

Re: Select count(TEST) from table where (TEST=?) will crash with DBD-ODBC

2002-12-20 Thread alex
additional to this - with MyODBC 3.51 and a newer MySQL 3.23.54 it will not work, too. DBD::ODBC::st execute failed: [MySQL][ODBC 3.51 Driver] [mysqld-3.23.54-nt]You have an error in your SQL syntax near 'WHERE (TEST='test2')' at line 1 (SQL-42000)(DBD: st_execute/SQLExecute err=-1) at

Problem occurred when installing DBD on SCO

2002-12-20 Thread Brad Kao
Dear sir/madam, I encountered some problem on installing DBD on SCO. My server environment as follow: OS: SCO_SV mis 3.2 5.0.6 i386 C Compiler: Reading specs from /usr/local/lib/gcc-lib/i486-pc-sco3.2v5.0/2.95/specs gcc version 2.95 19990728 (release) Perl: # perl -V Summary of my perl5

RE: DBD::ODBC V 1.01 MySQL 3.23.51

2002-12-20 Thread Jeff Urlwin
Alex, Your mileage may vary. For example: If you do not need transactional control, you might still be ok. Jeff hi this driver will not realy work with MySQL. i have tryed to compile the ODBC with a MySQL and get the following. Using C:/.cpan/build/DBD-ODBC-1.01/blib

RE: Select count(TEST) from table where (TEST=?) will crash with DBD-ODBC

2002-12-20 Thread Jeff Urlwin
additional to this - with MyODBC 3.51 and a newer MySQL 3.23.54 it will not work, too. DBD::ODBC::st execute failed: [MySQL][ODBC 3.51 Driver] [mysqld-3.23.54-nt]You have an error in your SQL syntax near 'WHERE (TEST='test2')' at line 1 (SQL-42000)(DBD: st_execute/SQLExecute err=-1)

Big brother is watching - there are words that may not be used in polite company!

2002-12-20 Thread Jonathan Leffler
I sent an email explaining how to unsubscribe to someone. Subject: How to Unsubscribe - again :-( was Re: Using DBI::Proxy ... Cc: DBI Users Mailing List [EMAIL PROTECTED] To: Bharat [EMAIL PROTECTED] The rediffmail.com mail service rejected my message: [EMAIL PROTECTED] SMTP error

Re: Does DBD::Pg 1.20 require PostgreSQL 7.3?

2002-12-20 Thread Thomas A. Lowery
I'm using 1.20 with Pg 7.2.[13], working fine. Tom On Fri, Dec 20, 2002 at 08:44:14PM +0900, KAWAI,Takanori wrote: I have a question about DBD::Pg 1.20 README. It requires PostgreSQL at least 7.3. quote REQUIREMENTS: - build, test and install Perl 5 (at least

Re: Using DBI::Proxy with DBIx::Procedure::Oracle

2002-12-20 Thread Ted Gilchrist
Actually, You underestimate my density. I tried and failed. When I tried to install DBIx::Procedure::Oracle on my machine, it ultimately complained about a lack of DBD::Oracle, and this led to DBD::Oracle complaining about my lack of an Oracle home. At the risk of a public flogging, what am

Re: Access and placeholders

2002-12-20 Thread Thomas A. Lowery
Place holder example: @dbi:ADO:File Name=.\access.udl insert into tst(id,str) values (99,'this old ma n'); [1 row affected] @dbi:ADO:File Name=.\access.udl insert into tst(id,str) values (101,?); Statement has 1 parameters: Parameter 1 value: this old man [1 row affected] On Fri, Dec 20, 2002 at

Re: Access and placeholders

2002-12-20 Thread Michael A Chase
On Fri, 20 Dec 2002 02:17:54 -0500 Jeff Thies [EMAIL PROTECTED] wrote: Paul Boutros wrote: First time using Access. I've used my usual insert using placeholders and got an error about a count mismatch. Does Access not support placeholders? It definitely does support

How to get out of dbi-users

2002-12-20 Thread Michael A Chase
I doubt this will do much good since you didn't read the responses to the last person who sent such a request to the list, but if you send email to [EMAIL PROTECTED] you will receive instructions that include how to unsubscribe from this list. The same instructions were sent to you when the list

Re: Using DBI::Proxy with DBIx::Procedure::Oracle

2002-12-20 Thread Michael A Chase
On Fri, 20 Dec 2002 10:00:37 -0500 Ted Gilchrist [EMAIL PROTECTED] wrote: You underestimate my density. I tried and failed. When I tried to install DBIx::Procedure::Oracle on my machine, it ultimately complained about a lack of DBD::Oracle, and this led to DBD::Oracle complaining about my

RE: Select count(TEST) from table where (TEST=?) will crash wit h DBD-ODBC

2002-12-20 Thread extern . Lars . Oeschey
my $sth = $dbh-prepare(SELECT COUNT(TEST) FROM $dbtable WHERE (TEST=?)); my $rv = $sth-execute($var1); # this is line 39 I had a similar problem with a INSERT INTO WHERE (SELECT ...) with MSSQL. My problem though seemed to be, that a INSERT statement doesn't allow a WHERE clause with the

Re: Stored Procedures with DBD::Sybase and FreeTDS

2002-12-20 Thread Michael Peppler
On Thu, 2002-12-19 at 13:35, [EMAIL PROTECTED] wrote: Has anyone had a problem calling to a stored procedure that performs an insert and returns no data ? I am currently having that and the error that I am getting is: dbih_setup_fbav: invalid number of fields: 0, NUM_OF_FIELDS attribute

Re: Big brother is watching - there are words that may not be used in polite company!

2002-12-20 Thread John Day
Use of the word unsubscribe - the inclusion of an email address in the body of a message and other such things that we accept in use on the list will get a reasonably high spam score from things like SPAMASSASSIN. I have the same problem with emails I send to an e-zine list (participants have

Re: Big brother is watching - there are words that may not be used in polite company!

2002-12-20 Thread Michael A Chase
On Fri, 20 Dec 2002 11:25:18 -0500 John Day [EMAIL PROTECTED] wrote: Use of the word unsubscribe - the inclusion of an email address in the body of a message and other such things that we accept in use on the list will get a reasonably high spam score from things like SPAMASSASSIN. I have

RE: DBI Failure

2002-12-20 Thread Jeff Urlwin
Dear List- I have been using DBI with DBD-ODBC on a windows 2000 pro systems that's been serving up web pages for two years. I recently had a need to add an additional site, and I had to upgrade to 2000 server in order to get the multi-site capability. The windows 2000 pro

Re: Access and placeholders

2002-12-20 Thread Michael A Chase
On Fri, 20 Dec 2002 15:14:36 -0500 Jeff Thies [EMAIL PROTECTED] wrote: Michael A Chase wrote: On Fri, 20 Dec 2002 02:17:54 -0500 Jeff Thies [EMAIL PROTECTED] wrote: Paul Boutros wrote: First time using Access. I've used my usual insert using placeholders and

Index question

2002-12-20 Thread Kris Wolff
Hi, A plain database question. Can someone explain the differeences between 2 Index types on a table like this: Name VARCHAR(50), description LONGTEXT 1.Indextype CREATE INDEX indexname_1 ON table (Name); CREATE INDEX indexname_1 ON table (description); And 2. Indextype CREATE INDEX indexname_1

Re: Index question

2002-12-20 Thread Michael A Chase
On Sat, 21 Dec 2002 01:13:11 +0100 Kris Wolff [EMAIL PROTECTED] wrote: A plain database question. Can someone explain the differeences between 2 Index types on a table like this: Name VARCHAR(50), description LONGTEXT 1.Indextype CREATE INDEX indexname_1 ON table (Name); CREATE INDEX

RE: Access and placeholders

2002-12-20 Thread Jeff Urlwin
Michael A Chase wrote: On Fri, 20 Dec 2002 02:17:54 -0500 Jeff Thies [EMAIL PROTECTED] wrote: Paul Boutros wrote: First time using Access. I've used my usual insert using placeholders and got an error about a count mismatch. Does Access