On Mon, 08 Dec 2003 17:50:29 -0500 Peter Chen <[EMAIL PROTECTED]> wrote:
> I have installed DBI 1.39 on a Win 2000 with Perl 5.6.1 and DBD::Oracle
> 1.12.
>
> When I tried to connect to an Oracle database on UNIX with the following
> code:
>my $dbh = DBI->connect('DBI:Oracle:XYZDB', 'username
On Mon, Dec 08, 2003 at 05:50:29PM -0500, Peter Chen wrote:
> I have installed DBI 1.39 on a Win 2000 with Perl 5.6.1 and DBD::Oracle
> 1.12.
>
> When I tried to connect to an Oracle database on UNIX with the following
> code:
>my $dbh = DBI->connect('DBI:Oracle:XYZDB', 'username', 'password')
I have installed DBI 1.39 on a Win 2000 with Perl 5.6.1 and DBD::Oracle
1.12.
When I tried to connect to an Oracle database on UNIX with the following
code:
my $dbh = DBI->connect('DBI:Oracle:XYZDB', 'username', 'password');
I got an error message from DBI.pm line 584: Use of unintialized valu
My client updates the remote server with the subroutine below. I'm doubting
that the tables will automatically be unlocked with the connection to the
remote server breaks. Do I need to at least do a $dbh->disconnect anywhere
in the code below??? Is there a better way to reconnect when the remote
co
All,
In an earlier post inquiring about how to get the results ( such as from
a backup or dbcc ), rather than rows, the response pasted below
indicated a solution however, when I try this, I find that the
actual results are returning in STDERR, not in the variable $text
In my code, I redi
Chad,
You seem to have 4 bind variables but only need 3. Did you check the status
of the execute call (or have RaiseError set to 1)?
Michael Fox
-Original Message-
From: chad kellerman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 9 December 2003 9:04 AM
To: perl dbi
Subject: problems with
On Mon, Dec 08, 2003 at 05:03:59PM -0500, chad kellerman wrote:
> Hello everyone,
>
>Trying to run a select statement but getting errors. I know it's
> something stupid but just can't put my finger on it:
>
>
> $addr_slct= qq(
>SELECT SUBSTRING_INDEX(IP, '.',2) AS addr, COUNT(*)
Hello everyone,
Trying to run a select statement but getting errors. I know it's
something stupid but just can't put my finger on it:
$addr_slct= qq(
SELECT SUBSTRING_INDEX(IP, '.',2) AS addr, COUNT(*) AS
addrsum
FROM tbl_masterIP WHERE ipFree=? AND IP NOT LIKE ?
>>
>> From: "Marcus Willemsen" <[EMAIL PROTECTED]>
>> > Has anyone experience with using Perl together with a Microsoft SQL
>> Server 2000?
>>
>> Yes
>>
>> > Do I need anything else apart from the DBI-ODBC Module?
>>
>> I guess you meant DBI and DBD::ODBC.
>> You need the ODBC drivers, but I bet yo
It's really hard to help, if you didn't describe what problem you are having.
Ilya
> -Original Message-
> From: Tshimanga Minkoka [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 08, 2003 8:51 AM
> To: [EMAIL PROTECTED]
> Subject: Problem installing DBI on Win2000
>
>
> Dear All,
>
>
>
> From: "Marcus Willemsen" <[EMAIL PROTECTED]>
> > Has anyone experience with using Perl together with a Microsoft SQL
> > Server 2000?
>
> Yes
>
> > Do I need anything else apart from the DBI-ODBC Module?
>
> I guess you meant DBI and DBD::ODBC.
> You need the ODBC drivers, but I bet you al
From: "Marcus Willemsen" <[EMAIL PROTECTED]>
> Has anyone experience with using Perl together with a Microsoft SQL
> Server 2000?
Yes
> Do I need anything else apart from the DBI-ODBC Module?
I guess you meant DBI and DBD::ODBC.
You need the ODBC drivers, but I bet you already have them.
BEside
Hello everybody,
Has anyone experience with using Perl together with a Microsoft SQL
Server 2000? Do I need anything else apart from the DBI-ODBC Module? Is
there even a special database driver, although I haven't found one on
CPAN.
And finally can anybody point me to a documentation on t
Dear All,
Can someone help me in installing DBI module (and drivers for PostgreSQL,
Oracle 8, Informix and MS SQL 2000) for my ActiveState Perl on my Office
Workstation running Windows 2000 SP4.
I have searched the list and the web for similar problem, but I didn't find
any advice that get me out
The recent message from Jan finally has solved this
mystery and now I can read Unicode data from the
Jet-database. Thanks, Jan!
Some notes of mine regarding Perl and Unicode, including
a small example program showing how to read Unicode from
a Jet-engine database can be found on the fo
file: $CPAN/authors/id/S/SG/SGOELDNER/DBD-ADO-2.82.tar.gz
size: 44212 bytes
md5: d5c48d96a2bb44113d5b2f7001310ea8
Changes:
Replaced duplicated code in DESTROY() with a call to disconnect().
Removed the deprecated Enums() method from DBD::ADO::TypeInfo.
Added t/02ads.t to test data
On Sun, 7 Dec 2003 17:10:48 +0100, Stefan Ram <[EMAIL PROTECTED]>
wrote:
> (Intro: The problem is how to retrieve a unicode
> character from a Jet-Database using DBI and DBD-ADO.)
>
>On Sat, Dec 06, 2003 at 11:47:51PM +0800, Autrijus Tang wrote:
>> Hence, you'd need to explicitly convert bytestr
17 matches
Mail list logo
