11-25-2004
Oracle 9i ODBC connection
I am attempting to access an Oracle 9i database located on a Solaris server from an XP client. The server is running Oracle 9i9.2.0.1.0 and the XP is Oracle client 9i 9.2.0.1.0. When I start a listener on the server, the listener starts but I receive a message “The listener supports no services”. I can access the database via SQLPLUS on the client using the Oracle client SQL. I can also access through a telnet SQLPLUS session. When I attempt to access the database in ACCESS using ODBC, I receive an error message:
ODBC - call failed.
Microsoft ODBC driver for Oracle ORA 12514: TNS: listerner could not resolve SERVICE_NAME given in connect descriptor (#12514) Driver's SQLSetConnectAttr failed IM006 0 (Microsoft) (ODBC Driver Manager) Driver's SQLSetConnectAttr failed (#)
I realize that Listener.ora and Tnsnames.ora on the client work together. On the server, should I have something comparable?
Also, on other examples I have seen SID used to identify a service, the Oracle client configured as SERVICE_NAME = xxxx rather than SID.
After I can establish this ODBC connection, my ultimate goal is to use dfPower DBMS/Copy on my XP client to load Oracle tables on the server through an ODBC connection.
9 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hello all,
i like to install an application program that will interact with
the oracle database.
oracle has been installed in /export/home/oracle
does the new application has to be in the same directory and
if not which one do you recommend?
There is a drive like the ODBC in oracle to... (2 Replies)
Discussion started by: rsh
2 Replies
2. Solaris
Hi,
I have my application and database servers running on solaris. I need to check Db connectivity for a datasource in my Db server.
Please guide me how to do it in solaris env.
Aru (2 Replies)
Discussion started by: aarora_98
2 Replies
3. SCO
Hi, I'm trying to make an odbc connection to a SCO db using Vista, but I'm having some troubles. In the past I have used Vision97 on either windows 98 and XP, but it will not install on Vista. Is there an alternative driver that I can use to make my connection? Any other workaround?
Thanks,
... (1 Reply)
Discussion started by: knewknow
1 Replies
4. Shell Programming and Scripting
Here is part of my program code:
#Collect the output of test database and count the no
#of rows too
while(my @array = $tstDbStatementHandle->fetchrow_array)
{
push @tstDbOutputArray,;
$tstDbOutputRows++;
}
... (3 Replies)
Discussion started by: sameerstephen
3 Replies
5. Shell Programming and Scripting
Hi All,
I have a requirement where I need to connect to Oracle database which is installed on WINDOWS machine.
I dont have Oracle client installed on my AIX so i can't use SQLPLUS command.
But ODBC to connect to Oracle is configured on my UNIX server. Can any one help me with the steps of... (1 Reply)
Discussion started by: Raamc
1 Replies
6. Linux
Hi ,
I am unable to setup ODBC connection in RHEL5 64 bit and MySql 5.0
I had modified ODBC.ini file , set the env variables such as LD_LIBRARY_PATH,
ODBCINI , ODBCSYSINI etc .
Getting the error as
Data source name not found, and no default driver specified
ERROR: Could not SQLConnect
... (0 Replies)
Discussion started by: roopalidalvi231
0 Replies
7. Programming
hi,
am making oracle connection through pro*c using the following command
sample:
exec sql connect username identified by password.
but m getting the following errors frequently even though listener and db is running fine but some times code is working fine and not giving errors.
... (2 Replies)
Discussion started by: senkerth
2 Replies
8. Shell Programming and Scripting
Hi,
When run the script directly...it executes as expected. But when put it in crontab the job fails with this error:
Connection not open
08003: Connection not open
Unable to connect to the database...
how come it is not able to connect when cron job fires?... Do I need to... (7 Replies)
Discussion started by: nuthakki
7 Replies
9. Shell Programming and Scripting
Hi All,
I want to establish a ODBC connection to a database from linux and query the tables of a database.
Please let me know how I can achieve this.
Thanks and Regards
Nagaraja Akkivalli. (0 Replies)
Discussion started by: Nagaraja Akkiva
0 Replies
LEARN ABOUT DEBIAN
gammu-smsd-odbc
GAMMU-SMSD-ODBC(7) Gammu GAMMU-SMSD-ODBC(7)
NAME
gammu-smsd-odbc - gammu-smsd(1) backend using ODBC abstraction layer to use any supported database as a message storage
DESCRIPTION
New in version 1.29.92.
ODBC backend stores all data in any database supported by ODBC, which parameters are defined by configuration (see gammu-smsdrc for
description of configuration options).
For tables description see gammu-smsd-tables.
This backend is based on gammu-smsd-sql.
SUPPORTED DRIVERS
On Microsoft Windows, Gammu uses native ODBC, on other platforms, unixODBC can be used.
LIMITATIONS
Due to limits of the ODBC interface, you might have to tweak SQL queries to work in used SQL server, see SQL Queries for more details.
Partially this can be configured using SQL.
CONFIGURATION
Before running gammu-smsd you need to create necessary tables in the database. You can use examples given in database specific backends
parts of this manual to do that.
You specify data source name (DSN) as Host in gammu-smsdrc. The data source is configured depending on your platform.
On Microsoft Windows, you can find instructions on Microsoft website: http://support.microsoft.com/kb/305599
For unixODBC this is documented in the user manual: http://www.unixodbc.org/doc/UserManual/
EXAMPLE
Example configuration:
[smsd]
service = sql
driver = odbc
host = dsn_of_your_database
sql = sql_variant_to_use
user = username
password = password
See also
gammu-smsdrc
AUTHOR
Michal iha <michal@cihar.com>
COPYRIGHT
2009-2012, Michal iha <michal@cihar.com>
1.31.90 February 24, 2012 GAMMU-SMSD-ODBC(7)