I want to write a query like:
select clients.client.client_id, columnar.sales.total_sales,
web.page_hits from clients, columnar, web
where clients.client_id = columnar.client_id
and clients.client_id = web.client_id
in a system where 'clients' is actually one or more relational
databases,
On 26.06.13 14:26, Andrew Snyder wrote:
I want to write a query like:
select clients.client.client_id, columnar.sales.total_sales,
web.page_hits from clients, columnar, web
where clients.client_id = columnar.client_id
and clients.client_id = web.client_id
in a system where 'clients' is
On Wed, Jun 26, 2013 at 7:26 AM, Andrew Snyder a...@dancingjars.com wrote:
I want to write a query like:
select clients.client.client_id, columnar.sales.total_sales, web.page_hits
from clients, columnar, web
where clients.client_id = columnar.client_id
and clients.client_id = web.client_id
On 26.06.13 15:25, David Nicol wrote:
On Wed, Jun 26, 2013 at 7:26 AM, Andrew Snyder a...@dancingjars.com
mailto:a...@dancingjars.com wrote:
I want to write a query like:
select clients.client.client_id, columnar.sales.total_sales,
web.page_hits from clients, columnar, web
Dear all,
firts of all, I have already looked up this error on the net and I
have found some, quite obvious, hints ⁽¹⁾ but they unfortunately don't
help.
The problem is Apache::AuthDBI uses method is_initial_req from the
Apache2::RequestUtil package but this method is not recognized as a
method
Date: Wed, 26 Jun 2013 08:26:36 -0400
From: a...@dancingjars.com
To: dbi-users@perl.org
Subject: cross database queries?
I want to write a query like:
select clients.client.client_id, columnar.sales.total_sales,
web.page_hits from clients, columnar, web
where clients.client_id =
I suddenly lost the ability to connect to my ODBC database yesterday, after
years of using the same function to establish a connection:
sub dbaseconnect {
if (defined($testing)) {
if ($testing eq YES) {
$dsn = 'dbi:ODBC:test1' ;
print Using test database\n ;
On 6/26/2013 9:28 AM, Dan Bent wrote:
and the program just hangs when it looks for data sources using the
ODBC driver. So, I suspect that there are issues with the ODBC driver.
Here are the versions of the various DBI module components:
do you have any non-perl ODBC tools? I suspect (purely
On Wed, Jun 26, 2013 at 9:28 AM, Dan Bent db...@comcast.net wrote:
I suddenly lost the ability to connect to my ODBC database yesterday,
after years of using the same function to establish a connection:
So, the question you must ask yourself is:
What changed yesterday? Or, if not
Big thanks for the rapid response!
non-Perl ODBC tools? I'm not sure. I've been working with Perl for a
number of years and may have tools I am not aware of.
I do have Windows users who access the same database without any issues,
but I don't know of any tools I have in UNIX other than Perl. I
On 26/06/2013 17:28, Dan Bent wrote:
I suddenly lost the ability to connect to my ODBC database yesterday,
after years of using the same function to establish a connection:
sub dbaseconnect {
if (defined($testing)) {
if ($testing eq YES) {
$dsn = 'dbi:ODBC:test1' ;
I agree, and I've been trying to identify what changed yesterday morning.
The database, Perl,and the program all reside on the same machine, so I
think we can rule out network issues.
As far as I know, the DBMS, Perl and ODBC infrastructure have been stable
for quite a while, and I haven't
On 26/06/2013 18:42, Dan Bent wrote:
I agree, and I've been trying to identify what changed yesterday morning.
The database, Perl,and the program all reside on the same machine, so I
think we can rule out network issues.
As far as I know, the DBMS, Perl and ODBC infrastructure have been
stable
Big thanks!
I did this:
ldd
/opt/perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi/auto/DBD/ODBC/ODBC.sl
and got:
/usr/local/liant/lib/libodbc.sl.1 =/usr/local/liant/lib/libodbc.sl.1
/usr/lib/libc.2 = /usr/lib/libc.2
/usr/lib/libdld.2 =/usr/lib/libdld.2
On 26/06/2013 19:35, Dan Bent wrote:
Big thanks!
I did this:
ldd
/opt/perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi/auto/DBD/ODBC/ODBC.sl
and got:
/usr/local/liant/lib/libodbc.sl.1 =/usr/local/liant/lib/libodbc.sl.1
/usr/lib/libc.2 = /usr/lib/libc.2
can you run strace, or the HP equivalent, to see what system calls are
getting made and what files are and are not found?
the system call that doesn't return is likely where the problem is.
Check the time stamp of any file that is loaded to see if it was changed
recently. Any file that it
I have strace, but don't know how to use it.
On Wed, Jun 26, 2013 at 2:01 PM, Martin J. Evans boh...@ntlworld.comwrote:
On 26/06/2013 19:35, Dan Bent wrote:
Big thanks!
I did this:
ldd
/opt/perl_32/lib/site_perl/5.**8.8/PA-RISC1.1-thread-multi/**
auto/DBD/ODBC/ODBC.sl
and got:
Thank you all for your replies. I am indeed talking about working with
multiple back ends (oracle, mysql, or any valid DBI module) in the same
query.
I'll post any follow-up questions to the dev list.
Andrew
On 06/26/2013 08:26 AM, Andrew Snyder wrote:
I want to write a query like:
select
On 26/06/2013 20:29, Dan Bent wrote:
I have strace, but don't know how to use it.
Usually something like:
strace -o out.log isql -v mydsn username password
then after it hangs hit ctrl/c and look at (paste here) the last 100
lines of out.log
Martin
On Wed, Jun 26, 2013 at 2:01 PM,
On 26/06/2013 20:25, Dan Bent wrote:
Everything is on one box.
Liant was a small development company out of Austin, TX that created a
product called Relativity, which allows C-ISAM files to be manipulated
as if they were a relational database. The developer of our primary
business application
Everything is on one box.
Liant was a small development company out of Austin, TX that created a
product called Relativity, which allows C-ISAM files to be manipulated as
if they were a relational database. The developer of our primary business
application (developed in COBOL) used Relativity as a
On 6/26/2013 12:29 PM, Andrew Snyder wrote:
Thank you all for your replies. I am indeed talking about working
with multiple back ends (oracle, mysql, or any valid DBI module) in
the same query.
thats never going to happen. DBI is not a sql processor, its just an
interface, the SQL is
$ strace -o strace.log isql -v prod1 user password
usage: [ mid sid level] ...
So, that didn't get us what we wanted. The man page:
NAME
strace - write STREAMS event trace messages to standard output
SYNOPSIS
strace [ mod sub pri ] ...
DESCRIPTION
strace gets STREAMS event
On 2013.06.26 12:47 PM, John R Pierce wrote:
On 6/26/2013 12:29 PM, Andrew Snyder wrote:
Thank you all for your replies. I am indeed talking about working with
multiple back ends (oracle, mysql, or any valid DBI module) in the same query.
thats never going to happen. DBI is not a sql
Hi, I think I have run into this bug;
https://rt.cpan.org/Public/Bug/Display.html?id=71555
I am working on a 64-bit Windows Server 2008 system
and 32-bit Strawberry Perl (32-bit since it appears that
there is a module I need which doesn't work with 64-bit).
perl/vendor/lib/DBD/mysql.pm says
dbi-users@perl.org
--
www.linkedin.com/in/aomary
On 6/26/2013 8:38 PM, Al Omary wrote:
dbi-users@perl.org mailto:dbi-users@perl.org
in the headers of every message, you'll see...
Mailing-List: contact dbi-users-h...@perl.org; run by ezmlm
Precedence: bulk
List-Post: mailto:dbi-users@perl.org
List-Help: mailto:dbi-users-h...@perl.org
27 matches
Mail list logo