Home » RDBMS Server » Networking and Gateways » ODBC Connection problem
ODBC Connection problem [message #367574] Wed, 18 November 1998 06:16 Go to next message
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?
Re: ODBC Connection problem [message #367575 is a reply to message #367574] Wed, 18 November 1998 15:42 Go to previous messageGo to next message
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>
Re: ODBC Connection problem [message #367582 is a reply to message #367574] Tue, 08 December 1998 03:41 Go to previous messageGo to next message
deniz karaman
Messages: 1
Registered: December 1998
Junior Member
No Message Body
Re: ODBC Connection problem [message #367614 is a reply to message #367574] Fri, 12 March 1999 05:23 Go to previous messageGo to next message
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
Re: ODBC Connection problem [message #367772 is a reply to message #367574] Thu, 06 April 2000 09:39 Go to previous message
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?
Previous Topic: Db name
Next Topic: retrieving recordsets returned by oracle stored procedures in ASP
Goto Forum:
  


Current Time: Fri Feb 23 00:54:14 CST 2024