OraFAQ Forum: Networking and Gateways » ODBC Connection problem

Home » RDBMS Server » Networking and Gateways » ODBC Connection problem

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

ODBC Connection problem [message #367574]

Wed, 18 November 1998 06:16

Iris
Messages: 2
Registered: November 1998

Junior Member

I encountered some connection problem, please give some pointers . See my Lotus Notes Agent is trying to connect to our fax server and faces the connection problem with the following errors:

The ODBC Error Messages is : INTERSOLVODBC Oracle drive]]OracleORA-12545: TNS:name lookup failure.

Not sure whether is the connection timeout problem?

Report message to a moderator

Re: ODBC Connection problem [message #367575 is a reply to message #367574]

Wed, 18 November 1998 15:42

Bruce
Messages: 21
Registered: November 1998

Junior Member

Iris,

It looks to me like the data source name you are using is not defined in the tnsnames file of sql*net. Have you tested to make sure SQL*net is working correctly for that database without ODBC? Use the netping executable to do your check.

HTH
Bruce
<CENTER><A ONMOUSEOVER="window.status='Ambassador Consulting - People First!'; return true" HREF="http://www.ateam.com/" ONMOUSEOUT="status=' ';"><IMG SRC="http://www.ateam.com/assets/images/teamlogo.gif" BORDER="0">[/url]</CENTER>

Report message to a moderator

Re: ODBC Connection problem [message #367582 is a reply to message #367574]

Tue, 08 December 1998 03:41

deniz karaman
Messages: 1
Registered: December 1998

Junior Member

No Message Body

Report message to a moderator

Re: ODBC Connection problem [message #367614 is a reply to message #367574]

Fri, 12 March 1999 05:23

Abdul Aziz
Messages: 1
Registered: March 1999

Junior Member

Hello:

We are testing a oracle based application, we can tnsping the server, but while running the application we get an error after giving the user name and the password. Run-Time error '3151' ODBC - connection to 'mispc' (is the name of the application we are testing) failes.

We would appreciate if we can find a solution to this problem.

Thanks and have Great Day

Abdul Aziz
Aziz-Abdul@usa.net

Report message to a moderator

Re: ODBC Connection problem [message #367772 is a reply to message #367574]

Thu, 06 April 2000 09:39

René Kamphuis
Messages: 1
Registered: April 2000

Junior Member

When using the INTERSOLV-ODBC driver on an Interbase database instead of the earlier driver by Visigenic, an error occurs on some queries.
The error is generated by the INTERSOLV-ODBC driver and is as follows:
"Character, decimal and binary parameters cannot have a precision of zero. Error in parameter 8."
Does anyone have a clue?

Report message to a moderator

Previous Topic:	Db name
Next Topic:	retrieving recordsets returned by oracle stored procedures in ASP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 03:16:35 CDT 2025