Stack Overflow
Stack Overflow

Questions tagged [dbd]

DBD is a common prefix for all perl modules used as database drivers by the DBI module. These drivers hide the internals of different relational database management systems by providing a common API through the DBI module.

Access to relational databases in Perl is usually accomplished by the CPAN DBI module. See also DBI tag wiki entry.

DBI provides a common API for database access that uses separate drivers (DBD::*) internally to handle the specifics of different database management system implementations.

Some of the most popular DBD modules available on CPAN are:

DBD::MySQL
DBD::Oracle
DBD::Pg       (PostgreSQL)
DBD::ODBC
DBD::SQLite
DBD::Informix
DBD::Mock     (for testing purposes) 
DBD::CSV      (limited SQL access for CSV files)
DBD::JDBC
169 questions
0
votes
2 answers

Mac OSX Perl cannot find DBD::mysql in @INC

I have installed CPAN module DBD::mysql via sudo cpan install DBD::mysql in order to run the code below, however I keep getting the error message: Can't locate loadable object for module DBD::mysql in @INC (@INC contains: …
missPamelaHeart
  • 1
  • 2
0
votes
2 answers

Need help to install DBD::Oracle on Cygwin

I want to install the DBD::Oracle module in Cygwin. I have downloaded the Oracle Instant Client (ver 12.1) at C:\Oracle\instantclient_12_1. I have also downloaded the SDK and SQLPlus and extracted them into the instantclient_12_1 dir. The I set my…
user828647
  • 505
  • 1
  • 10
  • 27
0
votes
3 answers

Perl DBD::ODBC Issues with Oracle Date Formats

I am using Perl's DBD::ODBC to connect to an Oracle database. However, an issue arises when I try to execute a select query using a date in the where clause. It seems this issue occurs because of the database's date format being DD-MON-RR (see…
indiguy
  • 505
  • 1
  • 9
  • 21
0
votes
0 answers

MySQL Multiple Databases for User Authentication

I have a few related web sites and it seems rather unfortunate that they have completely separate user databases. I've been contemplating different options on how to unify the databases: Rework the sites to be running on one copy of my content…
Timothy R. Butler
  • 1,097
  • 7
  • 20
0
votes
3 answers

Unable to find mysql_config when installed DBD::mysql on Amazon EC2

I'm running an Amazon EC2 instance (uname -r gives "3.4.43-43.43.amzn1.x86_64") and trying to set up DBD::mysql for use with my Perl scripts. Installing DBD::mysql with cpanm: cpanm --sudo DBD::mysql This returns an error with the following log…
jwarwani
  • 201
  • 3
  • 6
0
votes
4 answers

Unable to use DBD::Oracle from Apache/Mod_Perl

Env: Red Hat Enterprise Linux Server release 6.4 Apache/2.2.15 (Unix) mod_perl/2.0.4 Perl/v5.10.1 Perl v5.10.1 (*) built for x86_64-linux-thread-multi 64 bit Oracle client for 11.2 DBD::Oracle : Oracle Driver for DBI ;…
BBS
  • 175
  • 1
  • 4
  • 11
0
votes
1 answer

perl DBI->connect pops "no route to host" although i can pick host

I have this perl script wrapper.pl #!/usr/bin/env perl use strict; use warnings; use Getopt::Long; use DBI; # input params my $end; my $start; my $url; my @IP; my $host = "localhost"; my $dbname = "flows"; my $username; my $pass; GetOptions …
Tomáš Šíma
  • 834
  • 7
  • 26
0
votes
1 answer

install: missing destination file operand after `PREFIX=~/perlmods'

Trying to install DBD::mysql. Shared hosting. Perl/cpan installed in my home directory using perlbrew. There is no mysql server running on this box, and there shouldn't need to be. Here is the output that I get when doing install…
uhcafigdc
  • 11
  • 1
  • 3
0
votes
1 answer

postgresql autodoc

I want to generate a ER Diagram sort of, of my spatial database i created inside of Postgresql. As i am also new to Postgresql, i am not too sure if the diagramming functionality can be done using whats offered by the PgAdmin (not referring to the…
Barbara Lokes
  • 31
  • 1
  • 1
  • 3
0
votes
1 answer

How to manually specify the column names using DBD::CSV?

I am using DBD::CSV to show csv data. Sometimes the file doesn't contain column names, so we have to manually define it. But after I followed the documentation, I got stuck with how to make the attribute skip_first_row work. The code I have is: #!…
Peiti Li
  • 4,634
  • 9
  • 40
  • 57
0
votes
1 answer

jqgrid ajax with perl cgi and dbd oracle

I have a jqgrid that calls a perl cgi to populate the grid. The cgi is using DBD::Oracle to get the data. The grid is not displaying the data. Debugging the script I have found there is a conflict when the statement is prepared. When I skip the…
Mike
  • 59
  • 1
  • 1
  • 7
0
votes
1 answer

connect failed with SQL-HY001

I am using Perl 5.14.2 on Ubuntu wheezy 64 bit. I am trying to connect to a Pervasive SQL server v9.5 that is installed on a windows 2008 machine. I tested the connection with isql and it works properly, I tested with the following command: isql -v…
ufk
  • 30,912
  • 70
  • 235
  • 386
0
votes
1 answer

How do I get around "DBD::Pg::st execute failed: ERROR: prepared statement already exists " error

A little background: I have a perl script which is performing a number of operations inside of a loop. Inside of the loop, I create a prepared statement like so: // inside loop my $statement = "select xxxx from zzzzzz where $foobar;"; my…
Beau Bouchard
  • 835
  • 11
  • 28
-1
votes
2 answers

DBI SQL_VARCHAR is not supporting, getting error DBD::ODBC::st bind_param failed: Data type is not supported. [typeId=-9] (SQL-HYC00)

I am using Gridgain as database. Perl script is written to read data from xml and insert/update the data to Gridgain database. Passing XML data as hash to following line of code use DBI; use DBD::ODBC; use DBI qw(:sql_types); use…
Pramod
  • 1
-1
votes
1 answer

IMS init empty DB

i've got a problem, that i can't resolve. I want to try to work with IMS. so i make dbdlib, psblib, and now write jcl to init my db. 1://RELOAD EXEC PGM=DFSRRC00,PARM='ULU,DFSURGL0,LIBDBD,,,,,,,,,,,N' 2://STEPLIB DD…
Andrei Kaliachka
  • 35
  • 1
  • 12
1 2 3
…
11
12