Oracle XE (V 10.2.0.1.0) for Windows and ODBC

Hi Folks

I've install Oracle as per the Subject line. This includes the capability to
define ODBC connexions.

I created such a connexion, and I can test it (in the ODBC dialog), and the test
succeeds.

This test uses:
TNS Service Name: XE
The other values for this option are:
EXTPROC_CONNECTION_DATA
ORACLR_CONNECTION_DATA
and I enter the system username/password.

When I connect via Perl, eg using:
dsn=dbi:ODBC:dsn_name
I get this error:
DBI connect('dsn_name','system',...) failed: Specified driver could not be
loaded due to system error 1114 (Oracle in XE). (SQL-IM003)(DBD:
db_login/SQLConnect err=-1) at D:\scripts\create.pl line 17

Any ideas?

Note:
o The Oracle installation directories do not have a file called tnsnames.ora.

o I could not find anything in the Oracle XE docs about ODBC.

o I have previously registered a username/password with Oracle, yet when I click
on the Discussion Forum link (Oracle for Windows has a web browser interface) I
get:
Error: you do not have permission to view the requested forum or category.
Perhaps this is because I'm in Australia!?
Otherwise, I'd ask on that forum.
--
Ron Savage
ron@savage.net.au
http://savage.net.au/index.html

Re: Oracle XE (V 10.2.0.1.0) for Windows and ODBC

On Fri, 12 May 2006 14:39:02 +1000, Ron Savage wrote:

Hi Ron

More info...

> o The Oracle installation directories do not have a file called
> tnsnames.ora.

Oops - Yes it does.

I must have mistyped the name when searching (using Agent Ransack :-).

--
Ron Savage
ron@savage.net.au
http://savage.net.au/index.html

Re: Oracle XE (V 10.2.0.1.0) for Windows and ODBC

On Fri, 12 May 2006 15:01:33 +1000, Ron Savage wrote:

Hi Ron

Yet more info.

The installer creates a env var ORACLE_HOME with no value.

If I set the value to C:\oraclexe\app\oracle\product\10.2.0 the ODBC test then
fails.
--
Ron Savage
ron@savage.net.au
http://savage.net.au/index.html

Re: Oracle XE (V 10.2.0.1.0) for Windows and ODBC

On Fri, 12 May 2006 14:39:02 +1000, Ron Savage wrote:

Hi Ron

Just for the archives:

> When I connect via Perl, eg using:
> dsn=dbi:ODBC:dsn_name
> I get this error:
> DBI connect('dsn_name','system',...) failed: Specified driver could
> not be loaded due to system error 1114 (Oracle in XE). (SQL-
> IM003)(DBD: db_login/SQLConnect err=-1) at D:\scripts\create.pl
> line 17

It's starting working after 1 reboot or 3.
--
Ron Savage
ron@savage.net.au
http://savage.net.au/index.html