Re: SQL Server Anywhere and ODBC

I've used DBD::ADO, DBD::ODBC and DBD::ASAny and DBD::Sybase/FreeTDS with SSA and they all work fine. -- Simon Oliver

Re: SQL Server Anywhere and ODBC

Simon Oliver [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I've used DBD::ADO, DBD::ODBC and DBD::ASAny and DBD::Sybase/FreeTDS with SSA and they all work fine. -- Cool! Can you show me what the connection string with DBD::ODBC looks like? Bob

Re: SQL Server Anywhere and ODBC

Cool! Can you show me what the connection string with DBD::ODBC looks like? Easiest route is to set up a system DSN via the ODBC administrator and then just specify the DSN name in the connection string. Alternatively, use a DSN-less connection string: my $dsn = driver=Adaptive Server

Problems with DBI::ODBC and colons in stored procs

I have looked everywhere I can think of and tried tracing to isolate this this issue. I have not been able to figure it out. I am using DBI::ODBC to the Pervasive.SQL driver. Everything works great except for stored procedures with a colon in them. These same stored procedures work fine via ODBC,

RE: Problems with DBI::ODBC and colons in stored procs

I have looked everywhere I can think of and tried tracing to isolate this this issue. I have not been able to figure it out. I am using DBI::ODBC to the Pervasive.SQL driver. Everything works great except for stored procedures with a colon in them. These same stored procedures work fine

help for install DBI on linux for Oracle

Hi There; I got following error during installing DBI-1.32 on Linux 6.2 with Perl perl-5.00503-12. Could you give any help? Thanks. Regards, Yang PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/i386-linux -I/ usr/lib/perl5/5.00503 -e 'use Test::Harness

Error installing mysql::DBD module

Hi, Beginner needing help! I'm having problems downloading the DBD::mysql module. The error message I'm getting is: Error Installing package 'DBD-mysql':Read a PPD for 'DBD-mysql', but it is not intended for this build of Perl (Win32-x86-multi-thread). Any help solving this problem would

apache config problems

INSTALLED: apache 1.3.27 perl 5.6.1 redhat 7.3 For some reason perl is mangling the environment variables set in the httpd.conf file: -httpd.conf- SetEnv LD_LIBRARY_PATH=/usr/local/lib:/usr/local/atf/lib:/usr/local/hydra/lib:/opt/oracle/lib SetEnv

Re: DBI-1.3[34] memory leak?

On Thu, Mar 06, 2003 at 06:20:07PM +, Tim Bunce wrote: : On Wed, Mar 05, 2003 at 08:13:00AM -0600, Philip Molter wrote: : I have a very long running Perl process. I recently upgraded the : DBI from 1.32 to 1.33 (and then 1.34) and now, the process is leaking : memory. Given the complexity

Re: Error installing mysql::DBD module

You need a ppd built for Perl 5.8 You can locate at http://theoryx5.uwinnipeg.ca Catherinelebon wrote: Hi, Beginner needing help! I'm having problems downloading the DBD::mysql module. The error message I'm getting is: Error Installing package 'DBD-mysql': Read a PPD for 'DBD-mysql',

DBD::Proxy problems

I'm trying to get a new Mac OS X machine up and running with the following script: -- #!e:/Perl/bin/perl.exe -w $|=1; use strict; use DBI; #use CGI qw(:standard); use lib (qw(.)); #CONNECT TO THE DATABASE and EXECUTE SQL STATEMENT my $user=CRAU; my $pw=CRAU; my

DBI: Can't locate DBI.pm

What's this error? The DBI package is not installed? Software error: [Thu Mar 6 15:01:54 2003] DBI.pm: Can't locate DBI.pm in @INC (@INC contains: /usr/local/lib/perl5/5.00503/i386-freebsd /usr/local/lib/perl5/5.00503 /usr/local/lib/site_perl /usr/local/lib/site_perl .) at

can't DROP tables

I am using ActivePerl 5.8 and DBD::ODBC, ODBC is connecting to Microsoft Access Driver. At the end of my Perl program, I want to DROP all tables just created for tempory use. However, it caused error. The error message is about the table xxx is being used by other applications ( I just

RE: apache config problems

On 06 Mar 2003 11:11:15 -0600, Rob Benton [EMAIL PROTECTED] wrote: INSTALLED: apache 1.3.27 perl 5.6.1 redhat 7.3 For some reason perl is mangling the environment variables set in the httpd.conf file: -httpd.conf-

FW: Query multiple databases with one sql statement?

Thanks Ian! It's working for me now. Joel Brockman -Original Message- From: Ian Jones [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 2:07 PM To: Joel Brockman Subject: Re: Query multiple databases with one sql statement? It's actually done in the database. A database link

Patch for DBI 1.34 Driver.xst - needed by DBD::Informix 2003.0x

Hi, I've had multiple reports of problems compiling DBD::Informix 2003.03.* and 2003.04, on both Linux and Solaris, and the problem turns out to be in the DBI 1.34 code in Driver.xst for handling data_sources (which is still my fault - mostly). Newer versions of GCC (eg 3.2.1 - as found on my

Re: can't DROP tables

Try closing all statement-handles that touch those tables first. i.e. $sth-close(); On Fri, 7 Mar 2003, [big5] Gary Fung wrote: I am using ActivePerl 5.8 and DBD::ODBC, ODBC is connecting to Microsoft Access Driver. At the end of my Perl program, I want to DROP all tables just created

PPD for DBD::Oracle Under Perl 5.8

Can anyone tell me where I might find this ppd file? Thanks! -Ian

Re: server messages

On Thu, 2003-03-06 at 12:30, Markham, Richard wrote: How do I trap the db server messages that result from the sql I pass to the database? Depends. With DBD::Sybase you can use the syb_err_handler attribute (check the man page). Michael -- Michael Peppler Data

Dropping tables

Can I do this via DBI connecting to a PostgreSQL database? $dbh-do(DROP TABLE $tablename); I could experiment but I would rather not screw up the database if this is not possible. Thanks all. -- Brian Avis SEARHC Medical Clinic Juneau, AK 99801 (907) 463-4049 Have a nice diurnal anomaly!