DBD ODBC

2011-08-23 Thread Jason Lewis
would be appreciated. Thanks Jason DBI Version 1.616 DBD ODBC 1.31 Perl 5.14.1 Easysoft ODBC to ODBC bridge 2.0.0 Database Server: Windows 2008 R2 / MS SQL 2008 R2 [root@BETA DBD-ODBC-1.31]# perl Makefile.PL ** Remember to actually *READ* the README file! And re-read it if you have any

RE: DBD ODBC

2011-08-23 Thread Jason Lewis
). NOTE: Not all distributions of the unixODBC Driver Manager contain the GUI components. This distribution contains unixODBC 2.2.12 -Original Message- From: eric.b...@barclayscapital.com [mailto:eric.b...@barclayscapital.com] Sent: Tuesday, August 23, 2011 12:34 PM To: Jason Lewis; dbi

Re: Error 'making DBD:Oracle 1.28 on Cygwin W

2011-03-24 Thread Jason Thurston
versions, different Oracle versions. Alexander On 03/24/2011 12:15 AM, Jason Thurston wrote: Hello, Does anyone have any ideas where to go from here? I think perl Makefile.PL is successful but I get an error when trying the next step make. The Error I get when trying to make

Re: Error 'making DBD:Oracle 1.28 on Cygwin W

2011-03-24 Thread Jason Thurston
it is in all the other README's) $ grep ORACLE_USER_ID README.win64.txt README.win64.txt:Next you will need to set the ORACLE_USER_ID to a valid user README.win64.txt:c:\DBD-Oracleset ORACLE_USER_ID=system/system@XE Thanks, Jason On Thu, Mar 24, 2011 at 2:05 PM, Jason Thurston jason.thurs

Fwd: Error 'making DBD:Oracle 1.28 on Cygwin W

2011-03-23 Thread Jason Thurston
Hello, Does anyone have any ideas where to go from here? I think perl Makefile.PL is successful but I get an error when trying the next step make. The Error I get when trying to make is /home/foo/DBD-Oracle-1.28/oci8.c:4619: undefined reference to `_OCIServerRelease'.  See Below for details. I

Help Installing DBI on Sun solaris

2008-10-29 Thread Jason Barna
ignored *** Error code 1 make: Fatal error: Command failed for target `Perl.o' -- Jason A. Barna Illinois State University 3500 Telecommunications Networking Normal, IL 61790-3500 (309) 438-2752 (309) 438-7220 FAX

RE: trouble installing DBD:DB2

2006-02-09 Thread Jason Friedman
$ make cp DB2.pm blib/lib/DBD/DB2.pm cp lib/Bundle/DBD/DB2.pm blib/lib/Bundle/DBD/DB2.pm ... Running Mkbootstrap for DBD::DB2 () chmod 644 DB2.bs rm -f blib/arch/auto/DBD/DB2/DB2.so gcc -shared DB2.o dbdimp.o -o blib/arch/auto/DBD/DB2/DB2.so -L/home/db2inst1/sqllib/lib -ldb2

trouble installing DBD:DB2

2006-02-07 Thread Jason S. Friedman
Hi, help appreciated. I read the README and CAVEATS and did not see a solution to this. $ uname -a Linux vmddbm302.storeperform.com 2.6.9-22.0.1.ELsmp #1 SMP Tue Oct 18 18:39:02 EDT 2005 x86_64 x86_64 x86_64 GNU/Linux $ perl Makefile.PL Configuring DBD::DB2... Remember to actually read the

Re: MySQL 4.1.10 + DBD-MySQL 2.9003 Incompatibility

2005-02-28 Thread Jason Johnson
to work great. Randy, copied you just to say thanks :) - Jason Johnson On Feb 25, 2005, at 5:47 PM, Ron Savage wrote: On Fri, 25 Feb 2005 13:01:04 -0800 (PST), William R. Mussatto wrote: Hi Jason  I am running MySQL 4.1.10 and ActivePerl 5.8.6.811 on Windows  2003. When I upgraded MySQL from

MySQL 4.1.10 + DBD-MySQL 2.9003 Incompatibility

2005-02-25 Thread Jason Johnson
dll of the MySQL libraries in the correct location, everything worked fine. This is why I must assume that there is a DBD-MySQL package that has the correct implementation for the new version of MySQL. Any help would be much appreciated. Thanks in advance, Jason

Re: Problem retrieving Number Data (Oracle)

2004-11-02 Thread Jason White
FYI DBD::Oracle 1.06 is over 4 years old. Yes, was aware of that to my own frustration. Was able to work with sysadmin to get upt to 1.14 at least ... an advance of 2.5 years at least. Please generate a trace file (level 4 should be detailed enough). Here's the level 4 trace output, I focused

Re: Problem retrieving Number Data (Oracle)

2004-11-02 Thread Jason White
See below ... On Nov 2, 2004, at 3:23 PM, Tim Bunce wrote: On Tue, Nov 02, 2004 at 02:56:10PM -0500, Jason White wrote: FYI DBD::Oracle 1.06 is over 4 years old. Yes, was aware of that to my own frustration. Was able to work with sysadmin to get upt to 1.14 at least ... an advance of 2.5 years

Problem retrieving Number Data (Oracle)

2004-11-01 Thread Jason White
familiar with tcsh. Again .. thanks in advance, Jason

Core dump at process exit time, I think

2004-09-14 Thread Mark Jason Dominus
I'm using DBI 1.43 as part of a plugin module for the Radiator RADIUS protocol server. The server forks child processes to handle incoming requests. I believe that the children are dumping core at the time that they exit. Here is the stack backtrace from the core: current thread: [EMAIL

Re: $DBI::err not reset before connect_cached()

2004-04-21 Thread Jason E. Stewart
Tim Bunce [EMAIL PROTECTED] writes: $DBI::err- the error code of the last DBI method call. $DBI::errstr - the error message of the last DBI method call. NOTE: the values of these variables is guaranteed to be valid only after a method has failed. But if the DBI

Re: $DBI::err not reset before connect_cached()

2004-04-20 Thread Jason E. Stewart
Tim Bunce [EMAIL PROTECTED] writes: Here's the script: Ah, okay. Looking at the trace I see what's going on. The connect_cached() method perhaps ought to explicitly reset the error state of the $dbh because it's separate to the $dbh error state and the $dbh method calls it uses don't

Re: $DBI::err not reset before connect_cached()

2004-04-19 Thread Jason E. Stewart
Tim Bunce [EMAIL PROTECTED] writes: On Sat, Apr 17, 2004 at 06:34:15PM +0530, Jason E. Stewart wrote: Hey All, Using DBI 1.41 and DBD::Pg 1.32 with mod_perl 1.29.0.2 and I get a strange situation. When I'm using a DB handle that ends in an error condtion, the next time my

$DBI::err not reset before connect_cached()

2004-04-17 Thread Jason E. Stewart
Hey All, Using DBI 1.41 and DBD::Pg 1.32 with mod_perl 1.29.0.2 and I get a strange situation. When I'm using a DB handle that ends in an error condtion, the next time my mod_perl script calls connect_cached() if I check $DBI::err it is still set to the last error that happend - not any error

MySQL DBIx feedback

2004-03-28 Thread Jason Armstrong
I was attempting something very simple: $ mysqladmin create test mysql create table t ( name varchar(64) ); #!/usr/bin/perl -w use DBIx::Recordset; my $db = new DBIx::Database ( { '!DataSource' = 'DBI:mysql:test', '!Username' = 'jason

Re: MS ACCESS text field truncated

2004-03-05 Thread Jason
for the $dbh-LongTruncOk and $dbh-LongReadLen properties. -Original Message- From: Jason Q. [mailto:[EMAIL PROTECTED] Sent: Thursday, March 04, 2004 12:50 PM To: [EMAIL PROTECTED] Subject: MS ACCESS text field truncated Hi there, I am using DBI to access Microsoft ACCESS database. I

Re: MS ACCESS text field truncated

2004-03-05 Thread Jason
news:78E0B682C9508740B37610A9342E9DCD034A90FE@ hqex1.sandisk.local... Look in the docs for the $dbh-LongTruncOk and $dbh-LongReadLen properties. -Original Message- From: Jason Q. [mailto:[EMAIL PROTECTED] Sent: Thursday, March 04, 2004 12:50 PM To: [EMAIL PROTECTED

MS ACCESS text field truncated

2004-03-04 Thread Jason Q.
Hi there, I am using DBI to access Microsoft ACCESS database. I found the data of text field logged by DBI has been truncated to 50 characters. I have changed the field size from 50 to 255, but it still doesn't work. Anyone can help? Thanks, J.

How not to get worm emails (was Re: Hello)

2004-01-31 Thread Jason E. Stewart
Gold, Samuel (Contractor) [EMAIL PROTECTED] writes: The message I received was removed by MailSweeper. I know that there is a new virus called Mydoom.B that is going around. Here is what I found on Symantec's site. [EMAIL PROTECTED] is a mass-mailing worm that arrives as an attachment

bug in quote_identifier in DBD::Pg-1.31

2003-11-28 Thread Jason E. Stewart
Hi, If I call quote_identifier('foo') in 1.22 it returns foo. If I make the same call in 1.31 it returns \foo\ which is causing DB errors in every SQL statement that uses it in Pg-7.3.4. Cheers, jas.

Re: invoking sub/methods shortcut

2003-10-02 Thread Jason E. Stewart
John W. Krahn [EMAIL PROTECTED] writes: [EMAIL PROTECTED] wrote: Can I do something like this? from $sth = getVUser($dbh, $u, $d); return $sth-rows(); to return (getVUser($dbh,$u,$d))-rows(); I find this more readable return getVUser($dbh,$u,$d)-rows(); Cheers, jas.

Re: DBD::Pg Release Candidate 1.31_5

2003-09-12 Thread Jason E. Stewart
Rudy Lippan [EMAIL PROTECTED] writes: - Moved the quoting of bind values out of execute() and into bind -- as there is no need to requote the value every time execute is called. Does this mean that it is not necessary to explicitly quote any bound

Proper usage of DBI::connect_cached

2003-05-31 Thread Jason Dixon
), particularly since I'm using MySQL/SSL. connect_cached appears to be the perfect solution. My tests so far confirm the expected behavior, but I'd just like to see if the list has any caveats on applying the method in this way. TIA, -- Jason Dixon Argus Network Systems http://www.argus-networks.com

Question

2003-03-25 Thread DeCorte, Jason - NASHCCON
Do you have a version of DBD::Oracle that works with Oracle 9i databases? Thanks, Jason

RE: libudbc.h

2003-01-29 Thread Jason Czerak
. I don't need complex queries. just one simple select on a table for htis project. Normally I deal with DBD::Pg and not MsSQL; Thanks for the help anyones guys. -- Jason It probably means you are not setting your ODBCHOME variable correctly to be able to find where unixODBC has been installed

Re: DBD-Sybase FreeTDS -- how to make work??

2003-01-29 Thread Jason Czerak
. do a search and replace on that like is says.. I think the author ment to say DO BOTH not OR. -- Jason I'm trying to get DBD-Sybase and FreeTDS to work together. When I try to connect to the server I'm getting: perl: relocation error: /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi

libudbc.h

2003-01-28 Thread Jason Czerak
When Im compiling DBD-ODBC-1.04 Its looking for a file called libudbc.h A search even on good turns up little. The ODBC client I installted was unixODBC-2.2.4.. Any ideas? -- Jason

Re: DBD::Pg Authentication

2002-12-16 Thread Jason E. Stewart
Roderick A. Anderson [EMAIL PROTECTED] writes: I can't seem to find it in the Cheetah book and it isn't mentioned in The man page so I ask. Does the DBD understand the different types of authentication that PostgreSQL can do? IE, if I've sent up my database to allow access using md5

Re: DBD::Pg timings

2002-11-23 Thread Jason E. Stewart
Hey All, I'd like to start off by saying that I've happily resolved my insert problems. The conclusion was extra baggage in un-needed constraints and triggers, especially triggers. So, thanks everyone (especially Tom Lane) for helping me figure this out. David Duff [EMAIL PROTECTED] writes: i

Re: DBD::Pg timings

2002-11-22 Thread Jason E. Stewart
Paul Boutros [EMAIL PROTECTED] writes: I'm having similar problems with DBD::ODBC and I wanted to clarify my understanding of a couple of things you're mentioning here! On Thu, Nov 21, 2002 at 09:25:13AM -0700, Jason E. Stewart wrote: I'd be grateful if someone could give me a reality

Re: DBD::Pg timings

2002-11-22 Thread Jason E. Stewart
David Duff [EMAIL PROTECTED] writes: i just did some performance tests using DBD::Pg - here are quick results. Awesome David, thanks for this. After reviewing my DB design I realized that I had some fkey constraints that I didn't need to have and this was probably slowing things down. I'm

Stored Procedure Return value Parameter binding

2002-06-27 Thread Jason Luros
. Thanks alot, Jason Luros DBA/Programmer Qualys, Inc. (650) 801-6125 [EMAIL PROTECTED]

FW: Request for assistance

2002-05-01 Thread Jason Shaw
-Original Message- From: Jason Shaw [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 10:13 AM To: [EMAIL PROTECTED] Subject: Request for assistance Hi, I am trying to hunt down an answer for the following error: I suspect that it is a missing file that needs to be copied

Returning rows updated

2002-03-27 Thread Jason Ostrom
I'm using DBI::Sybase to connect to a MS-SQL server, and simply struggling with how to find out how many rows were actually updated on a UPDATE, but the rows method and the return value of execute both return -1. According to Descartes and Bunce's Perl DBI book, this means the number of rows

Re: Returning rows updated

2002-03-27 Thread Jason Ostrom
as well. Must a problem with the underlying code. Michael/Stacey, thanks for trying. Any more suggestions? On Wed, 27 Mar 2002, Michael Peppler wrote: Jason Ostrom writes: I'm using DBI::Sybase to connect to a MS-SQL server, and simply struggling with how to find out how many rows

RE: Float vs. double in MySQL

2002-03-18 Thread Jason Erickson
Hi Peter, are you saying that FLOAT(16,3) is not a valid declaration for Mark's 'float_col', or that there's something in MySql that won't do it?? I can't find anything in Monty's MySql book (Appendix B, pg. 502) that indicates this would be an invalid declaration... -Original Message-

Shorter way to define placeholders...

2002-03-15 Thread Jason Erickson
Jason

MySql DROP database problem

2002-03-07 Thread Jason Erickson
nothing in the mysql.err file to indicate any type of error Jason Erickson

Selecting the nth to nth+5 rows

2002-02-26 Thread Jason Wilkes
Hi folks, I'm not a DBI newbie, but am struggling with some code. I can happily make a select field1, field2 and return all rows to a web page. However I want to return only a partial number of rows ( say 5 ) on successive pages - much like a search engine (where page 1 give results 1-10, and a

BLOB from FOXPRO ?

2002-01-29 Thread Jason Wu
Hi All, I try to use the DBD-ODBC from linux to load image from visual foxpro ? The other type of data is ok to get. Do I need to use another module to get the BLOB from foxpro ? Regards Tom Wu _ Are you a Techie? Get Your Free

RE: Important: Subclassing and Merging DBIx::AnyDBD into the DBI

2002-01-06 Thread Jason W. May
briefly mentioned a SalesOrder scenario earlier, perhaps that could be expanded. Thanks, -Jason

mysql_insert_id and transactions

2001-11-30 Thread Jason Hall
allrighty, here is the trouble I'm having. I'm tyring to do a transaction in mysql/innodb in perl with the following basic flow eval{ Insert my first record get the insert_id (using $sth-{mysql_insert_id}) now perform other inserts that need that key

Re: ANNOUNCE: DBIx::Librarian 0.1

2001-11-16 Thread Jason W May
On Thursday 15 November 2001 08:31 am, Terrence Brannon wrote: On Wednesday, November 14, 2001, at 10:33 PM, Jason W May wrote:     The implementation provided by DBIx::Librarian is sufficiently     different from other related modules (in particular, SQL::Catalog)     that this module

ANNOUNCE: DBIx::Librarian 0.1

2001-11-15 Thread Jason W May
. -Jason

installing DBI

2001-10-29 Thread Jason Hale
I get the following message when I run the make command on my system: I install the latest version of g++, but I think I am missing which variable needs to be set in order for this to work. Please help. Jason mkdir blib mkdir blib/lib mkdir blib/arch mkdir blib/arch/auto mkdir blib/arch/auto

installing DBI::Pg as root

2001-10-15 Thread Jason A. Banico
variables? (There shouldn't be, since perl Makefile.PL ran ok.) Thanks. Jason

Re: Unix GUI tool for Oracle (and others like mysql in future)

2001-10-15 Thread Jason Woodward
with the Free Edition of Qt (if there is even a difference between the full and the free edition, as far as the libraries go). jason PD Miller wrote: At 13:23 +0100 15/10/01, Tim Bunce wrote: If you're using Oracle from unix (or even windows) then this looks very interesting

Difference of DBI under Linux and Solaris

2001-08-28 Thread Jason Smith
about, I'll be happy to offer it. Thanks, Jason Smith

Re: #! line parsing

2001-07-07 Thread Jason Waugh
safe to assume that /usr/bin/perl is the location of the perl interpreter on a *NIX box. Jason..

Installation question

2001-06-23 Thread Jason Purdy
, btw), despite me giving it other parameters in the 'perl Makefile.PL --testuser=purdy --testpassword=password'. Any ideas? Thanks in advance, Jason

DBI Mysql socket problems

2001-06-05 Thread Jason Scharlach
to connect to a non-existant socket when the actual daemon specifies the correct one? Any help would be greatly appriciated. Jason

Re: sql table joins

2001-05-01 Thread Jason Waugh
1 WHERE failed_parts IN ( SELECT valid_parts FROM table2) I don't know what you are going to do to figure out what to do with failed_parts that are invalid, but I suppose that's for the next step in your project...h Thanks, Jason Waugh Systems Development COLLECTCORP, INC. (416)935-2883