On Oct 5, 2011, at 1:53 PM, Bruce Johnson wrote:
> Basic questions: the script is running in an environment where the env
> variables $ORACLE_HOME and $TNS_ADMIN are available? Your tnsnames.ora file
> is present and correct?
I did have the env variables configured, and the tnsnames.ora is now
On Oct 5, 2011, at 1:47 PM, Kong, Alan wrote:
>
> It is different than typing the whole connection description in the command
> prompt as it will bypass tnsnames.ora entry. ODBC is looking for the
> tnsnames.ora entry for connection description, so using the above connection
> method, I bet it
On Oct 5, 2011, at 1:00 PM, Kong, Alan wrote:
> Since you are using DBI::ODBC, you should create an ODBC data source
> pointing to your Oracle database first, and then calling the connect
> function by passing the data source name you just created for ODBC data
> source.
That's our standard confi
. What is the 10.128 ?
>
> -Original Message-----
> From: Scott Stansbury [mailto:sstansb...@aol.com]
> Sent: Wednesday, October 05, 2011 9:09 AM
> To: dbi-users@perl.org
> Subject: DBD::ODBC fails, SQL*Plus works
>
> Folks,
>
> I could use a tip or lead with the fo
Folks,
I could use a tip or lead with the following issue:
I have a Windows Server 2008 R2 box with Oracle Instant Client 11.2, with the
SQL*Plus and ODBC modules installed. No other Oracle software is installed.
I am connecting to an Oracle 10g instance. The following SQL*Plus works:
sqlplus
Yes.
Thank you again.
Best regards,
Scott...
On Jun 30, 2009, at 11:52 AM, Martin Evans wrote:
Scott Stansbury wrote:
Getting closer :)
I'm trying to connect to a SQL Server 2008 instance from a CentOS5
box:
unixODBC: 2.2.14
FreeTDS:0.82
Easysoft: odbc-sqlserver-1.1.26-
Getting closer :)
I'm trying to connect to a SQL Server 2008 instance from a CentOS5 box:
unixODBC: 2.2.14
FreeTDS:0.82
Easysoft: odbc-sqlserver-1.1.26-linux-x86 (this morning, thank you
again Martin and Wez...)
osql/isql work fine with both the FreeTDS and the Easysoft drivers.
C
I'm trying to connect to a SQL Server 2008 instance from a CentOS5 box:
unixODBC: 2.2.14
FreeTDS:0.82
Easysoft: odbc-sqlserver-1.1.4-linux-x86 (trial for now)
osql/isql worked fine with both the FreeTDS and the Easysoft drivers.
Connecting to a SQL Server 2008 instance running on a Serv
