| Computers Forum Index » Computer - Databases - Oracle » OLEDB and Oracle XE ? |
|
Page 1 of 1 |
|
| Author |
Message |
| Ove |
 Posted: Tue May 16, 2006 7:37 pm |
|
|
|
Guest
|
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.DataLinks. VB code:
Dim dataLink As New MSDASC.DataLinks
sDBConnection = dataLink.PromptNew '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 |
|
|
| Back to top |
|
|
|
| Viktor Zacek |
| Posted: Mon May 22, 2006 5:20 pm |
|
|
|
Guest
|
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 |
|
|
| Back to top |
|
|
|
|
