This is a known problem, and has been fixed in either 1.07 or 1.07_01.
DBD::Sybase tries to see if chained transactions are supported at startup,
and tries to find the @@version of the server. Both of these requests fail
against a replication server, but the failure is expected, so should simply
b
DUH! Never mind. As someone earlier posted on this thread, you will
either need to:
1. Upgrade your Oracle client to a 9.2 or 10.1 or 10.2 version
2. Recompile your DBD::Oracle source with a MS C/C++ compiler (not
recommended unless you are truly a pretty savvy Windows C/C++ developer)
3. Dow
What version of Oracle is installed?
-Original Message-
From: Angela Chan [mailto:[EMAIL PROTECTED]
Sent: Monday, February 27, 2006 2:06 PM
To: dbi-users@perl.org
Subject: Re: Connect to Oracle
Hi, Ron,
I installed ActivePerl version 5.8.7 build 815, DBI 1.50 and DBD-Oracle
1.16 and I
Hi, Ron,
I installed ActivePerl version 5.8.7 build 815, DBI 1.50 and DBD-Oracle 1.16
and I have Net8 (8.1.7) Oracle Client installed on my machine.
Thanks
Angela
""Reidy, Ron"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
What is your environment? Did you read the README* files
Be careful, Hetal!
You should *not* have any
use DBD::xxx;
in your code.
However you *must* have
use DBI;
near the top of the program.
Do you have that? Please answer.
-Will
-Original Message-
From: Hetal Soni [mailto:[EMAIL PROTECTED]
Sent: Monday 27 February 2006 17:37
To: Cliv
This how I connect to db:
my $dbh = DBI->connect("DBI:$DBType:$DbName", "$User", "$Pwd", {
AutoCommit => 0, PrintError => 0, RaiseError => 0 }) or print
"\nCouldn't connect to the database $DBType $DbName $User - " .
DBI->errstr;
I don't have any use:DBD::* line in my program.. I removed 'em as
Hetal Soni wrote:
Thanks for your input guys.
I removed both "use:DBD::Oralce" and "use"DBD:DB2" lines and now getting
following error:
Can't locate object method "connect" via package "DBI" (perhaps you
forgot to lo
ad "DBI"?) at tmp1.plx line 58.
you do have
use DBI;
in your program?
You still need this line:
use DBI;
Do you have that still?
-Will
-Original Message-
From: Hetal Soni [mailto:[EMAIL PROTECTED]
Sent: Monday 27 February 2006 17:27
To: Alexander Foken; dbi-users@perl.org
Subject: RE: A common perl script for different database platforms
Thanks for
Thanks for your input guys.
I removed both "use:DBD::Oralce" and "use"DBD:DB2" lines and now getting
following error:
Can't locate object method "connect" via package "DBI" (perhaps you
forgot to lo
ad "DBI"?) at tmp1.plx line 58.
Any suggestion?
Thanks again,
Hetal.
-Original Message--
On 2/27/06, Mark Anderson <[EMAIL PROTECTED]> wrote:
> This is not a very helpful answer, but are you sure this is worth
> trying? A Replication Server is not an Adaptive Server Enterprise.
> Admittedly they both use the same Tabular Data Stream networking
> protocol, but they have very different
You should always include information about your platform, Perl version,
DBD::Oracle version and Oracle version, as it almost always helps with the
answer. Here are some guesses:
You mention OCI.dll, so that's Windows.
It's getting as far as loading the libraries, so you have an Oracle client
What is your environment? Did you read the README* files that came with
DBD::Oracle and DBI? Do you have an Oracle client (at least) installed
on this machine?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Angela Chan [mailto:[EMAIL PROTECTED]
Sent: Monday, Febru
This is not a very helpful answer, but are you sure this is worth
trying? A Replication Server is not an Adaptive Server Enterprise.
Admittedly they both use the same Tabular Data Stream networking
protocol, but they have very different command languages. A Rep Server
isn't even a database s
Hi,
I just install DBD::ORACLE in PERL, and try to connect to my ORACLE DB.
However, I receive the following error message. Does anyone know how to
resolve this problem? Thanks
"The procedure entry point OCINlsEnvironmentVariableGet could not be located
in the dynamic link library OCI.dll"
Angel
I've downloaded and tried DBD::Sybase 1.07 on Mac OS X 10.4.5.
You need to install Open Client 12.5.3, otherwise you'll run into
trouble.
First you'll need to fix things like
"Symbol not found: ___CFConstantStringClassReference"
You can fix it by adding options such as
-framework CoreFoundati
This simple test program:
use strict;
use warnings;
use DBI;
my $dbh = DBI->connect('dbi:Sybase:server=REPP', 'REPP_login',
'REPP_passwd', {RaiseError => 1});
my $dummy = 6;
causes this:
Server message number=17001 severity=10 state=0 line=0 server=REPP
text=No SRV_OPTION handler installed.OpenC
Have you looked at PostGIS? It's an open component which is built on
top of PostgreSQL for performing geographic queries such as distances
between two points. You can perform the queries through DBD:Pg.
http://www.postgis.org/
I believe there is also a subgroup working on a geocoder which wil
Formulas for great circle distances aren't hard to derive using just
basic trig. No calculus required!
That being said, the Math::Trig package comes standard with Perl
distributions and has a function called great_circle_distance(). Try
'man Math::Trig'. If you search PDL::Index on CPAN, I beli
18 matches
Mail list logo
