OLEDB and Oracle XE ?

[Ove]

Hi,

I'm a newbie when it comes to Oracle, but I was asked to check if an
application could run with Oracle, so I installed Oracle XE.
The application is an older VB6 app.

I installed Oracle XE and Client XE on the same XP machine as my application
and checked that the database engine is running.

I fail to point out the database with the PromptNew dialog in
MSDASC.DataLink s. VB code:
Dim dataLink As New MSDASC.DataLink s
sDBConnection = dataLink.Prompt New 'Prompt for connection string

The only Oracle related providers in the list are
Microsoft OLE DB Provider for Oracle
and
Oracle Provider for OLE DB

The first one requires a Server Name in the next tab. I enter XE as it is
the name of my database, user system and it's password and test the
connection.
It says ORA-12154: TNS could not resolve the connect identifier.

The second one asks for Datasource. I enter XE again (perhaps wrong?)
Again ORA-12154.

I don't want to require that the user sets up a DSN.
Please help me - What is wrong here?

Regards,
Ove

[Viktor Zacek]

Re: OLEDB and Oracle XE ?

Greetings!

I have already worked with ADODB and do not know MSDASC...
but I also had some problems.
Solution was simple... VB6 only reads the first ORACLE_HOME out of the
registry.
I set up a new string ("TNS_ADMIN" ) which pointed to one central
tnsnames.ora/sqlnet.ora.
Now every database in this tnsnames.ora is accessible.

Regards,
Viktor Zacek