Home » Open Source » Programming Interfaces » ODBC connection problem
ODBC connection problem [message #249403] Wed, 04 July 2007 06:20 Go to next message
mahbub
Messages: 4
Registered: July 2007
Location: Bangladesh
Junior Member
Please help...


this is my Tnsnames.ora file
--------------------------------
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

INST1_HTTP.NFPCSPFAO.LOCAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Pervez)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

EXTPROC_CONNECTION_DATA.NFPCSPFAO.LOCAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

MPB.NFPCSPFAO.LOCAL=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Pervez) (PORT = 1521))
)

(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MPB.Pervez)
)
)

access_db.world=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = MPB.Pervez) (PORT = 1521))
(CONNECT_DATA =
(SID = hsmsql))
(HS = ok)
)


THis is the lisnter.ora
-------------------------

# LISTENER.ORA Network Configuration File: C:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Pervez)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = extproc)

)
(SID_DESC =
(SID_NAME = hsmsql)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = hsodbc)

)

(SID_DESC =
(GLOBAL_DBNAME = MPB.Pervez)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = MPB)
)

)


and this is inithsodbc.ora
---------------------------

# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent.

#
# HS init parameters
#
# HS_FDS_CONNECT_INFO = <odbc data_source_name>
# HS_FDS_TRACE_LEVEL = <trace_level>


HS_FDS_CONNECT_INFO = testdb
HS_FDS_TRACE_LEVEL = 0


#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>

------------------
The user dsn name is testdb and the driver is microsoft access driver.

i am using oracle 9i, sql * plus..

i don't know what i am wrong but couldnot connect to access database

please help me

Re: ODBC connection problem [message #249556 is a reply to message #249403] Thu, 05 July 2007 00:46 Go to previous messageGo to next message
mahbub
Messages: 4
Registered: July 2007
Location: Bangladesh
Junior Member
one thing i should mention here...
everyday when i start sql*plus with scott/tiger, it gives error message 'shared memory realm doesnot exists'

what i do is Run the Database configuration assistant, after finishing the wizard, it says nothing is configured. But after running the wizard i can run sql*plus with scott/tiger!!!

can anybody helpme out what's the problem is?
Re: ODBC connection problem [message #249561 is a reply to message #249556] Thu, 05 July 2007 01:05 Go to previous messageGo to next message
Michel Cadot
Messages: 59282
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Start the database.

Regards
Michel
Re: ODBC connection problem [message #249578 is a reply to message #249403] Thu, 05 July 2007 01:51 Go to previous messageGo to next message
mahbub
Messages: 4
Registered: July 2007
Location: Bangladesh
Junior Member
How?? see i'm a novice
Re: ODBC connection problem [message #249580 is a reply to message #249556] Thu, 05 July 2007 02:00 Go to previous messageGo to next message
malikjee
Messages: 80
Registered: May 2007
Location: lahore
Member

hi there !
i learnt ur question here in web. its nt big problemto not be sign in sql/pl.
two problemmight be;
u cant be sign in sql before u have created database sucessfully.restart the databse if problemnot be slove then throgh dbca u create again datase after dellete ,mfayyazawan@yahoo.comis web ades 2 direct contact
Re: ODBC connection problem [message #249593 is a reply to message #249580] Thu, 05 July 2007 02:25 Go to previous messageGo to next message
Michel Cadot
Messages: 59282
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Unreadable and incomprehensible post.
Thanks for posting your email, I will spam you now.

Regards
Michel
Re: ODBC connection problem [message #249595 is a reply to message #249578] Thu, 05 July 2007 02:26 Go to previous messageGo to next message
Michel Cadot
Messages: 59282
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
mahbub,
Log on to the server, start SQL*Plus, connect "sys as sysdba" and exexute "startup".

Regards
Michel
Re: ODBC connection problem [message #249600 is a reply to message #249403] Thu, 05 July 2007 02:39 Go to previous messageGo to next message
mahbub
Messages: 4
Registered: July 2007
Location: Bangladesh
Junior Member
i try to logon with sys,<mypassword>, sysdba
but it says TNS could not resolve the service name

[Updated on: Thu, 05 July 2007 02:41]

Report message to a moderator

Re: ODBC connection problem [message #249613 is a reply to message #249600] Thu, 05 July 2007 03:41 Go to previous messageGo to next message
Michel Cadot
Messages: 59282
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy and paste what you did.
Have a look at the "connect" statement in the documentation.

Regards
Michel
Re: ODBC connection problem [message #250029 is a reply to message #249593] Sat, 07 July 2007 02:28 Go to previous messageGo to next message
malikjee
Messages: 80
Registered: May 2007
Location: lahore
Member

Sorry sir Mr Michel!
realy very sorry actualy one of my freind was usng my web address to be sign in with my orafaq id . i m realy very sorry. i will never do at all in future,
i have a question for u regarding gatway service smtp .plz give me example of it . i m tcp user .
waiting for ur answer
regards;
malik
Re: ODBC connection problem [message #250039 is a reply to message #250029] Sat, 07 July 2007 03:34 Go to previous message
Michel Cadot
Messages: 59282
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you have a clear question, open a new topic with it.
SMTP and TCP is not the subject of this thread.

Regards
Michel
Previous Topic: how to connect to Oracle from jsp page in Eclipse?????
Next Topic: Can not connect to Oracle 10g with PHP 4.3
Goto Forum:
  


Current Time: Wed Oct 01 03:18:51 CDT 2014

Total time taken to generate the page: 0.14846 seconds