Re: DSN vs. DSNless connection

This often due to something updating (or downgrading) ODBC drivers. You might want to upgrade to the latest and greatest MDAC from On Wed, 10 Oct 2001, Ron Rohrssen wrote: > Hello. > > I have a piece of code that uses a DSNless connection to a SQL Se

Re: Installation DBI-package and DBD package : Need ur Help

-- anandha prassanna <[EMAIL PROTECTED]> DBD::Pg -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582

Installation DBI-package and DBD package : Need ur Help

HI I have to setup PERL to interact with PGSQL. I have taken the following steps. 1.Installation of perl_5.6.0 under Redhat Linux 7.0 2.Installation of POSTGRESQL under Redhat Linux7.0 Both are working perfectly as seperate modules.

Re: [OT] Bulk Updates Using Joins or Some Such Nonsense

On Wed, 10 Oct 2001, Jeff Zucker wrote: > Alex Pilosov wrote: > > > > On Wed, 10 Oct 2001, Jeff Zucker wrote: > > > > > Steve Howard wrote: > > > > > > > > The Standard SQL syntax for updating based on a join is this > > > > > > > > UPDATE Table1 > > > > Set Column1 = r.Column1, Column2

Re: [OT] Bulk Updates Using Joins or Some Such Nonsense

And from _PostgreSQL Interactive Documentation (http://www.postgresql.org/idocs/index.php?sql-update.html): UPDATE [ ONLY ] table SET col = expression [, ...] [ FROM fromlist ] [ WHERE condition ] fromlist A Postgres non-standard extension to allow columns from other .

Re: [OT] Bulk Updates Using Joins or Some Such Nonsense

Alex Pilosov wrote: > > On Wed, 10 Oct 2001, Jeff Zucker wrote: > > > Steve Howard wrote: > > > > > > The Standard SQL syntax for updating based on a join is this > > > > > > UPDATE Table1 > > > Set Column1 = r.Column1, Column2 = r.Column2 > > > FROM Table1 l INNER JOIN Table2 r

Re: [OT] Bulk Updates Using Joins or Some Such Nonsense

Steve Howard wrote: > > > UPDATE Table1 > > Set Column1 = r.Column1, Column2 = r.Column2 > > FROM Table1 l INNER JOIN Table2 r ON l.Column3 = r.Column3 > > That is the ANSI SQL standard. Could I ask where you find that information? (That's not a rhetorical question). My sources

RE: [OT] Bulk Updates Using Joins or Some Such Nonsense

That is the ANSI SQL standard. -Original Message- From: Jeff Zucker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 10, 2001 6:20 PM To: dbi-users Subject: Re: [OT] Bulk Updates Using Joins or Some Such Nonsense Steve Howard wrote: > > The Standard SQL syntax for updating based on

Re: [OT] Bulk Updates Using Joins or Some Such Nonsense

On Wed, 10 Oct 2001, Jeff Zucker wrote: > Steve Howard wrote: > > > > The Standard SQL syntax for updating based on a join is this > > > > UPDATE Table1 > > Set Column1 = r.Column1, Column2 = r.Column2 > > FROM Table1 l INNER JOIN Table2 r ON l.Column3 = r.Column3 > > In which

Re: [OT] Bulk Updates Using Joins or Some Such Nonsense

Steve Howard wrote: > > The Standard SQL syntax for updating based on a join is this > > UPDATE Table1 > Set Column1 = r.Column1, Column2 = r.Column2 > FROM Table1 l INNER JOIN Table2 r ON l.Column3 = r.Column3 In which standard is that standard syntax? :-) -- Jeff

RE: Bulk Updates Using Joins or Some Such Nonsense

If I understand you, you're wanting to do an update based on a join. I can give you standard syntax to do this, but when I tried it on the older version of MySQL that I have here, it was not supported. I don't stay very current with MySQL because I don't use it, so the version you are using might

Patch to DBD-Oracle-1.12 to add support for BFILE columns

The stock DBD-Oracle-1.12 causes Perl to dump core for me if I try to select from a BFILE column. The appended patch adds support for BFILEs. I'm not an Oracle OCI expert so I can't vouch that the code is 100% correct, but "it works for me." I hope that it is useful. David Hull --- oci8.c

Patch to DBD-Oracle-1.12 to compile with Oracle 8.0.3

The appended patch shows the (trivial) changes I had to make to get DBD-Oracle-1.12 compile with Oracle 8.0.3. David Hull --- oci8.c 2001/09/26 02:18:55 1.1 +++ oci8.c 2001/10/10 18:58:47 1.2 @@ -1,5 +1,5 @@ /* - $Id: oci8.c,v 1.1 2001/09/26 02:18:55 hull Exp $ + $Id: oci8

Re: Bulk Updates Using Joins or Some Such Nonsense

I'm not really sure that this is what you meant, but I think you could try something like: SELECT INTO my_new_table table1.id as id, table1.direction as direction, table2.speed as speed FROM table1 INNER JOIN table2 ON table1.id = table2.id I don't know if MySQL supports INNER JOIN (I suppose

Bulk Updates Using Joins or Some Such Nonsense

Dear All, Using MySQL I'm trying to update field1 in table1 with data from field1 in table2 where the primary keys in tables 1 and 2 match. In other words I have 2 tables the first with direction information and the second with speed information both have time as the primary key and what I wan

DSN vs. DSNless connection

Hello. I have a piece of code that uses a DSNless connection to a SQL Server database. This code has been working just fine until just a few hours ago. Suddenly, the database connection dies with this error: Invalid string or buffer length (SQL-S1090)(DBD: db_login/SQLConnect err=-1) I stripped

Re: How to handle duplicate information?

Prepare a query on each table, execute the primary one, and fetch its rows in the outer loop. As you need information from each secondary table, execute its query with the appropriate arguments to execute() to select the necessary rows. This should be reasonably efficient as long as the columns

Re: Newbie:oracle:transaction

The Oracle documentation has a reasonably good discussion of transactions in the Concepts manual. There should be a copy available on line somewhere at your site. Ask your local DBA. To take advantage of transactions in DBI, you need to set AutoCommit off, how to do this is described in the DBI

Re: Newbie:oracle:transaction

Wrap your statements in an eval block per the TRANSACTIONS section of DBI(3) I believe Cathy Riemer and Belinda Giardine own a copy of CJ Date's Database book if you want a good introduction to database. John [EMAIL PROTECTED]

Newbie:oracle:transaction

Hi, I wanted to know about the database transactions. I want to execute a bunch of not-so-related database queries using Oracle. I am presently using MySQL, but as I have never used any transaction (of which I want to know the basics of), but heard about that, I want to switch to Oracle. Now my

Re: DBI/Solaris User

Yes, DBI and likely all of the database specific DBD's work fine under Solaris. You'll need your own build of Perl or at least one built with a compiler that you have installed (gcc). John [EMAIL PROTECTED]

Re: Drivers to connect Oracle database(on Solaris) from Perl script on Unix(Solaris)

Under Win32, ActiveState bundles a script called PPM to automate the installation of Perl modules. My guess is they have a corresponding tool for Solaris. John [EMAIL PROTECTED]

DBI/Solaris User

Hello Sir, My name is Shamaal Blaise. I wanted to know if the Perl module had been tested on Sun/Solaris system??? And if so, where here any problems??? I am currently trying to do so on that type of system. I had noticed that there was not any mention of it on the page. I would greatly appre

I have a problem in use DBD::Oracle qw(:ora_types);

hello > When I run a below perl script from the command line, it works, but, > when I run it under the Apache web server, it fails!'' Why keep in > mind that i'm using Linux Red Had 6.5 with oracle 8.i and perl 5.6.0 > with DBI version1.13, and DBD version 1.08 > #!/usr/bin/perl -I /usr/local/lib

How to handle duplicate information?

Hello, I am joing 4 tables to retrieve data from an oracle database using Perl DBI. Once I recieve the data, I put it in xml format. Table A has 1 to many relationship with table B, C, and D. Table D has one to many releationship with table B and C. The problem is that every record I recieve I

Re: Help with connection with DBD between two machines

On Wed, 10 Oct 2001, Ing. Roberto Andrade Fonseca wrote: >Hi Jonathan: >I wrote yesterday to the DBI list. > >Thats the new situation: > >SERVER: >I have a RH Linux 6.2 server with IDS FOR LINUX 7.30.UC5, CLIENT SDK >FOR LINUX 2.10.UC2 and CONNECT FOR LINUX 2.10.UC2. > >Its name is everest. > >I h

Re: Problems using DBD::Informix on two machines.

On Tue, 9 Oct 2001, Ing. Roberto Andrade Fonseca wrote: >Hi Jonathan: I've seen a newer message - I'll answer it shortly. >On Tue, 9 Oct 2001, Jonathan Leffler wrote: >> "Ing. Roberto Andrade Fonseca" wrote: >> > I have Informix installed on server everest. A few hours ago I >> > compiled succe

RE: Drivers to connect Oracle database(on Solaris) from Perl script on Unix(Solaris)

Hi, Go to this page : http://dbi.symbolstone.org/index.html There you can find every thing. You need to get DBI and DBD:Oracle. --Raju -Original Message- From: $uren [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 10, 2001 10:42 AM To: [EMAIL PROTECTED] Subject: Drivers to connec

Drivers to connect Oracle database(on Solaris) from Perl script on Unix(Solaris)

Hi All, I am a newbie to perl. I am working on Unix(Solaris). I have installed ActivePerl5.6 on Unix(Solaris). Now I need to connect to Oracle(8.1.5) database from a perl script. I am looking for suitable drivers. Can someone guide me where from I have to download the drivers. How to install the d

Re: DBI-1.20 installation problem

> To whom it may concern or John Groenveld: > > I am installing DBI-1.20 and received the error from running make. > Apparently, the file it is looking for is not in the CORE directory. = > Perl 5 > was installed first, then DBI on a AIX platform running 4.3.3. I am a > newbie unix system admin

Re: Installing DBI

Sebastien, (See e-mails earlier in the week about this problem.) Perl bundled with Solaris 2.8 is (a) old and (b) compiled with Sun compiler. DBI and DBD::* need to be compiled with the same compiler as Perl. Recommended action: install Perl 5.6.1 package from sunfreeware.com (which _is_ compi

RE: Installing DBI

Sébastien, Check your PATH env. variable and make sure that the gcc compiler is the first in your Path. Solaris ships with a "disabled" /usr/ucb/cc and it tends to get into your path first. If you are using the Perl that comes installed with Solaris 2.8, you might have troubles - I'm pretty su

Installing DBI

Hello, I'm trying to install DBI (Solaris 2.8) Once the "perl Makefile.PL" done, I do the "make". But I've the following message : /usr/ucb/cc: language optional software package not installed (gcc is correctly installed). Please, I Need help ! Thanks. Sébastien. _

sys_nerr problem in 'make test' when instaling DBD.

Hi, I am trying to install DBD on my perl, v5.6.1 built for i386-dynixptx . make test gives me the nasty sys_nerr not found messages as follows: t/general...install_driver(Oracle) failed: Can't load 'blib/arch/auto/DB D/Oracle/Oracle.so' for module DBD::Oracle: dynamic linker: /apps

RE: Problems installing DBD::mysql

Hi Scott, Thanks for the reply, however this did not seem to work for me. I ran the ldconfig -r command and there was no entry for mysqlclient anywhere. I did a grep on it just to make sure my eyes were not playing tricks on me. When I ran the second command, it gave me several error messages.

Re: LOBs and case sensitive field names

Sure! Sorry for so slipshod hack, I needed to solve the problem very quickly. Regards, Oleg C:\SW_ENV\sw_env_1.3\DBD-Oracle-1.06>diff -u oci8.c.orig oci8.c --- oci8.c.orig Thu Jul 13 22:42:17 2000 +++ oci8.c Thu Oct 4 22:14:13 2001 @@ -1250,8 +1250,16 @@ while( (sv = hv_iternextsv(l

RE: Problems compiling DBD::Informix on Win2K

>Why are you trying to build DBD::Informix if you are using Build 6xx from >ActiveState ?? > >Why don't you just get the DBD::Informix binary, unzip it into your perl >directory, and just run 'ppm install DBD-Informix.ppd' from the MS-Dos >prompt ?? I'm not aware that a DBD::Informix binary exis