Hello all,
I am trying to test an ODBC connection to an Oracle dbf using the ODBC Data
Source Administrator. It's not working and I suspect I haven't configured
Oracle correctly. Below is the error message I am getting:
[DataDirect][ODBC Oracle Driver]Invalid attribute in connection string:
Description.[DataDirect][ODBC Oracle Driver][Oracle]ORA-12514: TNS:listener
could not resolve SERVICE_NAME given in connect descriptor
I am very new to Oracle and I don't know where to go to fix this. Any
help?
Thanks,
Jake
3  11608 
You need to start by telling us what your connection string is! It would
also help to see the output of "lsnrctl status" on the Oracle server.
--
Cheers,
Chris
_______________ _______________ _____
Chris Leonard, The Database Guy http://www.databaseguy.com
Brainbench MVP for Oracle Admin http://www.brainbench.com
MCSE, MCDBA, OCP, CIW
_______________ _______________ _____
"GitarJake" <gi*******@spam mersuntied.com> wrote in message
news:HYsOc.2599 $FW1.2307@laker ead06... Hello all,
I am trying to test an ODBC connection to an Oracle dbf using the ODBC
Data Source Administrator. It's not working and I suspect I haven't
configured Oracle correctly. Below is the error message I am getting:
[DataDirect][ODBC Oracle Driver]Invalid attribute in connection string:
Description.[DataDirect][ODBC Oracle Driver][Oracle]ORA-12514:
TNS:listener could not resolve SERVICE_NAME given in connect descriptor
I am very new to Oracle and I don't know where to go to fix this. Any
help?
Thanks,
Jake
Hi Chris,
CONNECTIONSTRIN G = "Driver={Micros oft ODBC for
Oracle};Server= db.world;Uid=sa ;Pwd=;"
I can't find "lsnrctl status" on my server. This is 9i, does that count?
Thanks for your time,
Jake
"Chris Leonard" <s_***********@ hotmail.com> wrote in message
news:zI******** *******@news.us west.net... You need to start by telling us what your connection string is! It would
also help to see the output of "lsnrctl status" on the Oracle server.
--
Cheers,
Chris
_______________ _______________ _____
Chris Leonard, The Database Guy
http://www.databaseguy.com
Brainbench MVP for Oracle Admin
http://www.brainbench.com
MCSE, MCDBA, OCP, CIW
_______________ _______________ _____
"GitarJake" <gi*******@spam mersuntied.com> wrote in message
news:HYsOc.2599 $FW1.2307@laker ead06... Hello all,
I am trying to test an ODBC connection to an Oracle dbf using the ODBC
Data Source Administrator. It's not working and I suspect I haven't
configured Oracle correctly. Below is the error message I am getting:
[DataDirect][ODBC Oracle Driver]Invalid attribute in connection string:
Description.[DataDirect][ODBC Oracle Driver][Oracle]ORA-12514:
TNS:listener could not resolve SERVICE_NAME given in connect descriptor
I am very new to Oracle and I don't know where to go to fix this. Any
help?
Thanks,
Jake
"GitarJake" <gi*******@spam mersuntied.com> wrote in
news:xCwOc.2697 $FW1.45@lakerea d06: Hi Chris,
CONNECTIONSTRIN G = "Driver={Micros oft ODBC for
Oracle};Server= db.world;Uid=sa ;Pwd=;"
What you have to do here is open TNSNAMES.ORA, which is located in your
OracleHome directory (C:\ORA_MGMT\ne twork\admin\TNS NAMES.ORA for instance),
and see what the Service_Name is for db.world. Like this:
db.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
)
(CONNECT_DATA =
(SID = SomeName)
(SERVER = DEDICATED)
)
)
In the above case, SomeName is the Service_Name for db.world (called SID
above). So your string would have Server=SomeName ; instead of what you
have above.
I can't find "lsnrctl status" on my server. This is 9i, does that
count?
That's a command line operation to find out the status of the listener.
I'm afraid I'm too much of a newbie to say more than that without looking
it up, myself... I'm trying to look it up now but OTN just isn't
responding.
--
Teresa Redmond
Programmer Analyst III
Anteon Corporation
delete X to email This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: H |
last post by:
This is a question that has haunted me for quite some time.
if you build a 4 tier database application where the 4th tier is the
database server (MS SQL 2000), where do you build the connection string?
The obvious answer is to hard code it into the middle layer and use a config
file.
The problem is the database application needs to be distributed to
purchasing clients. Therefore, you do not know, at development, what the SQL
|
by: Fred Zuckerman |
last post by:
Hello All,
After reading in this group about the preference for connecting to a SQL
Server using a connection string instead of a DSN file, I have done just
that.
BUT, I cannot update my data. I have gone back and forth between using a DSN
file and a DSN-less connection string and I have found the following issue.
When I utilize the DSN file to create the link, there is a step where it
asks me to identify a unique key for the file. If I...
|
by: vighnesh |
last post by:
Hi All
I am dealing a project in ASP.NET in which I have to establish a connection
to SQL Server 2000 database,where the database was located on a remote
system.
For this I have used SQLConnection object and specified the connetion
string.But when it comes to establish a connection its giving me the Error
that
I. Connection string : workstation id=localhost;packet size=4096;user
|
by: effendi |
last post by:
I have the following insercommand in my asp page.
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="
<%$ ConnectionStrings:eventsConnectionString %>"
SelectCommand="SELECT registration.* FROM registration"
InsertCommand="INSERT INTO registration(eventName,
firstName, lastName,instName,faculty, jobTitle,email,
phoneNumber,degreeName, yearOfStudy,interestOthers,eventSource,
|
by: Kavi |
last post by:
Hi all
i'm new to this, your assistence will be greatly appriated :-)
i have a connection string (this all in asp )
tCSCst = Provider=SQLOLEDB;Data Source=<bd>;Port=1444;Initial
Catalog=<cataloge>;User ID=<id>;Password=<password>
| | |
by: colleen1980 |
last post by:
Hi: I am trying to pull all the values from the listbox. But the ASP
code shows only the last record. Needs help
HTML
<html>
<head>
|
by: Jennifer.Berube |
last post by:
well I'm not sure how to go about making my SQL connection string...
The code below is what I need to replace with my SQL connection...I
just don't know if that code is for DSN or access...
I don't want to use DSN just a connection string...help?
function GetConnection()
const DSN = "membershipdb"
const UID = "webuser"
|
by: |
last post by:
Hi All,
I have a client connection problem with Oracle.
The exe which i did with C# (vs.net 2005) and Oracle XE , works well on my
developer machine but i am getting a connection string error on the client
side. The error comes from System.Exception class not from OracleException.
The properties of the Oracle.DataAccess reference are ;
Description: Oracle.DataAccess.dll
|
by: GitarJake |
last post by:
Hello all,
I am trying to test an ODBC connection to an Oracle dbf using the ODBC Data
Source Administrator. It's not working and I suspect I haven't configured
Oracle correctly. Below is the error message I am getting:
Invalid attribute in connection string:
Description.ORA-12514: TNS:listener
could not resolve SERVICE_NAME given in connect descriptor
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
