I found, over time, that DBD::ODBC had problems with Excel. I would save
the Excel sheet as .csv and used DBD::CSV, instead. My use was a one way
conversion/update of Oracle from the spread sheets. I made a macro for the
data entry people to update the .csv file without having to think too
How about reading the POD documentation in ODBC.pm?
Jeff
Hello all,
I've recently begun moving my perl skills from a Win32 platform to now a
Linux platform. I plan to make a lot of database use of my previously
built
SQL Server databases. I'm familiar with DBI, however I'm
having
Neil,
To confirm: you don't need the readme.cygwin anymore?
Thanks,
Jeff
-Original Message-
From: Neil Lunn [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 8:41 PM
To: 'Timothy C. Phan'; [EMAIL PROTECTED]
Subject: [Patch] RE: DBD-ODBC 0.28 for Cygwin
-Original
It is now.
Jeff
Can't the (intended) error be silenced by the test script?
Tim.
On Wed, Aug 08, 2001 at 12:24:58PM +1000, Neil Lunn wrote:
I have this problem during 'make test'. Is it good/bad? Thanks
t/02simple..ok 7/14DBD::ODBC::st fetchrow failed:
[Microsoft][ODBC
Tim,
Fine on Win32, with the exception of the (expected) #2 below.
My patch to Makefile.PL for multiple oracle homes under Win32 didn't make
it. Attached is a diff from 1.09 for including into a later release.
Still getting FETCH from TieRegistry upon failure. Not sure how to handle
it, and
Following situation: I'm using DBI and MS-Access, and my tables contain
timestamp fields. I have a number of variables that need to either be
inputted or updated into the table, and my statement looks like this:
#Update:
$state = update table set var1 = ?, var2 = ? where primkey = ? ;
-Original Message-
From: Jeff Urlwin [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 11:33 AM
To: Mohammed Khalid Ansari; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: :ODBC module
Go to www.easysoft.com
Look at the unixODBC driver manager and the ODBC-ODBC bridge
Please set the DBI tracing level to 9 and send the output (you will also,
probably, have to set the trace file name under Win2k to properly get it
all). It could be DBI or the driver manager, but is probably DBI.
Jeff
Hello,
I am attempting to connect to a database (Tivoli Storage Manager)
Simon,
Evidently, my ISP is blacklisted by your server...hence the posting to
dbi-users to update the status of the FoxPro issue...
Regards,
Jeff
-Original Message-
From: Jeff Urlwin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 6:29 PM
To: Jeff Urlwin; Simon Oliver
Actually, it's probably in DBD::ODBC. I hadn't seen it before using
SQLServer, but it's certainly possible. You want to get version 0.43
(releasing tonight, if I can get to the PAUSE server). I've got it patched
and it definitely fixes Foxpro issues (at least the ones I know about :) and
the
FYI -- I've fixed the problem for FoxPro, but I can't seem to get to PAUSE
to distribute. Sorry...I'll keep trying!
Jeff
: 7c223ef2da54e325c254320af2b16dc0
No action is required on your part
Request entered by: JURL (Jeff Urlwin)
Request entered on: Thu, 18 Jul 2002 11:05:41 GMT
Request completed: Thu, 18 Jul 2002 11:06:20 GMT
Virtually Yours,
Id: paused,v 1.80 2002/03/10 06:40:03 k Exp k
cusr + 0.00 csys = 0.00 CPU)
thanks
MaT
-Original Message-
From: Jeff Urlwin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 7:47 PM
To: Jan Matejka; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: DBI-1.30 x DBD-ODBC 0.43 - Perl crashes !
Do you know which
-Original Message-
From: Joe Tebelskis [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 22, 2002 6:12 PM
To: Jeff Urlwin
Cc: [EMAIL PROTECTED]
Subject: RE: bugs in DBD::ODBC 0.43
Thank you, Jeff. Your suggestion of using bind_param
explicitly seems to fix the problem for varchars
-0.45_4.tar.gz
has entered CPAN as
file: $CPAN/authors/id/J/JU/JURL/DBD-ODBC-0.45_4.tar.gz
size: 73845 bytes
md5: 6fdd5da07a9e79e12b6cd98deb3302a6
No action is required on your part
Request entered by: JURL (Jeff Urlwin)
Request entered on: Mon, 22 Jul 2002 23:00:28 GMT
Request completed
in what they are doing and I'm thankful we have a work around.
Regards,
Jeff
-Original Message-
From: Joe Tebelskis [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 22, 2002 7:37 PM
To: Jeff Urlwin
Cc: [EMAIL PROTECTED]
Subject: RE: bugs in DBD::ODBC 0.43
Thank you, Jeff. I already
Can you send me a trace and/or small sample?
Thanks,
Jeff
-Original Message-
From: Joe Tebelskis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 3:04 AM
To: Jeff Urlwin
Cc: [EMAIL PROTECTED]
Subject: DBD::ODBC 0.45_4
Thanks, I've received and installed DBD::ODBC 0.45_4
Request entered by: JURL (Jeff Urlwin)
Request entered on: Tue, 23 Jul 2002 11:59:21 GMT
Request completed: Tue, 23 Jul 2002 12:00:44 GMT
Virtually Yours,
Id: paused,v 1.80 2002/03/10 06:40:03 k Exp k
Gary,
I think there is something wrong with your table or environment/settings
within access. Here's my test which prints the integral values as integers.
Note I couldn't find a LongInteger type as Access only reports certain types
to me.
This is what Access 2000 reports to me
Listing all
Gary/Jim -- please run the test I attached in the previous post responding
to Gary. It retrieves and integer value as an integer. Note that
DBI/DBD::ODBC takes the data the way that it's sent by the server/ODBC
driver...
Jeff
Jim;
I've the same problem with Access2000.
Based upon your
else at this point) and will show the columns of
table FOO (assume you only have one table foo G).
Regards,
Jeff
-Original Message-
From: Jim Clark [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 3:28 PM
To: Jeff Urlwin
Cc: Gary Gauthier; [EMAIL PROTECTED]
Subject: Re: Number
Alan,
You have the wrong version of the C compiler. It's VERY old (if you have it
at all). You need to have Visual C++ 98 (or 6.0)
Jeff
-Original Message-
From: Sheu, Alan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 2:17 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 9:49 PM
To: Jeff Urlwin
Subject: Re: Number formatting using DBI/ODBC with SQL Server
Jeff,
You were right about the folders (I dragged the files from WinZip
instead of
extracting with folder names) so I extracted them the right way
Message-
From: Joe Tebelskis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 11:58 AM
To: Jeff Urlwin
Subject: RE: :ODBC 0.45_4
I've got a table:
CREATE TABLE [dbo].[logLocks] (
[logid] [varchar] (100) COLLATE
SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[status] [varchar
I can see where it might get confusing with connection pooling and caching.
See the t\09multi.t and some of the other multiple statements per prepare
samples in mytest\*.pl.
You should be able to:
- insert into foo (etc); select @@Identify in the same prepare statement
- use the
To: Joe Tebelskis
Cc: [EMAIL PROTECTED]; Jeff Urlwin
Subject: RE: :ODBC 0.45_4
Having installed DBD::ODBC 0.45_4 and creating the procedure:
Create procedure joe as DECLARE @resultint;SET @result = 1; select
@result;
and executing:
#!/usr/bin/perl -w
use DBI;
my $dbh
Teradata Support?Forwarded to DBI-users.
-Original Message-
From: Simpson, Paul [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 25, 2002 9:15 AM
To: '[EMAIL PROTECTED]'
Subject: Teradata Support?
Are you aware of any programmers who use this for Teradata database
access? I
: bfc390b932d64aac47acbf8c3a96aa9b
No action is required on your part
Request entered by: JURL (Jeff Urlwin)
Request entered on: Thu, 25 Jul 2002 17:16:25 GMT
Request completed: Thu, 25 Jul 2002 17:17:27 GMT
Virtually Yours,
Id: paused,v 1.80 2002/03/10 06:40:03 k Exp k
But you are using a hash, so keys is not guaranteed to put things in the
same order you want them to be in...
sort keys %loc would work...
Jeff
-Original Message-
From: Hytham Shehab [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 25, 2002 3:37 PM
To: dbi
Subject: Re: it *should*
I haven't had reports of leaks, and it's entirely possible. It is probably
NOT the DBI itself, more likely it is DBD::ODBC or the ODBC Driver itself.
I could have a few perl buffers being allocated that I think should be
destroyed, but are not.
Can you estimate any metrics? I.e. 5K/hour over
I am having a problem with a script after upgrading the DBD::ODBC
the script
was running from version 0.28 to 0.45.8. I am getting invalid cursor state
errors on stored procedures that contain insert queries. This is using MS
SQL 7.0, Activestate Perl 5.6.1 bild 631. Is there something
-
From: Jeff Urlwin [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 10:48 AM
To: Sthoward; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Problem with stored procedures with inserts.
I am having a problem with a script after upgrading the DBD::ODBC
the script
was running from
insertion):
$sth1-bind_param_inout(1, \$output, 50, DBI::SQL_INTEGER);
$sth1-bind_param(2, $_, DBI::SQL_INTEGER);
$sth1-execute();
$sth1-execute();
$sth1-execute();
$sth1-execute();
$dbh-disconnect;
-Original Message-
From: Jeff Urlwin [mailto:[EMAIL PROTECTED
: 78758 bytes
md5: 923206b1312fefca412390a62fd0d9c4
No action is required on your part
Request entered by: JURL (Jeff Urlwin)
Request entered on: Tue, 30 Jul 2002 05:39:52 GMT
Request completed: Tue, 30 Jul 2002 05:40:22 GMT
Virtually Yours,
Id: paused,v 1.80 2002/03/10 06:40:03 k
SQL Server issue when binding a null and the length was set to 0 instead of 1
Regards,
Jeff
-Original Message-
From: PAUSE [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 25, 2002 10:51 PM
To: Jeff Urlwin; [EMAIL PROTECTED]
Subject: CPAN Upload: J/JU/JURL/DBD-ODBC-0.45_8.tar.gz
explicity
set the recordset pointer to 'undef', even though it was defined as a 'my'
variable. Will see
if i can figure out why. Sounds like a scoping issue.
Regards;
Gary
Jeff Urlwin [EMAIL PROTECTED] 07/30/2002 12:34:35 PM
If you can wrap the small test up for me, I may be able to get
. If there was one, it was hardly noticable...even
over weeks.
Regards,
Jeff
Jeff Urlwin [EMAIL PROTECTED] 07/30/2002 7:03:04 PM
Well -- just doing a simple test connect and disconnect eat up
nearly 1,000 items (multiple connects and disconnects have no
effect on the qty of items eaten
-Original Message-
From: Ted Thibodeau Jr [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 09, 2002 6:16 PM
To: [EMAIL PROTECTED]
Subject: request for DBD::Changes change (and possible bug)
Hi there --
I'm trying to track down a possible bug (might be in DBD::ODBC,
might be in
Request entered by: JURL (Jeff Urlwin)
Request entered on: Fri, 09 Aug 2002 23:37:12 GMT
Request completed: Fri, 09 Aug 2002 23:37:23 GMT
Virtually Yours,
Id: paused,v 1.81 2002/08/02 11:34:24 k Exp k
See the DBI and ODBC docs for get_info (which maps to ODBC's SQLGetInfo,
which may help (and may not), but can't you tell by the DSN?
Regards,
Jeff
Having established a connection to an ODBC database server with the
following:
use DBI;
...
my $dbh =
FYI -- my plan is to delete more later, for the sake of CPAN. After
ActiveState catches up a bit, I'll clean up further.
According to a request entered by Jeff Urlwin the
following files and the symlinks pointing to them have been scheduled
for deletion. They will expire after 72 hours
-
From: PAUSE [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 13, 2002 9:43 PM
To: Jeff Urlwin; [EMAIL PROTECTED]
Subject: CPAN Upload: J/JU/JURL/DBD-ODBC-0.45_14.tar.gz
The uploaded file
DBD-ODBC-0.45_14.tar.gz
has entered CPAN as
file: $CPAN/authors/id/J/JU/JURL/DBD-ODBC-0.45_14.tar.gz
If you can, use DBD::Oracle. It will generally be faster and have less
layers between you and the database.
Regards,
Jeff
Hi All,
I want to migrate to migrate some existing Sybase Perl
Programs to work with ORACLE 9. Would it be better to go for
DBD::ODBC or DBD:ORACLE.
Thanks
I want to migrate to migrate some existing Sybase Perl Programs to
work with ORACLE 9. Would it be better to go for DBD::ODBC or
DBD:ORACLE.
If you can install the Oracle client software (e.g., SQL*Net, OCI, and
SQL*Plus) in the Perl machine, DBD::Oracle would be much better.
-vendor situation.
I'm glad you like DBD::ODBC :)
However, part of the DBI concept is that it provides a consistent api to the
databases. Aside from date handling it does a great job.
Jeff
Jeff Urlwin wrote:
If you can, use DBD::Oracle. It will generally be faster and have less
layers
differences...
2. ODBC is much more prevalent and common place on Windows, but not as
prevalent on Unix.
Also true.
3. Speed. DBD::Oracle, for example, is MUCH faster than DBD::ODBC when
talking to Oracle.
Jeff
Anyhow, just some thoughts from the last few years.
Bill
Jeff Urlwin wrote
I need the return value from a stored procedure.
Usually I do like this:
$sth = $dbh-prepare('Declare RETURN_VALUE int; exec
RETURN_VALUE=some_procedure param0=?, param1=?; select
RETURN_VALUE')
but that will result in multiple result sets and in this special case I
can't handle
Roger,
-Original Message-
From: Roger Perttu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 21, 2002 12:59 PM
To: [EMAIL PROTECTED]
Subject: DBD::ODBC 0.45 beta better than 0.41?
First, big thanks to Jeff Urlwin for developing DBD::ODBC, (for me) DBI
would be useless without
, that
would be helpful...and, that *is* a problem if it detects one and the other
is the right one.
Regards,
Jeff
-Original Message-
From: Jeff Urlwin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 21, 2002 6:07 PM
To: Levine, Peter W; [EMAIL PROTECTED]
Subject: RE: bogus warnings
-0.45_16.tar.gz
size: 81524 bytes
md5: f9bf5dba6056fcc147bda71f0d79f11c
No action is required on your part
Request entered by: JURL (Jeff Urlwin)
Request entered on: Mon, 26 Aug 2002 04:27:39 GMT
Request completed: Mon, 26 Aug 2002 04:28:21 GMT
Virtually Yours,
Id: paused,v 1.81
Peter,
I'm not sure what you mean. Can you give me an example?
Thanks,
Jeff
Hi,
Can the DBD-ODBC module make use of of MS SQL Server's FOR SQL clause? I'm
evaluating the pros cons of getting my data back from MS SQL
Server in XML
format. (BTW I'm use Apache webserver on Solaris.)
mileage may
vary.
Regards,
Jeff
-Original Message-
From: Levine, Peter W [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 26, 2002 2:34 PM
To: 'Jeff Urlwin'
Subject: RE: XML DBD:ODBC
Jeff,
MS Server 2000 can return data as XML or as rowsets. The main
interface for
this is MS
Hi,
I am wondering how to successfully connect to Microsoft Access
database using DBD::ODBC. Here is the snippet of my code:
Use perldoc DBD::ODBC and you will see an example of a DSN-less connection,
which is what you are trying to do. Otherwise, setup a system DSN and use
Steve -- thanks -- but please credit David L. Good for the async processing
and the error handler (among other things)! I just incorporated his work.
Nice script and thanks for posting. I've taken the liberty of cross-posting
to [EMAIL PROTECTED] where that group may find this interesting,
get_info() supports a lot of different options. get_info() is pretty much a
direct call to ODBC's SQLGetInfo. I'm not sure if this is right, but
SQL_DBMS_VER which has a value of 18 might do it. You can search
msdn.microsoft.com for more info and use $dbh-get_info(N) to get the
information.
Levine, Peter W wrote:
Hi,
The web page for Easysoft's ODBC-ODBC brige states that no client side
driver manager is required. It states that unixODBC is available for a
driver manager if that is desired. However I thought that
DBD:ODBC required
a driver manager?
May be a case
- Original Message -
From: Jeff Urlwin [EMAIL PROTECTED]
To: Liu Haifeng [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, August 28, 2002 8:32 PM
Subject: RE: Failure of ODBC connection with Access
Hi,
I am wondering how to successfully connect to Microsoft Access
'; #prints $dsn
vs.
print $dsn; #prints foo
Jeff
-Original Message-
From: Liu Haifeng [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 10:34 PM
To: Jeff Urlwin; [EMAIL PROTECTED]
Subject: Re: Failure of ODBC connection with Access
Answers to your questions
Paul,
Make sure it's a system DSN. This is somewhat covered in the DBD::ODBC pod
docs and some related documentation regarding, web server environments in
the DBI FAQ too.
I am having a problem moving a perl script I am using on the command line
into apache due to an error connecting to MS
Having difficulty with an error message no statement executing
against the
following
my $dbh = DBI-connect($DATA_SOURCE,$USER,$PASSWORD,{AutoCommit = 0,
RaiseError = 0, PrintError = 0 }) or error(Can`t connect to db:
DBI::errstr, 1,2);
# DBI-trace(2);
my $sth =
broad level of support. I don't know everything :)
Jeff
- Original Message -
From: Jeff Urlwin [EMAIL PROTECTED]
To: Liu Haifeng [EMAIL PROTECTED]; Jeff Urlwin
[EMAIL PROTECTED]
Sent: Thursday, August 29, 2002 6:47 PM
Subject: RE: Failure of ODBC connection with Access
Hi Jeff
Did you look at the new ParamValues attribute? Yes, many drivers probably
do not support it yet, but that's what it's for. (Also, DBD::ODBC does
support it and I believe that even if DBD::Oracle doesn't yet support it a
small lift of the same/similar code from DBD::ODBC to DBD::Oracle should
Recent versions of DBI removed SQL_BIGINT from it's definition as there was
a conflict between SQL/CLI and ODBC's definition. I suspect you need to
hack up JDBC.pm to not use it...
Regards,
Jeff (who ran into this issue with DBD::ODBC)
P.S. I take it you want DBD::JDBC due to the thin
This is probably better for the dbi-users mailing list. You can, probably,
read the data from Foxpro using DBD::ODBC and write the data to Unify with
DBD::Unify. Depending uopn your platform and availability of ODBC drivers,
you *might* need to save the data as a CSV file in between, or
Hi,
My code just fails to insert the records to the database.
Anybody can figure out the problem? Thanks in advance.
Here is the snippet:
#
my $dbn=newgene;
my $dbh=DBI-connect(dbi:ODBC:$dbn,'','')|| die $DBI::errstr\n;
my
Hi,
Why do I need to supply user name and password with DBI-connect() if I am
using DBD:ODBC? This information is already supplied in the DSN?
my $DSN=dbi:ODBC:sqlserver_dsn;
my $DBI_USER=Why do I need this?
my $DBI_PASS=Why do I need this?
$dbh=DBI-connect($DSN,$DBI_USER,$DBI_PASS);
Go get unixODBC (www.unixodbc.org) or iODBC (www.iodbc.org) (I think) and
install and *test* them (along with your driver, which you haven't mentioned
yet, either).
*Then* install DBD::ODBC and test it.
Jeff
I'm trying to install DBD::ODBC on our RH Linux 7.3 server and I keep
getting the
Jessee,
I'd research on the sites provided and also, copy dbi-users...
Jeff
-Original Message-
From: Jessee Parker [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 06, 2002 3:06 PM
To: Jeff Urlwin
Subject: Re: Installation Problems
Ok I guess I had a misunderstanding from
Brad,
What version of DBD::ODBC are you using? If you are using DBD::ODBC 0.28
from ActiveState, then I suggest upgrading to the latest (which has a PPM
file at ftp://ftp.esoftmatic.com/pub/outgoing/DBI
Please upgrade your DBI too, as you must use the version I have uploaded
there.
Regards,
Smith
On 9 Sep 2002 at 15:54, Jeff Urlwin wrote:
Brad,
What version of DBD::ODBC are you using? If you are using DBD::ODBC
0.28 from ActiveState, then I suggest upgrading to the latest (which
has a PPM file at ftp://ftp.esoftmatic.com/pub/outgoing/DBI
Please upgrade your DBI too
On Wed, Aug 21, 2002 at 09:59:23PM -0700, David Wheeler wrote:
Hi All,
I'd like to submit a simple patch that causes the DBI connect() method
to execute a HandleError code reference if it has one. There's a
comment suggesting that it could be added, and it makes sense to me, so
I
for you.
Jeff
-Original Message-
From: Brad Smith [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 09, 2002 8:14 PM
To: Jeff Urlwin
Subject: RE: Quirky problem with DBI
Jeff:
Still, no luck. I have altered the code (below), but it fails with the
following error. PArdon my
On Monday, September 9, 2002, at 03:16 PM, Jeff Urlwin wrote:
Not specifically, but maybe I'm missing something. If HandleError is
called, shouldn't the result of $attr-{HandleError} be checked before
trying to RaiseError or PrintError?
AFAIK, HandleError isn't expected to return
, but it will
have to start in t\20SqlServer.t anyway...
Regards,
Jeff
Using ActiveState Perl 5.6.1 build 633
The following happens when using either ActiveState's DBI DBD:ODBC
ppds or the latest ones posted by Jeff Urlwin.
When retrieving ntext, nvarchar et al. values from a MS SQL 2000 server
are not solutions I like.
Pete
-Original Message-
From: Levine, Peter W
Sent: Thursday, September 05, 2002 1:58 PM
To: 'Jeff Urlwin'
Subject: RE: why do I need to supply user password
Hi,
I'm using SQL server authentication not NT authentication. If I levae out
user and password
Translating:
instead of do(), use prepare() and execute(). DBD::ODBC has examples for
this in the mytest directory and in t/20SqlServer.t ... they may even work
with little/no modification on DBD::ADO, however, in VERY many of them I'm
testing multiple result sets and the difficulties that go
You need to setup a DSN. If you are on Windows platforms, then start with a
System DSN if possible (instead of a User DSN or File DSN). Create the DSN
to point to the database. Example:
Create A DSN named SQLSERVER1 which connects to the sql server database and
Create a DSN
Forwarded to dbi-users.
-Original Message-
From: Eduardo Gui [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 11:58 AM
To: [EMAIL PROTECTED]
Subject: I'm want to use your script DBD::ODBC
Hi Jeff Urlwin,
I wana use your script DBD driver with DBI perl, could you
From: Jeff Urlwin [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 16, 2002 7:05 AM
To: Janarthanan, Prasanna; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: RE: help! in DBD:ODBC
Hi,
I have to connect to the sybase and Sql database using ODBC drivers.
I don't
I suggest you talk to OpenLink directly regarding this. (That is, if this
is still the openlink driver that you mentioned you were using in prior
e-mails).
Regards,
Jeff
After installing the Single-Tier lite driver and iODBC , i get error while
running odbctest.
Error:
Hi Tim and Jeff,
We are having problems with using DBD-ODBC. The ODBC driver is
installed on
our server and can connect to our Redbrick Db, but the DBD-ODBC can not
connect when running the Maketest.
1. The log of all step of the built is attached in the zip file.
2. Perl: v5.6.1
Message-
From: Alex Cerantonio [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 6:26 PM
To: Jeff Urlwin; [EMAIL PROTECTED]
Cc: Darren Edgerton
Subject: RE: Problems with using DBD-ODBC
Hi Jeff,
We very much appreciate your prompt reply.
In answer to your questions:
1. DBI
Make sure you have the latest iODBC. They should be defining those values.
It may only be a beta version of iODBC, but get the latest possible
version.
Regards,
Jeff
Thanks it worked,but
the errors what i showed down has not rectified.
ODBC.xs, line 172: undefined symbol:
Please post the output of makeifle.pl and all of make. I believe it's not
properly picking up the unixODBC headers.
regards,
Jeff
-Original Message-
From: Janarthanan, Prasanna [mailto:[EMAIL PROTECTED]]
Sent: Saturday, September 21, 2002 5:09 AM
To: '[EMAIL PROTECTED]'; '[EMAIL
`ODBC.o'
janarthp@sys1:/u/janarthp/DBD
--
Also i have all setenv correctly.
ODBCINI, LD_LIBRARY_PATH
help!
thanks
Prassana
-Original Message-
From: Jeff Urlwin [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 23, 2002 6:55 PM
To: Janarthanan, Prasanna; [EMAIL PROTECTED
in any way will help this.
Regards,
Jeff
-Original Message-
From: Janarthanan, Prasanna [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 23, 2002 12:30 PM
To: 'Jeff Urlwin'
Subject: RE: Problem installing DBD:ODBC(UnixODBC).
You can edit the makefile directly to add a -I/your/path
for this error at 'make' .
Please help me out in installing this.
thanks
Prassana
-Original Message-
From: Janarthanan, Prasanna
Sent: Tuesday, September 24, 2002 11:49 AM
To: 'Jeff Urlwin'
Cc: [EMAIL PROTECTED]
Subject: RE: Problem installing DBD:ODBC(UnixODBC).
Its fine..
i
:49 AM
To: 'Jeff Urlwin'
Cc: [EMAIL PROTECTED]
Subject: RE: Problem installing DBD:ODBC(UnixODBC).
Its fine..
i tried it ... errors are at dbdimp.c.
ERROR
-
janarthp@sys1:/u/janarthp/DBD make
/usr/local/bin/perl -I/usr/local/lib/perl5/5.6.1/sun4-solaris
-I/usr/local/lib/perl5
Roger,
I've finally had a chance to look at this (going through my queue of issues
questions). What I can see is the following:
- No result columns are being returned
- DBD::ODBC calls SQLMoreResults (and gets SQL_SUCCESS_WITH_INFO) to skip
over the empty result set
-
Make sure the permissions of the web server user allow access to the drives,
ini files, etc. I don't know much more abot freeTDS, though, so I'd
probably start there to find out what caused the error.
Also, since you don't say which version of DBD::ODBC you are using, I know
there were some
:[EMAIL PROTECTED]]
Sent: Thursday, September 26, 2002 11:38 AM
To: 'Jeff Urlwin'
Cc: [EMAIL PROTECTED]
Subject: RE: unixODBC and DBD::ODBC fails to connect
I've changed the ownership of odbc.ini and odbcinst.ini to my www
user, but
to no avail. I also have freetds logging all error messages
Thank you Ilya!
May I make a suggestion: we put the link to the FAQ on *every* e-mail to the
dbi mailing lists and include instructions in the FAQ as to how to subscribe
and unsubscribe to dbi-users, dbi-dev and dbi-announce? We have had a run
lately of people asking how to unsubscribe and,
On Fri, 27 Sep 2002 17:34:04 +0100 Tim Bunce [EMAIL PROTECTED] wrote:
I'd rather opt for having a welcome message for new subscribers plus
a message posted to the list monthly.
My little rant goes up about weekly and there's never any indication that
the target read the previous
However --
DBI and DBD::ODBC in ActiveState's repository are SADLY out of date. You
can get the PPDs and tar.gz files from:
ftp://ftp.esoftmatic.com/outgoing/DBI
Regards,
Jeff
OK. If you're using Windows, then you shouldn't need to make anything.
If you haven't already, get hold of
Try searching for your answer in the DBI FAQ www.xmlproj.com/cgi/fom.cgi
first. Then, if that doesn't help, post the error information, version of
perl, version of DBI, version of DBD::ODBC along with the code again.
Regards,
Jeff
Hi
I am trying database connectivity using DBI/ODBC thru
Mac,
ftp://ftp.esoftmatic.com/outgoing/DBI
I have a few opinions on this, though:
1) If someone else's DBI and my DBI don't match, we'll have some problems
with someone trying to take DBI and DBD::ODBC and then DBD::Oracle from a
different site. In theory, if we are all running DBI
Try upgrading to .45_18. You'll need an ODBC v3 compliant driver manager.
0.43 was the last (or near the last) version which built against
Check out http://search.cpan.org/author/JURL/DBD-ODBC/Changes
This was fixed in .45_12.
Regards,
Jeff
Hi Jeff,
i am having a problem with the
-Original Message-
From: Darren Edgerton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 12:42 AM
To: Jeff Urlwin
Cc: [EMAIL PROTECTED]
Subject: RE: DBD-ODBC core dumps (atexit)
Hi Jeff,
i tried .45_18 but still get the same results
here is the ouput from:
perl
Upgrade DBD::ODBC to the latest version. The ActiveState repository version
is old, so you'll have to look at the archives for how to ftp it from my
site.
Jeff
-Original Message-
From: Marusic Juraj [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 11, 2002 10:29 AM
To: [EMAIL
. It still
fails my test.
Sigh .. . here's the test I used (at the bottom) -- isn't that what you
sent?
Jeff Urlwin wrote:
Roger,
I've finally had a chance to look at this (going through my
queue of issues
questions). What I can see is the following:
- No result columns are being
1 - 100 of 615 matches
Mail list logo