From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject:Re: RE: In Need of a Miracle...WAS:Re: Pg Connection WOES on
DEADLINE!
Date sent: Thu, 31 May 2001 22:55:32 -0500
Michael,
Thanks, but no...I have
Glen,
interesting question. you have your api to connect from asp to database
while dbi is perl module. Bottom line is ADODB.Connection is for ASP and
DBI is for perl. 2 different languages 2 different libraries. Actually to be
more politically correct ASP can be VB or JS, but that's whole
Hey there,
Has anyone seen this error before? I am trying to track it down and fix it,
but I am still quite new to all this. Any advice welcome.
Thanks :)
CLiff.
Error returned:-
$h-rows count is incomplete before all rows fetched.
Cliff wrote:
Has anyone seen this error before? I am trying to track it down and fix it,
but I am still quite new to all this. Any advice welcome.
Error returned:-
$h-rows count is incomplete before all rows fetched.
Have you read perldoc DBI?
`rows'
$rv = $sth-rows;
Hi,
I'm using DBI 1.16 with DBD:Oracle 1.06 , the following line does NOT give
me an error, while the same code DOES give an error (as it should) when run
through sqlplus:
update DC_PATROL_STATUS_TABLE set
SEVERITY='OK',date_inserted=sysdate,escalation_id='*NONE*',
Thanks. I'll fix it for the next release. Meanwhile try
... $attr ? sort %$attr : ();
Tim.
On Thu, May 31, 2001 at 04:17:09PM -0500, Mitch Helle-Morrissey wrote:
I think there might be a bug with the connect_cached() method in DBI. If
the elements in the attributes hashref are in a
On Fri, Jun 01, 2001 at 10:23:39AM +0100, Graham Barr wrote:
On Fri, Jun 01, 2001 at 10:19:51AM +0100, Tim Bunce wrote:
Thanks. I'll fix it for the next release. Meanwhile try
... $attr ? sort %$attr : ();
Um, that will mix the kesy and values. You would need something like
Dear Friends,
I would like to access Microsoft Access database file ie .mdb, through
perl under Unix/ Linux platform. Please guide me whether this is possible
or not with some resources.
Regards
Suresh Kannan
Hi,
We have several servers that use DBI 1.13 which I want to upgrade to 1.16.
All the steps up to and including 'make test' work fine.
Is there any I can test that newly build version with my current DBD (Oracle
1.06) drivers ??
Would 'use lib new-dbi-dir' work?
I could of course make a
Tim,
Is my assumption correct that either:
OCIStmtPrepare or OCIStmtExecute
should return an error of some sort ??
I did rebuild DBD on the same machine against Oracle 8.1.7. yesterday.
We have pretty much all versions of Oracle over here, so I tried it on
Oracle 7.3.4. (hpux10.20, same
Try using DBI::Proxy
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 01 June 2001 11:20
To: [EMAIL PROTECTED]
Subject: MS Access
Dear Friends,
I would like to access Microsoft Access database file ie
.mdb, through
perl under Unix/ Linux
On Fri, Jun 01, 2001 at 12:18:55PM +0200, [EMAIL PROTECTED] wrote:
Tim,
Is my assumption correct that either:
OCIStmtPrepare or OCIStmtExecute
should return an error of some sort ??
I'd expect OCIStmtExecute to return OCI_ERROR or OCI_SUCCESS_WITH_INFO.
But since the update says it
I hate to tell you this, but in the code snippet below, you ARE using a
placeholder for the whole query. The following two lines should probably be
deleted, as they do nothing helpful:
$sqld=?;
$sthd=$dbhd-prepare($sqld);
'do' statements don't need to be prepared.The $dbhd-do should have its
Hi All,
Is there anybody out there?... Tim!?!?
I get the following error with the DBD:Oracle installation with DBI 1.14, 1.15
and 1.16. It compiles when I use perl Makefile.PL -8 but the make test
produces
a couple of errors. Attached is the details of my perl installation.
Thanks, George
On Fri, 1 Jun 2001 15:50:04 +0530 (IST), Suresh Kannan wrote:
I would like to access Microsoft Access database file ie .mdb, through
perl under Unix/ Linux platform. Please guide me whether this is possible
or not with some resources.
Not directly. You can connect to a Windows machine which
Look into Perlscript. It's not really an answer to can ASP implement
DBI, but it's a start.
At 07:57 PM 5/31/01 -0600, Glenn Emery wrote:
Hi All,
Please excuse the ignorance...
Very new to this and have gotten an Access Database ported over to MySQL now
I am hitting the ASP
Hi,
Okay, I've attempted to debug this to no-avail on my own so I'm would
really appreciate some help. Here is my setup..
Oracle-client: 8.1.6 (full install minus database)
Perl: 5.6.1 with threading
OS: Solaris 2.7 sparc
DBI: 1.16
DBD: Oracle 1.06
perl -V:
Summary of my perl5 (revision 5.0
ASP can be also implemented with Perl. It's just have to be configured to
handle the perl requests.
Ilya Sterin
-Original Message-
From: Kokarski, Anton
To: 'Glenn Emery'; '[EMAIL PROTECTED]'
Sent: 06/01/2001 1:06 AM
Subject: RE: DBI with Chilisoft ASP
Glen,
interesting question.
Why use ASP to begin with being on the Unix platform, you are asking for
trouble. Although Chillisoft does work, I've known people that worked with
it that ran into problems. One was that chillisoft messed up some server
extensions, etc... I've never used it, so I won't comment any more. Why
Well I got this from your code...
$sqld=?;
$sthd=$dbhd-prepare($sqld);
So evidentally you were doing something wrong that you didn't mean.
Also you might want to read the docs on finish() which in your case you do
not need.
Ilya Sterin
-Original Message-
From: [EMAIL PROTECTED]
To:
What version of DBD::ODBC are you using. Try upgrading to the latest
version, since this used to be a bug in .20 and below.
Ilya Sterin
-Original Message-
From: Krung Saengpole
To: [EMAIL PROTECTED]
Sent: 06/01/2001 2:14 AM
Subject: AW: DSNless connection.
It works now. But I doubt
I hope you plan on having Access on win32 :-) If you want to access the
Access db on win32 from Unix/Linux, must install third party ODBC software
and connect through DBD::ODBC. You can also use
DBD::Proxy/DBI::ProxyServer.
Ilya Sterin
-Original Message-
From: Suresh Kannan
To:
Install DBI
Install DBD-ODBC
Use a DSNLess Connction
On Fri, 1 Jun 2001 15:50:04 +0530 (IST), Suresh Kannan wrote:
I would like to access Microsoft Access database file ie .mdb,
through
perl under Unix/ Linux platform. Please guide me whether this is possible
or not with some
Looking closely at the code, yes I inadvertently left the $sqld=? statement
in, but you'll also see that I never made use of it later.
.Also, I had been connecting through dbiproxy to Postgres on SuSe7.1, I
changed to connecting to PostGres directly and it started working (using the do
I have mysql.sock in another dir other than/temp . A link (redirect) to it failed.
Where is it specified in the dbi module , this default socket dir. This is on red hat
Linux
Thanks
Dexter Coelho
[EMAIL PROTECTED]
Hello,
I sent out a message yesterday asking for guidance in installing the MySQL
driver module, because I got an error message indicating that files like
libmysqlclient cannot be found. Three people kindly responded and advised
me to install the MySQL client first, but the MySQL client had
Thanks All,
The mysql.cnf files points to the correct place where mysql.sock is. but
from the command line when the Perl svript is run is says it can connect
thru /temp/mysql.sock . I ahve already tried to put a symbolic link fro
there to where it is bu does not work. there must be something
Is the path to these libs in your environment set up. Not sure what
environmental variable DBD::Mysql is looking for, but I can imaging that
just setting PATH might help.
Ilya Sterin
-Original Message-
From: William B. Trautman
To: [EMAIL PROTECTED]
Sent: 06/01/2001 1:41 PM
Subject:
- Forwarded message from webmaster [EMAIL PROTECTED] -
From: webmaster [EMAIL PROTECTED]
To: Tim.Bunce [EMAIL PROTECTED]
Subject: Accent insensitive
Date: Fri, 1 Jun 2001 14:30:06 -0300
Hi, Tim. I need your help. But, first off all, dont mind about my english.
Tim, i am using DBI
You've already asked that question here before and got lots of replies, did
that not suit your needs? Tim, like the rest of people, prefers that you
not send any DBI/DBD related questions directly to him, but rather to the
dbi-users list which he subscribes to also and I'm preatty sure he saw
Sorry that I have missed the resolution, but just out of curiosity.
How do you convert it to ASCII.
Anton
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 1:51 PM
To: 'Tim Bunce '; '[EMAIL PROTECTED] '
Cc: '[EMAIL PROTECTED] '
Subject: RE:
Hi,
I need to get information from V$ dynamic table from Oracle. But receive an
Orac-00942 error : table or view not exists
I am using system as connect user.
Here is my code:
use DBI;
$dbuser='system/manager';
$dbh=DBI-connect('dbi:Oracle:host=X.X.X.X;sid=X;port=1521', $dbuser,'')
do you have grants to select from it?
Anton
-Original Message-
From: Linda Xu [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 2:05 PM
To: '[EMAIL PROTECTED]'
Subject: ORA-00942 when query from Dynamic view table
Hi,
I need to get information from V$ dynamic table from Oracle.
Didn't mean it in that way, sorry doesn't make any sense :-) I usually use
ASCII (US-ASCII) in my vocabulary as English characters, but 0xC0, 0xC1,
etc... is a good example of where I should loose that habbit.
What I ment was for example you can convert 0xC0-0xC5 to 0x41 which will
convert all
Hi Ilya,
I understood what you meant I knew you were meaning converting all accented
to their replacements.
I just didn't know if there is a function/module in perl to do that or if
you create your own mapping. Now I know
Thank you for sharing the knowledge,
Anton
-Original Message-
Thanks Again All,
But does someone know if there is a config file for th DBImodule or foe
DBD.pm/
Dexter
- Original Message -
From: Greg Meckes [EMAIL PROTECTED]
To: Dexter [EMAIL PROTECTED]; David Block [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, June 01,
I'm trying to install DBI::Pg-1.00 All goes well until testing, when I get
the result below. It seems not to be able to connect to DBI. I'm running
rh7.1 with postgresql 7.1.1, perl 5.6.1,
DBI-1.16. libpq.so's are in /usr/lib.
Any help appreciated.
jay
..
Configuring Pg
Remember to
Is there anyone who can help me address this problem?
Well, one of the easiest ways is to include more information, Actual
error messages (compiler statement), maybe the makefile ..., perl -V.
I just built DBD::mysql on our Sun machine. If bin directory (where the
mysql applications live) is
What I do is: export PERL5LIB=/full/path/to/my/dbi/lib
To confirm the correct path is defined:
Use perl -V and perl -MDBI -e 'print $DBI::VERSION,\n'
Thomas
On Fri, Jun 01, 2001 at 12:21:26PM +0200, [EMAIL PROTECTED] wrote:
Hi,
We have several servers that use DBI 1.13 which I want to
39 matches
Mail list logo