On Tue, Jul 28, 2009 at 02:44:55AM -, Greg Sabino Mullane wrote:
>
> Version 2.14.0 of DBD::Pg has been released and is available on CPAN.
>
> 2.14.0 Released July 27, 2009 (subversion r13130)
>
> - Return ints and bools-cast-to-number from the db as true Perlish numbers.
>
>
Hello Scott:
I suggest that you check to see if the string $DBI::errstr is empty rather than
just whether the 'do' function executed correctly.
It seems that the SQL is correctly submitted from the DBI side but the database
server actually produces an error message. So this is a server side e
Hello, I was wondering if the DBI can determine if there are warnings after an
INSERT statement. For example, here's some MySQL code:
mysql> INSERT INTO test(id,name,age) VALUES ("1","Bob","abc");
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> show warnings;
+-+--+--
Hi,
http://www.orafaq.com/wiki/Tnsnames.ora
will provide you with the information you are looking for.
You may want to read up on some oracle basic before continueing to save
yourself additional hassle if you have no oracle knowledge. JHMO.
Regards,
Michael
On Tue, 28 Jul 2009, Ming Yu wrot
I changed {Microsoft ODBC for Oracle} to {Oracle in instantclient_11_1} as
specified in ODBC_IC_Readme_Win.html file. And I added sid=ORADB (my database
name). I'm reading the instruction in the ODBC_IC_Readme_Win.html file and here
are my question:
How do you set up the TNS_ADMIN? I don't seem
Hello
1) By adding sid= in the DSN, you should be able to point to the correct
SID.
So in your case :
my $DSN = 'driver={Microsoft ODBC for
Oracle};server=10.1.6.9:1521;sid=XX;uid=oradbuser;pwd=oradbpassword;';
2) You should not use "Microsoft ODBC for Oracle" that is a very old driver,
Hi,
I've been trying to connect to a remote Oracle database through Windows XP but
couldn't make it work after a few days' effort. This is what I've done:
1. Install ActivePerl on Windows.
2. Install DBI module.
3. Install DBD::ODBC module.
4. Inside my perl code, I choose to connect without DSN
I am trying to install DBD::msql i run the under given command
**$ sudo perl -MCPAN -e 'install DBD::mysql'**
CPAN: Storable loaded ok (v2.18)
Going to read /home/raheel/.cpan/Metadata
Database was generated on Sun, 26 Jul 2009 10:26:58 GMT
Running install for module 'DBD::mysql'
CPAN: Data::Dum
Michael Thompson wrote:
> I am having difficulties connecting to Microsoft SQL 2005 from a Perl script.
> I am using DBI 1.609 with unixODBC 2.2.8 and freeTDS 0.82. The commands
> isql, tsql -H, and tsql -S all connect successfully and respond as expected
> to queries, but when I try to connec
I am having difficulties connecting to Microsoft SQL 2005 from a Perl script.
I am using DBI 1.609 with unixODBC 2.2.8 and freeTDS 0.82. The commands isql,
tsql -H, and tsql -S all connect successfully and respond as expected to
queries, but when I try to connect through DBI, I get the followi
10 matches
Mail list logo
