:32 AM
To: beginners@perl.org
Subject: Perl connecting to Oracle and SQL Server databases ...
Hi all,
Does anyone know of any resource that I can go to for example on
connecting to Oracle and Microsoft SQL Server databases using Perl
??? I need more than connecting to the database, some e
ginners@perl.org
>Subject: Perl connecting to Oracle and SQL Server databases ...
>
>Hi all,
>
>Does anyone know of any resource that I can go to for example on
>connecting to Oracle and Microsoft SQL Server databases using Perl
>??? I need more than connecting to the databa
Hi all,
Does anyone know of any resource that I can go to for example on
connecting to Oracle and Microsoft SQL Server databases using Perl
??? I need more than connecting to the database, some example on how
to do SELECT, INSERT, UPDATE and DELETE will be very helpful as well.
Thanks
On Sunday 19 February 2006 12:56, Octavian Rasnita wrote:
[ . . ]
> The database I need to keep is not very very big, but too big for MySQL,
> and the most important thing is the speed of selections/updates.
[ . . ]
DB_File and BerkelyDB
are two Perl modules that use the embedded database which
Owen Cook am Sonntag, 19. Februar 2006 22.21:
> I suggest you use Matt Sergeant's DBD::SQLite a Self Contained RDBMS in a
> DBI Driver.
>
> It rocks
Owen, thanks a lot for this tip!!!
The aggregate function feature looks very promising
:-)
Hans
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For a
On Sun, 19 Feb 2006, Octavian Rasnita wrote:
>
> I need to recommend/use a better database than MySQL that should work well
> with perl.
> I have read some web pages about PostgreSQL and I have seen that it has a
> procedural language PLPERL, while Oracle doesn't have such a thing. I have
> also
Hi,
I need to recommend/use a better database than MySQL that should work well
with perl.
I have read some web pages about PostgreSQL and I have seen that it has a
procedural language PLPERL, while Oracle doesn't have such a thing. I have
also seen that Oracle is a little better than PostgreSQL.
Yup tht was the prob
Thanks for pointing it out :-)
- Original Message -
From: "Michael Glaesemann" <[EMAIL PROTECTED]>
To: "Gayatri" <[EMAIL PROTECTED]>
Cc: "S, karthik (IE03x)" <[EMAIL PROTECTED]>;
Sent: Friday, November 18, 2005 3
On Nov 18, 2005, at 18:56 , Gayatri wrote:
$host = "nnn.nn.nnn.nn"; ## 'n' is a number, host is ip address.
$databaseName = "MyDatabase";
$dbh = DBI->connect('DBI:mysql:database=$databaseName;host=$host',
$userName,
$password, {RaiseError => 1}) || die "Can not connect to database
$DBI::errs
D-mysql, Perl 5.8.6 and windows.
Regards,
Gayatri.
- Original Message -
From: "S, karthik (IE03x)" <[EMAIL PROTECTED]>
To: "Gayatri" <[EMAIL PROTECTED]>;
Cc: "Alfred Vahau" <[EMAIL PROTECTED]>
Sent: Friday, November 18, 2005 10:57 AM
Subje
Hi,
Thanks a lot for yr kind help :-)
It worked finally :-)
Regards,
Gayatri.
- Original Message -
From: "Pant, Hridyesh" <[EMAIL PROTECTED]>
To: "'Gayatri'" <[EMAIL PROTECTED]>;
Sent: Friday, November 18, 2005 12:27 PM
Subject: RE: Query on
: Query on databases
- Original Message -
From: "Gayatri" <[EMAIL PROTECTED]>
To: "S, karthik (IE03x)" <[EMAIL PROTECTED]>
Sent: Friday, November 18, 2005 11:29 AM
Subject: Re: Query on databases
> Hi Karthik,
> I downloaded DBD-Mysql frm the give
- Original Message -
From: "Gayatri" <[EMAIL PROTECTED]>
To: "S, karthik (IE03x)" <[EMAIL PROTECTED]>
Sent: Friday, November 18, 2005 11:29 AM
Subject: Re: Query on databases
> Hi Karthik,
> I downloaded DBD-Mysql frm the given location and i
opy of any e-mail and any printout thereof.
-Original Message-
From: Gayatri [mailto:[EMAIL PROTECTED]
Sent: Friday, November 18, 2005 10:36 AM
To: beginners@perl.org
Cc: Alfred Vahau
Subject: Re: Query on databases
Thanks,
I tried installing module using PPM.
but its throwing following
500 Can't connect to ppm.ActiveState.com:80 (connect: Unknown error)
Im connceted to the internet, then wht could be the problem and solution?
Regards,
Gayatri.
- Original Message -
From: "Alfred Vahau" <[EMAIL PROTECTED]>
To:
Sent: Friday, November 18, 2005 5:19 AM
November 16, 2005 9:58 AM
Subject: Re: Query on databases
- Original Message -
From: "Gayatri" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, November 16, 2005 2:39 PM
Subject: Query on databases
Hi all,
Im a beginner in databases.
Can you please let
l 5.8.6
Regards,
Gayatri
- Original Message -
From: "Michael David" <[EMAIL PROTECTED]>
To: "Gayatri" <[EMAIL PROTECTED]>;
Sent: Wednesday, November 16, 2005 9:58 AM
Subject: Re: Query on databases
>
> >- Original Message -
> >From: &qu
- Original Message -
From: "Gayatri" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, November 16, 2005 2:39 PM
Subject: Query on databases
Hi all,
Im a beginner in databases.
Can you please let me know which DBD and DBI is required if I m using MySQL
database.
I
Hi all,
Im a beginner in databases.
Can you please let me know which DBD and DBI is required if I m using MySQL
database.
I tried using
use DB_File;
It throws error as follows.
Can't locate DB_File.pm in @INC (@INC contains: C:/Perl/lib C:/Perl/site/lib .)
Please tell me what is mi
[Siegfried Heintze] Where would I start looking to find the modules that
would allow me to programmatically create a MSAccess database? I looked in
Win32::ODBC but no luck there. Microsoft has three different ways (APIs) to
do this (kinda like the perl slogan): DAO, ADOX and some function that
begi
From: "Paul Kraus" <[EMAIL PROTECTED]>
> I can't figure out how to connect to the database engine with odbc.
It's easiest if you first create a DNS using the "Data Sources
(ODBC)" applet in "Administrators tools".
Se the docs of DBD::ODBC for examples how to connect then.
Jenda
= [EMAIL PRO
I can't figure out how to connect to the database engine with odbc.
Paul Kraus
Xp pro sp1 workstation.
> -Original Message-
> From: Aman Raheja [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 03, 2003 12:23 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Datab
gt;
Sent: Wednesday, December 03, 2003 11:18 AM
Subject: Databases - MS Sql Server Desktop Engine
> Is there a DBI driver for the MS Sql Server Desktop Engine?
>
> Paul
>
>
> --
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTEC
Is there a DBI driver for the MS Sql Server Desktop Engine?
Paul
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
The other approaches mentioned were certainly good beginnings, but I am
wondering if something possibly faster and easier is possible.aka...
Is it a *requirement* or just an assumption that the data be stored in a
single file? What about possibly creating individual files for each
date? T
Janek Schleicher wrote at Tue, 09 Jul 2002 18:48:00 +0200:
> rand($#chars) gives a random
> number in the range of 0 .. $#chars-1
Sorry not completely correct,
rand($#chars) gives a random number < $#chars,
what is in chars[ rand($#chars) ] implicitly rounded down.
However, the last element of
jffusion wrote at Tue, 09 Jul 2002 17:33:35 +0200:
> Hi
>
> I have my script to generate a random username and password and print it in the
>browser window
>
> print 'Username: ', random_string(), "\n";
> print 'Password: ', random_string(), "\n";
>
> sub random_string {
>
> my($string) =
From: [EMAIL PROTECTED]
> Now I need to define the username and password generated so that they
> are written to the htaccess, htpasswd, and members.db file
>
> here is the script
>
> # everything ok, let's write to database and send welcome email
> open (DATABASE, ">>$databas
On Jul 9, [EMAIL PROTECTED] said:
>print 'Username: ', random_string(), "\n";
>print 'Password: ', random_string(), "\n";
>
[snip]
>
># everything ok, let's write to database and send welcome email
>open (DATABASE, ">>$database");
>flock (DATABASE, 2);
>print DATABASE "$username|$password\n";
>fl
Hi
I have my script to generate a random username and password
and print it in the browser window
Now I need to define the username and password generated so that they are
written to the htaccess, htpasswd, and members.db file
here is the script
# Here we define the variables
$htpasswd = 'c:\a
On Tuesday, June 4, 2002, at 05:33 , William West wrote:
[..]
> i would like to know what is needed for perl
> to 1) interface with any third party database
The simplest solution is to use the generic sorts
of DB queries you can construct in say SQL - but I
fear that these folks may not be exp
i would like to know what is needed for perl
to 1) interface with any third party database
but mainly
2) interface with progress.
now, i'm not worried about getting a tutorial- just a
way to start... (tried using google and CPAN but
haven't been able to get good results (probably my lack
o
Are there any good perl databases out there ?
and
Any perl Directory ( or Business Directory ) scripts out there too.
Thanks-
Rick
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
At 11:39 AM 8/23/01 -0500, [EMAIL PROTECTED] wrote:
>I am in the process of developing perl code to create and populate a
>oracle database. Have anyone out there in PerlLand ever developed a
>process that will create a oracle database, tablespaces and create tables
>and indexes? If yes, would yo
I am in the process of developing perl code to create and populate a
oracle database. Have anyone out there in PerlLand ever developed a
process that will create a oracle database, tablespaces and create tables
and indexes? If yes, would you mind sharing your code? DB2 would work
just as we
35 matches
Mail list logo
