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
t; jonasbn > > Den 06/02/2013 kl. 20.05 skrev 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. >> >>

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 wrote: > Forgot to mention

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 believ

RE: DBD-Oracle 1.23 testing

2009-06-28 Thread Jeff Urlwin
Thanks, Jeff -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 fixe

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

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 electron

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: J

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] Unicod

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 mappin

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: Havin

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@p

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: 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 because

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 Ac

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, D

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

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

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: 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: dbi-users@per

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

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 the

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 ret

RE: Remote Login, using dbi:ODBC

2005-10-25 Thread Jeff Urlwin
This really isn't a perl/dbi issue. If it's an MS access database, you need to be able to access the MDB file itself. Thus, there is no server/port, etc. Jeff -Original Message- From: Richard [mailto:[EMAIL PROTECTED] Sent: Sunday, October 23, 2005 2:33 AM To: dbi-users@perl.org Subje

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( $

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 [mailto:[EM

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 Becke

RE: Numeric value out of range error

2005-09-28 Thread Jeff Urlwin
Try changing your bind_param to "10.00", {TYPE=>12} Jeff > -Original Message- > From: Lee Anne Lester [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 27, 2005 4:09 PM > To: dbi-users@perl.org > Subject: Numeric value out of range error > > I am getting a "Numeric value out of rang

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] Sent:

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 >

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.g

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

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 t

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

2005-08-06 Thread Jeff Urlwin
t perl, which looked to be more painful to build, due to dependancies. 32 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] > > > > -Origin

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 S

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 se

RE: DBI.ppd

2005-07-01 Thread Jeff Urlwin
.ppd and dbixx.tar.gz, 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 &

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 di

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

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 mu

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 encount

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 prob

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::O

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 wi

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 >

RE: SEGV error

2005-05-10 Thread Jeff Urlwin
> Direct: +1 303 802 2426 > > Cell: +1 303 601 4434 > > Fax: +1 303 802 1420 > > [EMAIL PROTECTED] > > Evolving Systems, Inc. > > 9777 Pyramid Court, Suite 100, Englewood, CO USA 80112 > > www.evolving.com > > > -Original Message-

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. T

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
e test, > nmake install > > and all seems well. > > Add it to your database. > > 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:

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 07:50:43AM -0400, Jeff Urlwin wrote: > > > > > > > > I would write as: > > > > $dt = "#04-MAY-2004 17:03:34#"; > > > > > > Wouldn't single quotes also work?: > > > > > >

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: db

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-

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 sou

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 Message

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 t

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, ther

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

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: DBI.ppd for 5.8.6

2005-03-09 Thread Jeff Urlwin
I probably need to update my repository with 5.8.6 binaries, but I'm a bit swamped at the moment. Sigh. Regards, Jeff > -Original Message- > From: Marina Greenstein [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 08, 2005 4:01 PM > To: dbi-users@perl.org > Subject: DBI.ppd for 5.8.6

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 wor

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 da

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

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'); m

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 firs

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 >

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-select

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

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 \ > > now use ppm to install

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

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 o

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

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

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 >

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 a

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 i

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

2004-12-16 Thread Jeff Urlwin
t; shyam Can you try upgrading your AS to build 810 (5.8.4) 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? T

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

2004-12-16 Thread Jeff Urlwin
pro Technologies > Email: [EMAIL PROTECTED] > > > Helpdesk URL: 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] >

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.16>ppm install

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) > >

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 > http://www.mail-archiv

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 un

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: 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 pa

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 respect

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, t

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: 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 al

RE: compatibilty issue DBI 1.46 dbd-odbc 1.13

2004-11-23 Thread Jeff Urlwin
> > hi, > can some one help me with this issue when iam trying > to install dbd-odbc 1.13 using makefile.the error i am > getting is > > C:\DBD-ODBC-1.13>perl makefile.pl > > DBI object version 1.37 does not match $DBI::VERSION > 1.46 at C:/Perl/lib/DynaLoa > der.pm line 225. > BEGIN failed--com

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 uni

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 d

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

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
Original 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 siz

  1   2   3   4   5   6   7   >