dbi Questions
1
I have a targets pipeline which should fill and use a DBI database (in this case duckdb. Both SQL as well as duckdb are chosen for performance reasons).
How can I effectively use {targets} in combi...
Riana asked 2/10, 2023 at 14:4
5
Solved
I am trying to install DBD::Oracle using the CPAN shell in Strawberry Perl. I initially experienced an error because the Makefile could not locate an OCI library, so I installed the instant client ...
Librium asked 4/12, 2009 at 18:29
9
Solved
I'm using Perl's DBI module. I prepare a statement using placeholders, then execute the query.
Is it possible to print out the final query that was executed without manually escaping the parameter...
Fioritura asked 6/11, 2009 at 12:27
3
Solved
I have a table in SQL server to which I am trying to add data. Before adding the data I want to delete all the existing records, but I do not want to delete the table and recreate it since it has i...
2
Solved
As I have seen here, Beginning with MySQL 8.0.34, the automatic reconnection feature is deprecated. I have a lot of Perl scripts that connect to a MySQL database with something like:
my $dbh = DBI-...
1
When I switched my perl environment from 5.16.0 to 5.24.0 I got a strange behavior that I cannot understand. This code
use DBI;
my $conn = 'dbi:ODBC:sqlserver_xxxx';
my $userid = 'dw_select';
m...
6
Solved
I'm using DBI to query a SQLite3 database. What I have works, but it doesn't return the columns in order. Example:
Query: select col1, col2, col3, col4 from some_view;
Output:
col3, col2, col1, ...
5
Solved
I use Perl and DBI to manage my MySQL tables, querys, etc. How can I show the running time of a query?
If I do a SELECT in the console, the result will be like this:
+-----+-------------+
| id | ...
1
My company has a Perl application in server with IP : 10.10.3.39
And because of the new rule implemented, I must migrate the database to MySQL DB in server with IP : 10.10.1.18
My company DB admini...
3
Solved
I'm working on a Perl6 project, but having difficulty connecting to MySQL. Even when using the DBIish (or perl6.org tutorial) example code, the connection fails. Any suggestions or advice is apprec...
2
Solved
Below is a snippet of my code that I use in R to extract IDs from a PostgreSQL database. When I run the function I get the following warning message from R:
In result_create(conn@ptr, statement)...
Polymorphous asked 15/4, 2020 at 13:4
9
I am getting the following error connecting to an Oracle 11g database using a simple Perl script:
failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var or PATH (Windows) and or NLS set...
Juxon asked 26/5, 2010 at 15:23
12
Solved
I'm running DBI in Perl and can't figure out how, when I run a prepared statement, I can figure out if the returned row count is 0.
I realize I can set a counter inside my while loop where I fetch...
2
Solved
I have a user id, password, database name and datasource details. I want to connect with Perl to a MSSQL server. I just used the following snippet, but I am getting an error.
#!/usr/bin/perl -w
us...
1
Solved
Is there a way to programmatically discover the named arguments for ODBC connections?
For instance, using the "ODBC Driver 17 for SQL Server", the ODBC Data Source Administrator (in Windows) allow...
1
Solved
In ?DBI::dbListTables we can read :
This should include views and temporary objects
And indeed it does.
How can I see only tables though, excluding views ?
I'm using the driver RPostgres::P...
Aesthetic asked 2/3, 2020 at 13:43
7
After upgrading to OSX Mavericks I can't get DBI/DBD to run.
Perl and MySQL are running fine (I can login to mysql and access my tables), but my Perl scripts can't use DBI anymore as the updater r...
Bonnes asked 24/10, 2013 at 12:9
2
Solved
I am attempting to use R to query a large database. Due to the size of the database, I have written the query to fetch 100 rows at a time My code looks something like:
library(RJDBC)
library(DBI)
...
2
Solved
Is there any perl modules implementing function of database and easy to use. I do not need modules used to connect to some database products. I need simple database writing by perl.
Thanks.
...
Digitoxin asked 24/11, 2019 at 22:21
5
Solved
I am running a SQLite database within a Perl CGI script which is being accessed by DBD::SQLite. This is being run as a straight CGI on Apache.
The DBI connection works fine and selects are able to...
3
According to the DBI documentation, it seems I can only get the number of affected rows by the do method.
$rows_affected = $dbh->do("UPDATE your_table SET foo = foo + 1");
How can I get the s...
3
I have a (tiny) dynamic website that is (roughly) a Perl CGI script using a SQLite database. Package DBI is the abstraction layer used in Perl.
About one week ago, I started to see this error mess...
3
Solved
I am trying to figure out what a legacy app does to our mysql databases (plural) as I need to refactor/replace a part of it completely without caring how it does it. I'm just interested in the resu...
2
Solved
I'm trying to do a simple query as prepared statement but have no success. Here is the code:
package sqltest;
use DBI;
DBI->trace(2);
my $dbh = DBI->connect('dbi:mysql:database=test;host=*...
Asberry asked 4/12, 2017 at 10:41
1 Next >
© 2022 - 2024 — McMap. All rights reserved.