Home » Infrastructure » Windows » getting started with ADO and Oracle
getting started with ADO and Oracle [message #99642] Sun, 03 February 2002 18:46 Go to next message
Dominic
Messages: 7
Registered: July 2000
Junior Member
I'm trying to link into an oracle table from Access. I use the following code:

Dim cnMac As ADODB.Connection
Set cnMac = New ADODB.Connection

cnMac.Open "Provider=MSDAORA;Data Source=localhost;" & _ "User ID=demo252;Password=demo252"

but get an error:

ORA-12514:TNS: Listener could not resolve SERVICE_NAME given in connection descriptor.

I've only just started with interfacing oracle with access and am sure theres a simple solution to my problem, but can't work out what.

Report message to a moderator

Re: getting started with ADO and Oracle [message #99648 is a reply to message #99642] Tue, 05 February 2002 11:46 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
Not sure about ADO but you do have to have a DSN (system/user) and matching alias entry (same name as the DSN) in your tnsnames.ora file.

Report message to a moderator

Re: getting started with ADO and Oracle [message #101064 is a reply to message #99642] Sun, 11 April 2004 22:11 Go to previous message
sujit
Messages: 94
Registered: April 2002
Member
Configure Oracle Service Name Thruogh Net8 Client Configuration and Configure Listner.

Report message to a moderator

Previous Topic: jrew errors !
Next Topic: ODBC - Connection
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 14:12:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.