Re: Nedd your help to get DBD:Sybase working to connect to SQL Server

2016-05-17 Thread Jeff Urlwin
And, to add, I’ve recently come across a new Microsoft ODBC driver for Linux. I haven’t tested it yet, but I can imagine it may address domain logins for example. It’s on my todo list some day. (I recently tested a different driver for OS X that allowed domain credentials — very cool…) > On

Re: Here is a classic one for you

2015-01-02 Thread Jeff Urlwin
Depending upon a few factors- I'd also check the file owner and permissions. We have a nasty requirement that our root umask eliminates group and world access to files created by root. Wreaks havoc on Perl module installations. Sent from my iPhone On Jan 2, 2015, at 12:18 PM, The Doctor

Re: Trouble installing DBD::Oracle in OS X 10.8 ; Oracle 32 bit drivers the issue?

2013-02-06 Thread Jeff Urlwin
I just tried on OSX, using MacPorts perl (64 bit) and get unresolved symbols/dependencies. Lot's of messages from PHPers about this missing dependency: _C_SendHTTPRequest. No solution posted, that I could find yet… On Feb 6, 2013, at 3:54 AM, Jonas Brømsø Nielsen jona...@gmail.com wrote:

Re: Trouble installing DBD::Oracle in OS X 10.8 ; Oracle 32 bit drivers the issue?

2013-02-06 Thread Jeff Urlwin
Den 06/02/2013 kl. 20.05 skrev Jeff Urlwin jurl...@urlwincc.com: I just tried on OSX, using MacPorts perl (64 bit) and get unresolved symbols/dependencies. Lot's of messages from PHPers about this missing dependency: _C_SendHTTPRequest. No solution posted, that I could find yet

RE: Official DBI module for Solaris Box

2010-03-25 Thread Jeff Urlwin
Some points I would add to the below: 1) I agree, grabbing a new perl is usually best, but, sometimes that isn't as easy (politically) as it should be. 2) I have had luck injecting DBI, and other perl modules, into the existing, Solaris perl, using Sun's Studio compiler. I

RE: DBD-Oracle 1.23 testing

2009-06-28 Thread Jeff Urlwin
-Original Message- From: John Scoles [mailto:sco...@pythian.com] Sent: Thursday, June 25, 2009 10:09 AM To: Jeff Urlwin Cc: dbi-users@perl.org Subject: Re: DBD-Oracle 1.23 testing Thanks allot Jeff just to let other know the 58object.t errors are a know issue which should be fixed in 1.24 (beer

DBD-Oracle 1.23 testing

2009-06-25 Thread Jeff Urlwin
Attached are my quick results from testing DBD::Oracle on 32/64 bit clients, 10.2.0.4 and 11.1.0.7 in various (but not all) combinations. I hope this helps, and I will research more of these, but I thought it might help the group. Regards, Jeff This

RE: DBD-Oracle 1.23 testing

2009-06-25 Thread Jeff Urlwin
: John Scoles [mailto:sco...@pythian.com] Sent: Thursday, June 25, 2009 7:56 AM To: Jeff Urlwin Cc: dbi-users@perl.org Subject: Re: DBD-Oracle 1.23 testing Thanks for that Jeff but is does not seem the attachment whet though do you thin you can send it to me directly?? cheers John Jeff Urlwin

RE: make test fails for DBD::ODBC on Solaris 5.8 with openlink driver

2006-07-01 Thread Jeff Urlwin
The biggest issue is that you are connecting to SQL Server and not getting multiple result sets (seemingly). I wouldn't worry about it, unless your application needs to handle multiple result sets in a single query. Also, on Solaris, FreeTDS and DBD::Sybase is probably the way I'd start, just

RE: DBD::Oracle ppd

2006-04-30 Thread Jeff Urlwin
I can tell you that ftp.esoftmatic.com may never be back, per se. I'm not there anymore and someone unplugged a few things and decided to leave it. Sigh. I did feel that it's usefulness was virtually eliminated when ppm started building ActiveState. Jeff -Original Message- From:

RE: [dbi] Unicode-Patch for DBD::ODBC

2006-04-14 Thread Jeff Urlwin
Please let me know what you come up with for a final patch and I will try to incorporate this weekend... -Original Message- From: Alexander Foken [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 21, 2006 2:56 AM To: Martin J. Evans Cc: dbi-users@perl.org Subject: Re: [dbi]

RE: :ODBC in a web application

2006-03-25 Thread Jeff Urlwin
There are probably a few things here. Apache typically runs under a different user as a Windows service. Typically, this is the local system user. Local System doesn't have access to UNC (network) drives. You need to make the service run as a network-capable user. Keep using UNCs. Drive

RE: Having problems setting up DBD::ODBC

2006-01-30 Thread Jeff Urlwin
Is there a chance you made it a file or some other type of DSN other than global? Jeff -Original Message- From: Mark Nettleingham [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 25, 2006 11:10 AM To: Jeff Urlwin; dbi-users@perl.org Cc: [EMAIL PROTECTED] Subject: Re: Having problems

RE: Future versions of DBI to require perl = 5.8

2006-01-27 Thread Jeff Urlwin
Tim, Is this now going to be rescinded, in light of the rest of the thread with Gisle? Regards, JEff -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 25, 2006 7:03 AM To: dbi-users@perl.org Subject: Future versions of DBI to require perl = 5.8 FYI

RE: Having problems setting up DBD::ODBC

2006-01-24 Thread Jeff Urlwin
Here's a warning I see: Warning: LD_LIBRARY_PATH doesn't include /users/openlink/lib Is that where libiodbcinst.so is located? Jeff -Original Message- From: Mark Nettleingham [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 2:24 PM To: Jeff Urlwin; dbi-users@perl.org Cc

RE: Having problems setting up DBD::ODBC

2006-01-20 Thread Jeff Urlwin
A few things come to mind: Makefile.PL indicates: Warning: LD_LIBRARY_PATH doesn't include /users/openlink, which may be a red-herring for the mis-recognized driver. I think the cruxt of the problem is Makefile.PL is recognizing the driver as UnixODBC (or claims it is) -- this is probably

RE: Having problems setting up DBD::ODBC

2006-01-20 Thread Jeff Urlwin
Can you please re-send the output of Makefile.PL? Jeff -Original Message- From: Mark Nettleingham [mailto:[EMAIL PROTECTED] Sent: Friday, January 20, 2006 8:45 AM To: Jeff Urlwin; dbi-users@perl.org Cc: [EMAIL PROTECTED] Subject: Re: Having problems setting up DBD::ODBC Jeff

RE: :ping hangs after execute failure

2006-01-01 Thread Jeff Urlwin
Sending a trace file (level 9) may help me diagnose the issue. Jeff -Original Message- From: Kumar Talinki [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 28, 2005 4:11 PM To: dbi-users@perl.org Cc: Kumar Talinki Subject: DBI::ping hangs after execute failure Hi, I am using

RE: DBD ODBC question - $dbh-{odbc_exec_direct}

2005-12-28 Thread Jeff Urlwin
Without looking at your code, I can guess: Even if you only expect one row, you need to select until no more results are returned, which triggers the finish() for you. If you don't, you need finish(). Jeff -Original Message- From: Ryan Stille [mailto:[EMAIL PROTECTED] Sent: Thursday,

RE: DBD-ODBC-1.13 --FOXPRO fetchrow_array question

2005-12-12 Thread Jeff Urlwin
I'm guessing not. I see an error and I'm guessing that it detects the column type is not correct. Can you set DBI-trace to 9 and send me the output? Jeff -Original Message- From: yongming [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 06, 2005 9:36 PM To: [EMAIL PROTECTED] Subject:

RE: DBD-ODBC-1.13 --FOXPRO fetchrow_array question

2005-12-12 Thread Jeff Urlwin
To: Jeff Urlwin Subject: Re: DBD-ODBC-1.13 --FOXPRO fetchrow_array question Jeff, Here is the error spooled on the screen: Z:\pl\dndperl odbctest.pl DBD::ODBC::st fetchrow_array failed: [Microsoft][ODBC Visual FoxPro Driver]Error in row (SQL-01S01) [Microsoft][ODBC Visual FoxPro Driver

RE: Problem with Oracle 10.2 and Perl dbd/dbi interface

2005-11-30 Thread Jeff Urlwin
Just to get more information, I presume you are talking about the ActiveState perl and DBD::Oracle installed via ppm from their site? I'm also presuming you installed the Oracle Instant client along with (which they do now, but you can skip it, if you have the full client). Please confirm, so we

RE: :ODBC - File size limit exceeded

2005-11-29 Thread Jeff Urlwin
Which driver are you using? UnixODBC is the driver manager. I'd check: df -h -- volumes with low disk space log files (at or near your ulimit) Jeff -Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Sunday, November 27, 2005 5:25 PM To:

RE: DBD::Oracle for ActiveState Perl.

2005-11-02 Thread Jeff Urlwin
I have no control over that ;) Jeff -Original Message- From: Robert [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 01, 2005 11:15 AM To: dbi-announce@perl.org; dbi-users@perl.org Subject: Re: DBD::Oracle for ActiveState Perl. Is there a way that you can talk to them to make

DBD::Oracle for ActiveState Perl.

2005-11-01 Thread Jeff Urlwin
On Windows, at this time, it seems that ActiveState has released a binary version of DBD::Oracle. I do not know how long it's been out there, but I did install it tonight. I have briefly tested this using Active Perl 5.8.7 (build 813). I successfully ran: ppm install DBD-Oracle When

RE: Can I get message return by DBCC on MS SQL ?

2005-10-31 Thread Jeff Urlwin
If you also look at the tests inside DBD::ODBC (t/20SQLServer.t, specifically), you can see how to get DBCC output... Jeff -Original Message- From: David Goodman [mailto:[EMAIL PROTECTED] Sent: Monday, October 31, 2005 12:39 PM To: dbi-users Subject: Re: Can I get message return

RE: bind_param_inout + DBD::ODBC

2005-10-13 Thread Jeff Urlwin
DBD::ODBC support bind_param_inout... The best way to see an example is to look at the tests for SQLServer and Oracle. I don't have a DB2 server to test against, at the moment, but I've tested against both SQLServer and Oracle. Jeff -Original Message- From: Stephen More

RE: bind_param_inout + DBD::ODBC

2005-10-13 Thread Jeff Urlwin
To: Jeff Urlwin Cc: dbi-users@perl.org Subject: Re: bind_param_inout + DBD::ODBC I have tried the following code: my( $sth ) = $dbh-prepare ({call PGMRPGMLIB.SYSSTATS(?, ?, ?)}); my( $asp ) = undef; my( $cpu ) = undef

RE: Numeric value out of range error

2005-09-29 Thread Jeff Urlwin
Brian, If you summarize/resend the patches, preferably with documentation and patches to the tests to validate the patches, I would be likely to put them in at least the subversion repository and roll out a proper patch if things look good. Jeff -Original Message- From: Brian Becker

RE: Error writing to double using ODBC

2005-09-22 Thread Jeff Urlwin
Can you try binding it as a varchar? Instead of setting the default bind type to SQL_DOUBLE, which will cause more problems than it will help for the most part, try setting it to 12 (SQL_VARCHAR) Thanks, Jeff From: Wim Livens [mailto:[EMAIL PROTECTED]

RE: Could not install DBI, DBD::Oracle for AS Perl. Please help me out!!!!!

2005-09-07 Thread Jeff Urlwin
Did you install successfully already? Exactly README file isn't there, I checked. I think you can do by copying them with your hand, though I didn't test it. By the way esoftmatic has stopped to follow the AS version? Or DBI-1.43-5.8.3.tar is valid for 5.8.7? 5.8.3.tar.gz is valid

RE: ORA-12154 (DBD ERROR: OCIServerAttach)

2005-09-07 Thread Jeff Urlwin
Greetings. Context: Windows XP client Perl This is perl, v5.8.7 built for MSWin32-x86-multi-thread (with 7 registered patches, see perl -V for more detail) Binary build 813 [148120] provided by ActiveState http://www.ActiveState.com Built Jun

RE: error string being lost in DBD::ODBC

2005-08-31 Thread Jeff Urlwin
Did you try perldoc DBD::ODBC and look for more_results? $sth-{odbc_more_results}... Jeff -Original Message- From: Mitchell, Louise M [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 30, 2005 11:03 AM To: Jeff Urlwin; dbi-users@perl.org Subject: RE: error string being lost in DBD

RE: error string being lost in DBD::ODBC

2005-08-27 Thread Jeff Urlwin
Try checking your second $sth for more_results. It may be affecting the outcome. Regards, Jeff -Original Message- From: Mitchell, Louise M [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 4:31 PM To: dbi-users@perl.org Subject: RE: error string being lost in DBD::ODBC

RE: :Oracle PPDs for both 8.0 and 9.2 clients on Windows?

2005-08-14 Thread Jeff Urlwin
Hey all, We're (finally!) migrating our Windows XP Oracle clients from 8.0.5 to 9.2.0.6. While testing some AS Perl v5.6 that uses DBD::Oracle, we've found that it doesn't work with the 9i client. It keeps looking for the 8.0.5 or previous OCI DLLs. Using PPM, we see that

RE: :Oracle with Oracle 10g, Solaris 64 bit success...

2005-08-06 Thread Jeff Urlwin
bit perl builds are easy to find for download and are seemingly easier to make if you need to make it yourself. Regards, Jeff Regards, Hirosi Taguti [EMAIL PROTECTED] -Original Message- From: Jeff Urlwin [mailto:[EMAIL PROTECTED] Sent: Friday, August 05, 2005 8:43 AM

DBD::Oracle with Oracle 10g, Solaris 64 bit success...

2005-08-04 Thread Jeff Urlwin
For any of you who may have/had problems with building DBD::Oracle with Oracle 10g under Solaris, I got it working with a 32-bit perl by putting $ORACLE_HOME/lib32 in front of $ORACLE_HOME/lib in my LD_LIBRARY_PATH. The error you get relates to Wrong ELF Class if you don't put the right libs

RE: DBD Oracle download

2005-07-18 Thread Jeff Urlwin
If you have problems with the ftp, try http://ftp.esoftmatic.com ... Jeff -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, July 14, 2005 12:38 AM To: dbi-users@perl.org Subject: DBD Oracle download Regards, Balkrishna Sapre.

RE: Esoftmatic DBI and DBD version for ActiveState?

2005-07-10 Thread Jeff Urlwin
Larry, I am successfully using the 5.8.4 version with 5.8.7 of ActiveState. Jeff -Original Message- From: Larry Pieniazek [mailto:[EMAIL PROTECTED] Sent: Friday, July 01, 2005 8:54 AM To: dbi-users@perl.org Subject: Esoftmatic DBI and DBD version for ActiveState? It seems the

RE: DBI.ppd

2005-07-01 Thread Jeff Urlwin
, then you should be able to: ppm install c:\tmp\dbi.ppd Jeff -Original Message- From: Jeff Urlwin [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 28, 2005 6:15 PM To: Calder, Erick; dbi-users@perl.org Subject: RE: DBI.ppd I found this page: http://ftp.esoftmatic.com/DBI

RE: DBI.ppd

2005-06-28 Thread Jeff Urlwin
I found this page: http://ftp.esoftmatic.com/DBI/ but the DBI.ppd there seems to be an empty HTML page. I've just downloaded ActiveState for Windows and it doesn't come with DBI... The DBI.ppd there is an xml file and may not be displayed on your browser. Just follow the

RE: Problems installing Test-Simple.ppd

2005-06-26 Thread Jeff Urlwin
From ActiveState directly, I believe. Jeff -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, June 24, 2005 12:47 PM To: dbi-users@perl.org Subject: Problems installing Test-Simple.ppd When trying to install Test-Simple.ppd, I encountered the

RE: Cannot find DBD-Oracle.ppd

2005-06-26 Thread Jeff Urlwin
Read http://www.esoftmatic.com/DBI -Original Message- From: Larry Lords [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 21, 2005 3:22 PM To: dbi-users@perl.org Subject: Cannot find DBD-Oracle.ppd Follow-up from yesterday. I still need some basic help and thanks so much for

RE: Attempt to initiate a new SQL Server operation with results pending.

2005-06-26 Thread Jeff Urlwin
Please read DBD::ODBC pod. Specifically the section on the odbc_cursortype. Jeff -Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 22, 2005 1:22 AM To: Jeff Urlwin; dbi-users@perl.org Subject: Re: Attempt to initiate a new SQL Server operation

Windows DBD::Oracle and newer versions of Perl.

2005-06-15 Thread Jeff Urlwin
FYI, I've recently had to re-install perl on a machine where I'm contracting. It's 5.8.7. To test, I pulled in DBD::Oracle from the ftp.esoftmatic.com site from 5.8.4. It's working like a charm at the moment. Nothing fancy in the tests yet, but it's working. If anyone is having specific

RE: :ODBC on Mac OSX Server 10.3.7

2005-06-06 Thread Jeff Urlwin
[added dbi-users in case there are more people who can help there] On Jun 4, 2005, at 12:44 PM, Jeff Urlwin wrote: I grabbed the latest DBD::ODBC and DBI from CPAN to do the installs, so both are the latest versions. Did you install with iODBC both times? The same version both

RE: Success [ was Re: :ODBC on Mac OSX Server 10.3.7]

2005-06-06 Thread Jeff Urlwin
On Jun 6, 2005, at 10:26 AM, Jeff Urlwin wrote: [added dbi-users in case there are more people who can help there] On Jun 4, 2005, at 12:44 PM, Jeff Urlwin wrote: I grabbed the latest DBD::ODBC and DBI from CPAN to do the installs, so both are the latest versions. Did

DBD::Sybase error (was RE: SEGV error)

2005-05-12 Thread Jeff Urlwin
No, but posting with a better subject and the exact error message you still get would help. I don't see a 'DynaLoader' error in there... Jeff -Original Message- From: Mark Vaughan [mailto:[EMAIL PROTECTED] Sent: Thursday, May 12, 2005 7:02 PM To: Jeff Urlwin; DBI users Subject

RE: SEGV error

2005-05-10 Thread Jeff Urlwin
All, While executing CPAN's install DBD::ODBC command test #2 fails. Here is the output when run by hand: [snip] - do for DBD::ODBC::db (DBI::db=HASH(0x285918)~0x2714ec 'DROP TABLE PERL_DBD_TEST') Segmentation Fault(coredump) Not a pretty sight. This is attempting

RE: SEGV error

2005-05-10 Thread Jeff Urlwin
, Suite 100, Englewood, CO USA 80112 www.evolving.com -Original Message- From: Jeff Urlwin [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 10, 2005 4:10 AM To: Mark Vaughan; 'DBI users' Subject: RE: SEGV error All, While executing CPAN's install DBD::ODBC command test #2

ftp.esoftmatic.com is back up.

2005-05-03 Thread Jeff Urlwin
The DNS is back up. Reminder: http://www.esoftmatic.com/DBI or http://ftp.esoftmatic.com/DBI will get you to the instructions page. I'll be working on updating for the latest ActivePerl shortly. Regards, Jeff

RE: Problems building DBI on Windows

2005-04-25 Thread Jeff Urlwin
. Budd -Original Message- From: Jeff Urlwin [mailto:[EMAIL PROTECTED] Sent: Sunday, April 24, 2005 12:41 PM To: Kopman, Budd; dbi-users@perl.org Subject: RE: Problems building DBI on Windows I'm guessing you are running under 9x/ME instead of NT/2000/XP. Is that correct

RE: Problems building DBI on Windows

2005-04-24 Thread Jeff Urlwin
I'm guessing you are running under 9x/ME instead of NT/2000/XP. Is that correct? If so, try using 4dos as the shell (jpsoft.com). Try it for 21 days to build this (I love the shell and have used their products for many years). You may have to set ParameterChar to * instead of the default.

RE: DBI, MS Access, inserting/updating a Access Date/Time value

2005-04-14 Thread Jeff Urlwin
On Thu, Apr 14, 2005 at 09:19:00AM +1000, Daniel Kasak wrote: Robb wrote: Hi, Does anyone have any idea what is up with Microsoft Access and its ridiculous Date/Time formatting options? :) In VB, I use the format: #dd-mmm- HH:mm:ss# Your example:

RE: DBD-Oracle

2005-04-14 Thread Jeff Urlwin
I just answered this a day or two ago. Please use 24.249.249.7 as the IP instead of ftp.esoftmatic.com until I get my ISP to respond to the DNS needs. Thanks, Jeff -Original Message- From: Ramesh Patel [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 13, 2005 1:33 PM To:

RE: DBI, MS Access, inserting/updating a Access Date/Time value

2005-04-14 Thread Jeff Urlwin
On Thu, Apr 14, 2005 at 07:50:43AM -0400, Jeff Urlwin wrote: I would write as: $dt = #04-MAY-2004 17:03:34#; Wouldn't single quotes also work?: $dt = '04-MAY-2004 17:03:34'; Converting the month to a 3-character string version forces Access

RE: :ODBC and SQL Server Drivers on UNIX.

2005-04-12 Thread Jeff Urlwin
Have you tried FreeTDS and their ODBC driver? Jeff -Original Message- From: Mark F. nettleingham [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 12, 2005 4:28 PM To: dbi-users@perl.org Subject: DBD::ODBC and SQL Server Drivers on UNIX. I'm trying to find an open source

RE: DBD-Oracle

2005-04-11 Thread Jeff Urlwin
Please, temporarily, change ftp.esoftmatic.com to 24.249.249.7. I'm still working on resolving the DNS issues since moving ISPs and my current ISP is relatively deaf. I probably have to bit the bullett and put DNS on my server(s), which I'm not thrilled about ;) Jeff -Original

RE: compiling under windows and question mark in fields

2005-04-04 Thread Jeff Urlwin
Does anyone have a good pointer on what's required to compile DBI under Windows (using the ActiveState base)? The general rule is you need the same compiler that was used to compile the Perl you're using. For ActiveState, that's Microsoft Visual C++. Other than that, there's not

RE: esoftmatic ftp down?

2005-04-04 Thread Jeff Urlwin
Yep, but it's back up at 24.249.249.7. DNS fixes will come today (ish) Jeff -Original Message- From: Robert [mailto:[EMAIL PROTECTED] Sent: Thursday, March 31, 2005 10:51 AM To: dbi-users@perl.org Subject: esoftmatic ftp down? I was trying to get DBD::Oracle9, off of there

RE: Re: Accessing MS Access through the DBI ODBC

2005-04-03 Thread Jeff Urlwin
Just my opinion, but I don't think this is good advice. For one, it creates extra administration on the system, by forcing the user/programmer /sysadmin/webadmin to create an ODBC DSN setting for every new setup. For two, DBI and ODBC both support dynamic DSNs, so why not use them? If

RE: MSSQL 2000, ODBC, and placeholders

2005-03-09 Thread Jeff Urlwin
Charles, It *should* work, but...I suspect your SQL*Server driver is ancient. Mine is 2000.85.1117.00. The 3.8.xxx version, I suspect, is from SQL7 days. Please try updating the machine's MDAC driver to at least 2.7 or greater and I think you will find different behavior. If that doesn't

RE: DBI.ppd for 5.8.6

2005-03-09 Thread Jeff Urlwin
Marina, To be clear, are you using ActiveState perl? Just some thoughts: Can you try to install File-Spec from one of ActiveState's repositories, then install Test-Simple from my site? Regards, Jeff -Original Message- From: Marina Greenstein [mailto:[EMAIL PROTECTED] Sent:

RE: Problem installing DBD::ODBC 1.13

2005-03-02 Thread Jeff Urlwin
I'm able to install DBD::ODBC 1.11, however, I can not install 1.12 or 1.13. Following is a complete log of the steps used to build 1.13. If anybody has any idea what might be going on, I would appreciate being pointed in the right direction. Thanks, Jonathan # make realclean

RE: Problem installing DBD::ODBC 1.13

2005-03-02 Thread Jeff Urlwin
execute ok 26 - group by query returned rows not ok 27 - data sources test # Failed test (t/02simple.t at line 132) # '0' # # '0' First -- I think it's pretty safe to install this version, unless you require the use of the data_sources() function. Ok

RE: Running stored procedures

2005-03-01 Thread Jeff Urlwin
On Tue, 1 Mar 2005 11:49:40 -0600, Moreno, Javier [EMAIL PROTECTED] wrote: Hi all, This is probably a dumb question, but how do I run stored procedures with the DBI? I am using DBD::ODBC. my $dbh = DBI-connect(dbi:ODBC:server, 'name', 'password'); my $query = exec spTest

RE: DBI-1.46 issues

2005-02-04 Thread Jeff Urlwin
Hi Paul, Any ideas why I can run the script as root and not another account? The most obvious ones are: - Environment -- are you sure you are running the same perl in both accounts? Path differences, etc, could cause issues. I've seen this where /usr/bin/perl is in a path first,

RE: Connect to Oracle 8.1.7

2005-01-24 Thread Jeff Urlwin
Another quick thing to check is: did you rebuild DBD::Oracle since upgrading? Just checking... Jeff On Jan 24, Spiraquis Alexis (SFO) scribed: Hello I have on my server 5.005_03 built for sun4-solaris installed with DBI(v1.13). I was previously accesing a Oracle 7.3.4 Database

RE: Double quotes in select statement throw an error

2005-01-19 Thread Jeff Urlwin
Lee, The select statement is very valid and so is: SELECT 'Hello World!' as 'My first SQL Statement' -or- SELECT answer = 2+3 Really, try it. Anyway... I was sent the correct answer and was very surprised in that the syntax is indeed valid on some servers, however the ANSI

RE: Double quotes in select statement throw an error

2005-01-19 Thread Jeff Urlwin
Thank you everyone who responded and to Tim and Jeff: The reason the server generates an error is because there are 2 flags which can be set when you create the DSN: Use ANSI quoted identifiers Use ANSI null, padding and warning And they were both selected. De-selecting Use

RE: DBI installation

2005-01-15 Thread Jeff Urlwin
Hi Patrick, You can download the *.gz and *.ppd file (eg from ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.2) Edit the ppd file, change CODEBASE to point to where you downloaded the *.gz file. In ppm add a new repository, eg rep add new \location of *.ppd now use ppm to

RE: Accessing MS SQL Server data using PERL and DBI

2005-01-12 Thread Jeff Urlwin
Help! I have a SQL SERVER database hosted on an NT server. I am trying to connect to the database using PERL from LINUX. I am currently using DBD::ODBC but the multiple query restriction is causing problems because I need to do lookups. If it's just simple lookups (which it may not be

RE: Attempt to initiate a new SQL Server operation with results pending.

2005-01-11 Thread Jeff Urlwin
Hi all. I've just ( barely ) managed to get DBD::ODBC == UnixODBC == FreeTDS working on my system. I took a Perl-Gtk2 app which has been running fine, and substituted the old DBD::Sybase connection with the DBD::ODBC one, and then discovered I could only run one query on

RE: :odbc stop error

2005-01-10 Thread Jeff Urlwin
Please always copy the list. Please also check your LANG settings. I had tested this under Solaris 8 a long time ago. Jeff -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January 10, 2005 9:59 AM To: Jeff Urlwin Subject: RE: :odbc stop error I

RE: Perl 5.6 to 5.8 caveats for DBI

2005-01-09 Thread Jeff Urlwin
At 12:23 PM 1/7/2005, Capacio, Paula J wrote: Are there any caveats that I should look out for regarding ActiveState Perl 5.8 and the latest DBI modules? Get your DBI and DBD modules from: http://ftp.esoftmatic.com/DBI/ Thanks. Now another question I just upgraded to Perl

RE: :ODBC make test fails

2004-12-21 Thread Jeff Urlwin
Please keep all replies on the list. I'm not the only person (or, necessarily, the best person) to help you. Thanks very much for your effort on clearing this up. Just for grins, try removing the trailing slash and the LD_LIBRARY_PATH should be set to the lib directory, which may be

RE: :ODBC make test fails

2004-12-21 Thread Jeff Urlwin
Please keep all replies on the list. I'm not the only person (or, necessarily, the best person) to help you. Thanks very much for your effort on clearing this up. Just for grins, try removing the trailing slash and the LD_LIBRARY_PATH should be set to the lib directory,

RE: :ODBC make test fails

2004-12-20 Thread Jeff Urlwin
Well I am having some trouble getting DBD::ODBC up and running and so here I am. I was unable to get to http://www.fugue.com/dbi, but I sent an email to the dbi-requests email address. I am not even sure I can send an email here if I am not a user but I am giving this a shot

RE: dbi packages required

2004-12-18 Thread Jeff Urlwin
Try the 5.8.4 packages. Regards, Jeff Original Message Hi,Tim Bunce I am presently working on a project on CGi for my 7sem Cs course Am unable to trace a DBI and DBD-ODBC packages for perl. Tried some sources (ftp://ftp.esoftmatic.com/outgoing/DBI/DBI.ppd ) but couldnt get it Can

RE: Please Help !!! Unable to install DBD-Oracle ( I am using perl 5.6 on solaris 8)

2004-12-16 Thread Jeff Urlwin
: ehelpline.bpweb.bp.com Helpdesk Phone: 00-91-80-51381734/00-91-80-51381748/00-91-9845796558 -Original Message- From: Jeff Urlwin [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 15, 2004 8:49 PM To: Vivekananda M (WT01 - UTILITIES); [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL

RE: cross-posted FAQ question [was: Win98 - DBD-Oracle install issue]

2004-12-16 Thread Jeff Urlwin
, 2004 9:02 AM To: Jeff Urlwin Cc: [EMAIL PROTECTED] Subject: RE: cross-posted FAQ question [was: Win98 - DBD-Oracle install issue] Hi Jeff, Gone through the suggested link: http://www.mail-archive.com/dbi-users@perl.org/msg23109.html Tried: = C:\Perl\DBD-Oracle-1.16ppm install ftp

RE: cross-posted FAQ question [was: Win98 - DBD-Oracle install issue]

2004-12-16 Thread Jeff Urlwin
) and using PPM to install DBI and DBD-Oracle from my site? Ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.4/DBI.ppd Ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.4/DBD-Oracle.ppd And let me know if there is an issue? Thanks, Jeff --- Jeff Urlwin [EMAIL PROTECTED] wrote

RE: cross-posted FAQ question [was: Win98 - DBD-Oracle install issue]

2004-12-15 Thread Jeff Urlwin
Hi Sam, Sorry for cross posting, was trying to get some solution faster. No other intentions. New to this. I have checked the following earlier and now but not found any clues for my issue. http://www.mail-archive.com/dbi-users@perl.org/msg23137.html

RE: Please Help !!! Unable to install DBD-Oracle ( I am using perl 5.6 on solaris 8)

2004-12-15 Thread Jeff Urlwin
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 14, 2004 8:28 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Please Help !!! Unable to install DBD-Oracle ( I am using perl 5.6 on solaris 8) The

RE: Oracle Bulk Bind / Execute_Array

2004-12-09 Thread Jeff Urlwin
At least DBD::ODBC supports it. Not sure of any others. Er, ummm, not yet. Jeff

RE: how can I extract String as UTF-8 under UNIX, my data was in SQL Server Database and stored as Unicode data

2004-12-09 Thread Jeff Urlwin
DBD::ODBC has not even been tested with UTF-8 data. Patches/tests most welcome!! Regards, Jeff -Original Message- From: Yonghui Wang [mailto:[EMAIL PROTECTED] Sent: Thursday, December 09, 2004 4:09 PM To: [EMAIL PROTECTED] Subject: how can I extract String as UTF-8 under

RE: DBI and DBD issues with Accessing BLOB

2004-12-07 Thread Jeff Urlwin
If not, Jeff Ulwin maintains some compiled ActiveState versions of DBD::Oracle here: ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.4/ ... one of which may suit your purposes. Andy, Thanks for the reference. To make things clear, I'd prefer people to go to the following page for

RE: Windows to Oracle

2004-12-04 Thread Jeff Urlwin
*** The link is fine, once my lamentable ignorance of ppm is mended... On my 5.8.4 plus 2.0.52 m/c, I ran the two cmds ppm install .. DBI.ppd and ... DBD-Oracle.ppd, changing 5.8.3 to 5.8.4. The two installs each stated they were successful, versions 1.45 and 1.16 respectively. But

RE: Windows to Oracle

2004-11-29 Thread Jeff Urlwin
Graeme, You must install DBD::Oracle using either CPAN or ActiveState's PPM utility (if you're using AS Perl 5.6.0). Or ActiveState 5.8.x, using my PPM repository at http://ftp.esoftmatic.com/DBI Regards, Jeff

RE: Windows to Oracle

2004-11-29 Thread Jeff Urlwin
Thanks to the various responders. I did issue a newbie alert, and I have to say some of the responses are (way) over my head. 8-( Install DBD::Oracle: yes, but how? It seemed to me that simply placing the CPAN Oracle.pm source in the DBD folder would be a good start, then I

RE: Why wont my script finish?

2004-11-24 Thread Jeff Urlwin
I do what you originally did ($dbh-do(delete...) all the time on Oracle 8.1.7. The only difference I have is my $dbh = DBI-connect(dbi:Oracle:database, user, pass, { RaiseError = 1, AutoCommit = 0 }); i.e. I explicitly set AutoCommit off. I always have done

RE: Configure DBD::ODBC with DataDirect ODBC drive for Perl

2004-11-16 Thread Jeff Urlwin
All, So far I have perl executable 5.8.0. Do i have to upgrade perl.exe to 5.8.5 version to test DBD::ODBC 1.13 again? No, you shouldn't need to. Regards, Jeff All, I am trying to use Perl with DBI/DBD and Datadirect ODBC to import datafile on unix to remote

RE: Configure DBD::ODBC with DataDirect ODBC drive for Perl

2004-11-13 Thread Jeff Urlwin
All, I am trying to use Perl with DBI/DBD and Datadirect ODBC to import datafile on unix to remote windows-based SQL server RDBMS. I have installed DBI-1.45 and Datadirect (www.datadirect.com) ODBC drive for SQL server DB on my Redhat 9.0 Linux. So far DataDirect SQL ODBC drive on

RE: faied tests installing DBD::ODBC on FreeBSD

2004-11-11 Thread Jeff Urlwin
I'm attempting to install DBD::ODBC 1.13 with perl 5.8.3 on FreeBSD 4.7 with FreeTDS 0.63 and unixODBC 2.2.10. unixODBC's isql works fine, so I know that the odbc driver is functioning, but make test for DBD::ODBC is dumping core: It's trying to connect and fail. While I'm not an

RE: Need latest DBI and DBD::Oracle for win32

2004-11-09 Thread Jeff Urlwin
There are instructions at http://ftp.esoftmatic.com/DBI Regards, Jeff -Original Message- From: David [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 9:55 AM To: [EMAIL PROTECTED] Subject: Re: Need latest DBI and DBD::Oracle for win32 On Mon, Nov 08, 2004 at

FW: CPAN Upload: J/JU/JURL/DBD-ODBC-1.13.tar.gz

2004-11-08 Thread Jeff Urlwin
Message- From: PAUSE [mailto:[EMAIL PROTECTED] Sent: Monday, November 08, 2004 10:16 AM To: Jeff Urlwin Subject: CPAN Upload: J/JU/JURL/DBD-ODBC-1.13.tar.gz The uploaded file DBD-ODBC-1.13.tar.gz has entered CPAN as file: $CPAN/authors/id/J/JU/JURL/DBD-ODBC-1.13.tar.gz size: 96990

RE: DBI or DBD::ODBC core dumps

2004-11-05 Thread Jeff Urlwin
Hello, everybody. I'm having a problem with DBI or DBD::ODBC module. Everything works fine, but from time to time, I'm getting a core dump of perl executable. Each time it happens in different place. The problem occurred on Sun Solaris, I have perl 5.6.1, DBI 1.38 and DBD::ODBC 1.06

RE: Cant' load Oracle.ppd

2004-11-04 Thread Jeff Urlwin
] Sent: Thursday, November 04, 2004 9:55 AM To: 'Jeff Urlwin' Subject: R: Cant' load Oracle.ppd I've installed OracleClient10g before Perl. I use this string to connect: $connect_string=DBI:Oracle:host=$ip;sid=$sid; $dbh=DBI-connect($connect_string, $db_user, $db_password,{AutoCommit

RE: Cant' load Oracle.ppd

2004-11-03 Thread Jeff Urlwin
Hello, I read some post about this problem to connect Oracle9: install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified module could not be found at C:/Perl/lib/DynaLoader.pm line 206.

RE: Congrats, Tim!

2004-11-02 Thread Jeff Urlwin
Great! Kudos Tim! ...on making Oracle Open Source Dev of the year: http://www.oracle.com/technology/oramag/oracle/04-nov/o64award s.html#BUNCE Rich This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The

  1   2   3   4   5   6   7   >