OLEDB and Oracle 10g Express?
- From: "Ove" <Ove@xxxxxxxxxx>
- Date: Wed, 17 May 2006 12:32:23 GMT
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 10g Express
Edition.
The application is a VB6 app.
I installed Oracle 10g Express Edition and Oracle Client 10g Express Edition
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
.
- Prev by Date: Re: VFPOLEDB, SQL2000, linked server, memo field
- Next by Date: Re: Getting column types with oledb
- Previous by thread: VFPOLEDB, SQL2000, linked server, memo field
- Next by thread: Re: Getting column types with oledb
- Index(es):
Relevant Pages
|
|
