Hi Tim,
I need your help with connecting perl to analysis services of sql
server 2005 via dbi.The default connect goes to database engine.I have to
change this and connect to analysis service i.e Sql server type = Analysis
service.I browsed in net and not able to find anything much useful so
I'm currently writing a non-OO perl module where the methods exported
communicate with a database using DBI.
My question is what is the best practice for connecting and
disconnecting from the database within a perl module like this?
Should I provide connect and disconnect methods that the user is
hould have failed. If you installed a PPD
in ActivePerl, you miss that step.
-Original Message-
From: Zhou, Qing [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 08, 2005 5:46 PM
To: 'dbi-users@perl.org'
Subject: Question on DBI connection to Oracle
First of all, thank you for
: Saturday, January 08, 2005 5:46 PM
To: 'dbi-users@perl.org'
Subject: Question on DBI connection to Oracle
Hello,
First of all, thank you for taking the time to help me. I am a beginner to
DBI, and I am very frustrated with not being able to connect to Oracle from
my Sun Solaris box. I ins
Hello,
First of all, thank you for taking the time to help me. I am a beginner to
DBI, and I am very frustrated with not being able to connect to Oracle from
my Sun Solaris box. I installed DBI and DBD modules, and tried to run the
following test script:
#!/usr/bin/perl
use CGI;
use DB
On July 29, 2004 9:53 am, Jay harris wrote:
> I am onsite at a client, and they use AIX/DB2-UDB V8. They have an
> automated scheduling package that starts jobs using "su" super user, and
> then passes the account like a nohup would do. My problem is that the dbi
> connect seems to require a passwo
I am onsite at a client, and they use AIX/DB2-UDB
V8. They have an automated scheduling package that starts jobs using "su" super
user, and then passes the account like a nohup would do. My problem is that the
dbi connect seems to require a password, but I do not have access to the
password.
On Mon, May 31, 2004 at 12:59:55PM +0200, Paolo Santancini wrote:
> Hello all, I wrote this simple code :
>
> -
> require 'DBI';
> dbh = DBI.connect('DBI:Mysql:test','username','password');
> dbh.disconnect;
>
> -
> require 'DBI';
> dbh = DBI.connect('DBI:Mysql:test','username','password');
> dbh.disconnect;
> --
> When I try to execute it, I've this message :
> "Too many argouments for connect at filename ...
Hello all, I wrote this simple code :
-
require 'DBI';
dbh = DBI.connect('DBI:Mysql:test','username','password');
dbh.disconnect;
--
When I try to execute it, I've this message : "Too many argouments for
Hello
Included with the ActiveState Perl's DBI module is the dbiproxy.bat
file. It puts it in the bin directory of you perl installation (
c:\perl\bin ) by default. It provides the "wrapper" to DBI::Proxyserver.
Peter
PerlDiscuss - Perl Newsgroups and mailing lists wrote:
I have a question al
I have a question along this line.
I have:
Windows NT which has MS Access with ODBC driver.
Linux w/Apache2 and am trying to write Perl cgi.
What I want to do is, User enter CustomerID at web page, then CGI will
query customer info using ODBC and display the info to user.
I found DBI::Proxy and
Tim,
I have a few questions regarding proxy server.
I'm trying to create a connection form 'machineA' to 'machineB'
using 'machineC' as the proxy (Because ella have all the necessary driver to
connect to the Oracle database in 'machineB'). I believed the three machines
have everything they ne
[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Oracle / Apache::DBI connection problems
This is a forward since the original message bounced. Figured it
would, the address was 5 years old. :^)
- Forwarded message from "Hartog C. de Mik" <[EMAIL PROTECTED]> -
From: &
more acceptable
they will be... who does not is ruined by flatterers" -- Machiavelli
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: 27 September 2003 01:48
> To: [EMAIL PROTECTED]
> Subject: Any sample DBI connection caching
>
>
&
[EMAIL PROTECTED] said:
> Sorry for the lack of info to my question. I have the connection working
> fine. I wanted to know what happened to the connection when I don't
> literally issue a $dbh->disconnect(). Does the connection closes
> automaitcally or the pointer is still out there wasting away
[EMAIL PROTECTED] said:
> Can anyone show me a sample of connection caching for "use DBI;" within
> cgi/mod_perl? Currently, I am using "use DBI;" not Apache::DBI because I
> can't get Apache::DBI to work.
I'm not entirely sure what you mean by "connection caching", but I think I
might have an ans
Sorry for the lack of info to my question. I have the connection working
fine. I wanted to know what happened to the connection when I don't
literally issue a $dbh->disconnect(). Does the connection closes
automaitcally or the pointer is still out there wasting away resources?
I am using this in a
Just adding use DBI doesn't create a connection. I am not familiar with
mod_perl, but in general you can/should call $dbh->disconnect() once you are
finished with the database. See perldoc DBI
Quoting [EMAIL PROTECTED]:
> Does the connection disconnect automatically when I'm using it in apach
Can anyone show me a sample of connection caching for "use DBI;" within
cgi/mod_perl? Currently, I am using "use DBI;" not Apache::DBI because I
can't get Apache::DBI to work.
thanks,
-rkl
Does the connection disconnect automatically when I'm using it in apache
under cgi or mod_perl using "use DBI;"?
thanks,
-rkl
. Persico
Cc: [EMAIL PROTECTED]
Subject: Re: Passing DBI connection between processes
Hi Matthew,
The question is connected with the task to create so named Connection Pool Server (see
the letter attached), so I _need_ to create connection handle in one process and pass
it to another and vice
letter.
Probably you can advice me how can I solve this ?.
Ildar.
- Original Message -
From: "Matthew O. Persico" <[EMAIL PROTECTED]>
To: "Ildar Gabdulline" <[EMAIL PROTECTED]>
Sent: Sunday, September 01, 2002 8:22 PM
Subject: Re: Passing DBI connection betwee
Hi,
Is it possible to create DBI handle it one perl process, pass it to the
second perl process, use it and return to the first ?
If it is then how can it be accomplished ?
Ildar.
HI all:
When I am trying to connect to oracle by
my $dbh = DBI->connect("dbi:Oracle:test", "scott", "tiger");, I get the
following error
DBI->connect(gldba) failed: ERROR OCIEnvInit at db_connect.plx line 10
What does this mean? Can anybody help me out.
Thanx
Viji
[ this is pre-CPAN until Monday ]
AppConfig-DBI-0.01.tar.gz
Description: GNU Zip compressed data
NAME
AppConfig::DBI - AppConfig-based support for DBI connection and
connection data
SYNOPSIS
# .cshrc
setenv APPCONFIG /Users/metaperl/.appconfig # dont forget
the dot
work
fine.
Ilya
-Original Message-
From: Example user SuSE Linux 6.2
To: [EMAIL PROTECTED]
Sent: 10/5/01 11:39 AM
Subject: DBI connection from Win to a remote Oracle
Hi, I have not been able to find this on the DBI book or anywhere else
I have a script that uses DBI to connect from a
Hi, I have not been able to find this on the DBI book or anywhere else
I have a script that uses DBI to connect from a linux client to a mysql
server on another linux machine via
a connect(
my $dbh=DBI->connect('DBI:mysql:database_name;host=172.16.160.8',)
statement
This runs fine.
Now this ha
In httpd.conf
Reg's
Oleg
> -Original Message-
> From: eddie iannuccelli [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 06, 2001 4:28 PM
> To: Oleg Mechtcheriakov
> Cc: [EMAIL PROTECTED]
> Subject: Re: Oracle DBI connection working in command line but not
helped in my case.
>
> Reg's
> Oleg
>
>
>>-Original Message-
>>From: eddie iannuccelli [mailto:[EMAIL PROTECTED]]
>>Sent: Thursday, September 06, 2001 3:05 PM
>>To: [EMAIL PROTECTED]
>>Subject: Oracle DBI connection working in command line
THAT' S IT
thank you very much :
Do you think the dbish pb is linked to that ?
Best regards
> ---
>
>>I don't understand what happen since the script work fine under apache
>>user session, nobody user session and root user session (http
ED]]
> Sent: Thursday, September 06, 2001 3:05 PM
> To: [EMAIL PROTECTED]
> Subject: Oracle DBI connection working in command line but not in CGI
>
>
> Hi,
>
> I have already saw similar questions but I think my pb is a
> bit different.
> I wrote a perl script that u
Hi,
I have already saw similar questions but I think my pb is a bit different.
I wrote a perl script that use an oracle 9i DB throug DBI DBD::Oracle.
This script work fine when started from command line but fail when
launched by apache with
the folowing error (from the apache error log) :
--
You've got the connection string and DSN definition confused.
For a DSN-less connection use something like:
my $DSN = 'driver={SQL Server};
Server=.;database=vision;
uid=sa;pwd=secret;';
my $dbh = DBI->connect("dbi:ODBC:$DSN") or die "$DBI::errstr\n";
--
Simon Oliver
Hi,
When I tried to run the perl program, I got the following error. Could
anyone give me a help?
I tried to use the control pane, then ODBC and built a system DSN, the
connection works ok.
Thanks
Jenny
DBI->connect(driver={SQL
Server};Server=.;database=vision;uid=sa;pwd=;QuotedID=no) failed:
On Tue, May 22, 2001 at 09:52:02AM -0500, STAFF wrote:
> I am writing a data replication Utility, that currently pulls a list of
> connection strings from a PG database
>
> The literal value of $sconnect_str is:
> "dbi:Proxy:hostname=eddie;port=3334;dsn=dbi:ODBC:PLAY;",'username','password',
>
On Tue, May 22, 2001 at 09:52:02AM -0500, STAFF wrote:
> I am writing a data replication Utility, that currently pulls a list of
> connection strings from a PG database
>
> The literal value of $sconnect_str is:
> "dbi:Proxy:hostname=eddie;port=3334;dsn=dbi:ODBC:PLAY;",'username','password',
>
I am writing a data replication Utility, that currently pulls a list of
connection strings from a PG database
The literal value of $sconnect_str is:
"dbi:Proxy:hostname=eddie;port=3334;dsn=dbi:ODBC:PLAY;",'username','password',
Which seems to be getting passed just fine to &konnect, as $connec
gt;To: "Julio Santiago" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>Subject: Re: DBI connection - Another issue
>Date: Wed, 4 Apr 2001 12:06:30 -0700
>
>More hints please. Does your script just hang or do you get an error back?
>If an error, which one? A minimum w
for a day.
Give a hobbit a ring and he'll eat fish for an age.
- Original Message -
From: "Julio Santiago" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 9:21 AM
Subject: DBI connection - Another issue
&
]>,
>[EMAIL PROTECTED]
>Subject: Re: DBI connection
>Date: Wed, 4 Apr 2001 17:07:49 +0200
>
>On 4 Apr 2001, at 10:54, Julio Santiago wrote:
>
> > in line: $dbh = DBI->connect($db_name,$user,$passwd,"Oracle");
> >
> > And that is why I
On 4 Apr 2001, at 10:54, Julio Santiago wrote:
> in line: $dbh = DBI->connect($db_name,$user,$passwd,"Oracle");
>
> And that is why I want to find a way to test DBI
The usual syntax is something like
$dbh = DBI->connect("dbi:Oracle:$db_name", $user, $passwd)
or die "Can't connect:
Hi there,
Is there a way to test that my DBI is working properly.
I have tried to install DBI & DBD on my solaris box without success.
The Oracle Web Server has a Perl Cartridge that contains DBI & DBD, but when
trying to connect to the database it returns an error:
"Perl cartridge encounters
43 matches
Mail list logo
