l app.
So after you have the DSN set up correctly and successfully tested, you must
reference the DSN and login parameters correctly in your perl code, in the
DBI->connect() function.
Hope this helps
Hugh J. Hitchcock
Sr. Software Engineer, TIAXA
http://www.tiaxa.com
> -Original Message---
erely,
Hugh J. Hitchcock
Sr. Software Engineer / Project Manager
Tiaxa, Inc.
http://www.tiaxa.com
coming in as
passwordHASH(0x1246) or something.
Also if you are using the LocalServer you may want to make another DSN
specifically for your machine's ip address instead of using LocalServer DSN.
Hope this helps
Hugh J. Hitchcock
Programmer / Developer
my $dbh = DBI->connect(
probably the placehoder answer would work. But other than that, I think this
would probably work:
my $sth = $dbh->prepare("insert into emails values ('$addr')")
|| die "Can't prepare statement: $DBI::errstr";
embedding the value inside of double quotes or
my $sth = $dbh->prepar
esults or what, but it is getting very
frustrating! Does anyone have any insight into this phenomenon?
Many, many thanks in advance. Sincerely,
----
Hugh J. Hitchcock
Sr. Software Engineer / Project Manager
Tiaxa, Inc.
http://www.tiaxa.com
right, but... not to be difficult or anything, but that's not really a
dsn... it is a connection string. A dsn is an ODBC data source name (on
windows) which is configured through the control panel. But yes, this would
be the solution to the question.
(btw you could probably use a single quote in
of
using a DSN in the first place.
Hoever it is quite easy to create your ODBC connection without a DSN... and
then programmatically change connection properties without using a DSN. As
Neil Lunn suggested, you should probably just check out the ODBC examples.
HTH
Hugh J. Hitchcock
Program
well, yes, but...
I realise my way is sort of a hack. However, I do view it as a quick and
easy way to get things running without cluttering up a machine with about a
gigabyte of unneeded files, if and when you'd prefer not to. To download the
software you'd need to install the Oracle client, it
need to deal with in my endeavours and I will
certainly let you know the outcome ;)
Hugh J. Hitchcock
Programmer / Developer
> -Original Message-
> From: Modi Ketan-G17361 [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 25, 2001 8:49 PM
> To: '[EMAIL PROTECTED]'
one more addendum: I'm not sure if this solves the problem when using CPAN.
I did end up just cd ing to the DBD-Oracle directory, then running perl
Makefile.PL, then make,. make test, make install and it all worked fine. In
fact, it worked fine even before I had all those files but the connection
achine, say, in /usr/lib/oracle . Make sure the env variable for
ORACLE_HOME = /usr/lib/oracle and LD_LIBRARY_PATH includes /usr/lib/oracle .
You can set the env var in your perl script by typing
$ENV{'ORACLE_HOME'} = '/usr/lib/oracle';
Hope this helps
-------
using DBD::Oracle? I know it's a lot to ask. My profuse
thanks in advance.
Sincerely,
--------
Hugh J. Hitchcock
Sr. Software Engineer / Project Manager
Tiaxa, Inc.
http://www.tiaxa.com
12 matches
Mail list logo
