OraFAQ Forum: Networking and Gateways » Creating File DSN with Microsoft ODBC for oracle problem

Home » RDBMS Server » Networking and Gateways » Creating File DSN with Microsoft ODBC for oracle problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Creating File DSN with Microsoft ODBC for oracle problem [message #66682]

Wed, 16 October 2002 19:54

Sahayam Packiaraj
Messages: 1
Registered: October 2002

Junior Member

I have created a Local net service name using Net8 assistant as "MMS" for a database "MMS" residing in a server machine named "Admin", the test was successful.

I try to create a file dsn using the microsoft odbc for oracle which promts for User,password and server.

In server iam little bit confused and use service name for it as "MMS" and it gives not verified.

Tried with server name "Admin" it still gives error, iam not able to find the server name exactly.

Please help me its urgent.

Thank You
Sahayam.J

Report message to a moderator

Re: Creating File DSN with Microsoft ODBC for oracle problem [message #66683 is a reply to message #66682]

Thu, 17 October 2002 05:19

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

look manually in your tnsnames.ora file.
sometimes, the tool automatically creates an extension to servericename.
try to tnpsping service_name
like

c:tnsping MMS

Report message to a moderator

Re: Creating File DSN with Microsoft ODBC for oracle problem [message #66685 is a reply to message #66683]

Fri, 18 October 2002 08:43

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

hi,

Thank you for your response.
I opened the tnsorna.ora file and able to find the service name in my office.

But in my client office this problem still persists, its giving service name as SM and the test was succesful.

when using the same name for server in file dsn creation it gives non verified file dsn.

guid me to also use tnsping which is not working for me..

Thank You,

Sahayam.J

Report message to a moderator

Re: Creating File DSN with Microsoft ODBC for oracle problem [message #66738 is a reply to message #66682]

Fri, 29 November 2002 00:07

Kartik
Messages: 2
Registered: October 2001

Junior Member

Try.

c:TNSPING80 <Service Name>

in your case it is
c:TNSPING80 MMS

Report message to a moderator

Previous Topic:	oracle
Next Topic:	Re: Can't Install 8i Client on Pentium 4 , NT 4 machine workaround

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 01:09:24 CDT 2025