DBI DBD::Sybase or FreeTDS bug?

2003-04-04 Thread Karyn Ulriksen
I've been using FreeTDS and DBD::Sybase to talk to my MS SQL server. Despite the frankenstein aspect of it, it has generally gone well until recently after upgrading to FreeTDS .061 and DBD::Sybase 0.95 and then 1.0. There are still a few kinks, but mostly that has to do with NULL and NULL sets, fo

RE: OT: What's up with CPAN

2003-04-01 Thread Karyn Ulriksen
Haha... On the Perl-NTAdmin list, someone's got them going that the site was taken down because modules were being used for a terrorist plot. I think I'll watch. No sense me being the only sucker :) Karyn -Original Message- From: Fernando Luna [mailto:[EMAIL PROTECTED] Sent: Tuesday, Ap

RE: OT: What's up with CPAN

2003-04-01 Thread Karyn Ulriksen
Jeesh. Got me. Told you my head has been buried in code too long. -Original Message- From: johnn [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 10:34 AM To: [EMAIL PROTECTED]; Karyn Ulriksen Subject: Re: OT: What's up with CPAN On Tue, Apr 01, 2003 at 10:26:51AM

OT: What's up with CPAN

2003-04-01 Thread Karyn Ulriksen
I think I've had my head buried in code too long. Why in god's creation is www.cpan.org now going to Matt's Script Archive? Karyn

RE: New fetchrow behavior in DBD::Sybase??

2003-03-31 Thread Karyn Ulriksen
>On Mon, Mar 31, 2003 at 02:01:30PM -0800, Michael Peppler wrote: >> On Mon, 2003-03-31 at 11:36, Karyn Ulriksen wrote: >> > This worked pretty well before. But, now, it appears that if the result of >> > the query is a null set, it pukes with a: >> > >

RE: New fetchrow behavior in DBD::Sybase??

2003-03-31 Thread Karyn Ulriksen
ough and right TSQL calls to check if the dumb things exist or not. Thanks, Karyn -Original Message- From: Michael Peppler [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2003 2:02 PM To: '[EMAIL PROTECTED]' Subject: Re: New fetchrow behavior in DBD::Sybase?? On Mon, 200

RE: MySQL Select question.

2003-03-31 Thread Karyn Ulriksen
Are you trying to scroll through the data? If you are trying to scroll through the data, inner joins are quite handy (if MySQL supports the construct). I use a really ugly looking inner join to accomplish the scrolling. This is formatted for MSSQL and Sybase, so adjust accordingly: my($q) =

New fetchrow behavior in DBD::Sybase??

2003-03-31 Thread Karyn Ulriksen
Hi All, I recently upgraded one of my machines to DBD::Sybase 0.95. I am seeing a new behavior that is causing me problems and wondered if anyone could help me out. Also, I'm seeing that "$self->{DBH}->{LongReadLen} = 65536;" is being complained about in the logfiles, so I've remarked the

RE: DBD::Sybase 'make test' failures

2003-02-25 Thread Karyn Ulriksen
Karyn -Original Message- From: Michael Peppler [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 5:00 PM To: [EMAIL PROTECTED] Subject: Re: DBD::Sybase 'make test' failures On Tue, 2003-02-25 at 16:49, Karyn Ulriksen wrote: > Here's the 'make test' failur

DBD::Sybase 'make test' failures

2003-02-25 Thread Karyn Ulriksen
Here's the 'make test' failures, I'm seeing when running 'make test' on the DBD::Sybase 0.95. Don't see them in 0.94. Maybe our faithful CPAN contributor can make heads or tails of it. Note the repeated references to the undefined "cs_ctx_global. This issues does not come up in 0.94. This sa

RE: Connecting perl to MS SQL on Tru64 Unix use freetds

2003-02-25 Thread Karyn Ulriksen
Gordon, I forgot to mention... most of the machines using this run Linux RH 7.x. However, I do have two machines running Tru64 5.x. The issues are a little bit different, but still regarding shared memory. I'll post my 'make test' fails for good measure in another post. Karyn -Origi

RE: connecting perl to MS SQL on Linux

2003-02-25 Thread Karyn Ulriksen
run the FreeTDS install again. Karyn -Original Message- From: Russell Kroboth [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 1:26 PM To: 'Karyn Ulriksen'; [EMAIL PROTECTED] Subject: RE: connecting perl to MS SQL on Linux Ok, I was able to get FreeTDS installed

RE: connecting perl to MS SQL on Linux

2003-02-24 Thread Karyn Ulriksen
nding the ones it needs to build out okay and run. What OS (and version) did you apply your Sybase 9.95/freetds 0.61rc combo to? I haven't had any luck. Karyn -Original Message- From: Frank Wu [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 2:28 PM To: 'Karyn Ulriks

RE: connecting perl to MS SQL on Linux

2003-02-24 Thread Karyn Ulriksen
essage- From: Russell Kroboth [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 12:49 PM To: 'Karyn Ulriksen'; [EMAIL PROTECTED] Subject: RE: connecting perl to MS SQL on Linux I did download .94 and attempted 'perl Makefile.PL', but I get the following error: Please

RE: connecting perl to MS SQL on Linux

2003-02-24 Thread Karyn Ulriksen
Use the DBD::Sybase Driver... BUT!!! Don't use the current version (0.95), use the last version (0.94). I've been using FreeTDS for about the past two years. Works like a charm. Don't use ODBC, since it adds an unnecessary layer. FreeTDS speaks to the MS SQL natively. Karyn -Original Mes

MS SQL Stored Procedure Calls Somewhat Resolved (Was RE: Where is the archive for this list?)

2002-06-21 Thread Karyn Ulriksen
. How come so scarce on the MS SQL / Sybase info? Thanks K -Original Message- From: Jonathan Leffler [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 12:04 PM To: Karyn Ulriksen Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Where is the archive for this list? If it wer

Where is the archive for this list?

2002-06-21 Thread Karyn Ulriksen
I'd like to bookmark the mail archive site so that I don't have to go to the list to ask for the umpteenth million time what I know has been asked on this list... I'm having problems with calling an MS SQL stored procedure via DBI (using FreeTDS DBD::Sybase). I've tried the following formats: $

RE: Using DBD::Sybase to talk to MS SQL

2002-04-24 Thread Karyn Ulriksen
in documention indexes or mailing lists :) Thanks! Karyn -Original Message- From: Michael Peppler [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 3:07 PM To: Karyn Ulriksen Cc: [EMAIL PROTECTED] Subject: Re: Using DBD::Sybase to talk to MS SQL On Wed, 2002-04-24 at 14:40,

Using DBD::Sybase to talk to MS SQL

2002-04-24 Thread Karyn Ulriksen
I came across this twice in one day from unrelated sources after never hearing about it before. Considering the great scalability of DBI::Proxy , I am interested in feedback on anybody using DBD::Sybase on a linux box to talk to an MS SQL server. Are there any drawbacks? Does it thread? Do I ju

RE: Keyword "date" instigating error

2002-04-19 Thread Karyn Ulriksen
The 'date' keyword issue usually occurs at the database level. Most SQL databases I have worked with wont even allow you to create a field with this name. It's possible that DBI does a "sanity check" on some of the keywork fields. The feedback on this issue should be interesting... K -Ori

RE: multi-threaded DBI Proxy on NT 4.0

2002-04-09 Thread Karyn Ulriksen
Question 1: How man callers will DBI Proxy hold in queue ? Question 2: Is there any kind of probable timeframe for Perl 5.8 ? Karyn -Original Message- From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 8:07 AM To: Roland Lammel; Ives, Larry Cc: [EMAIL PROTECTED] S

RESOLVED: Running DBI Proxy as a service (or equivalent) on Windows 200 0

2002-04-09 Thread Karyn Ulriksen
The following steps were taken to successfully install DBIproxy Server as a Service under Windows 2000 Professional Server. Directions assume intermediate level Windows 2000 administrative knowledge. Using instsrv.exe and srvany from NT4 Reskit 3 or Download instsrv.exe and srvany.exe available

RE: Running DBI Proxy as a service (or equivalent) on Windows 2000

2002-04-09 Thread Karyn Ulriksen
Thanks for your feedback. I'll look into both of these possibilities and let you know how it works. Best regads, Karyn -Original Message- From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 10:18 PM To: Ian Kallen; Karyn Ulriksen Cc: [EMAIL PROTECTED] Subjec

Running DBI Proxy as a service (or equivalent) on Windows 2000

2002-04-08 Thread Karyn Ulriksen
I've read back into the archives and the search engines looking for an answer to this, but to no avail. So if I missed it in the archives, I apologize in advance. My DBIproxy happily runs on my Win2K box and I am able to interact quite well with my MS SQL server from unix boxes (which was the po