connecting oracle DB using ODBC

Mahesh.V

Hi All
I get the following error while connecting to the oracle database using
ODBC. in my VB.NET application. Can any one help me out solving this problem

server message (if any):
"ORA-12154:TNS:could not resolve service name

Thank in Advance
Mahesh.V

Nov 21 '05 #1

Subscribe Reply

3665

Steve Planck

Is there a specific reason why you aren't just using the Oracle adapter for
..NET instead of ODBC? You will receive better performance with the Oracle
adapter and it integrates much more nicely than ODBC.

"Mahesh.V" <ma****@ewaksof t.com> wrote in message
news:%2******** ********@TK2MSF TNGP14.phx.gbl. ..

Hi All
I get the following error while connecting to the oracle database using
ODBC. in my VB.NET application. Can any one help me out solving this
problem

server message (if any):
"ORA-12154:TNS:could not resolve service name

Thank in Advance
Mahesh.V

Nov 21 '05 #2

Carlos J. Quintero [.NET MVP]

It could be that your TNSNAMES.ORA file is not properly configured or that
your connect string is wrong (which is it?), but the first step to solve
Oracle connectivity problems is to test with SQL*Plus, the native Oracle
tool. Does it work?

Once solved, it is better to use the native .NET providers for Oracle from
Microsoft or from Oracle (ODP.NET).

--

Best regards,

Carlos J. Quintero

MZ-Tools: Productivity add-ins for Visual Studio .NET, VB6, VB5 and VBA
You can code, design and document much faster.
Free resources for add-in developers:
http://www.mztools.com

"Mahesh.V" <ma****@ewaksof t.com> escribió en el mensaje
news:%2******** ********@TK2MSF TNGP14.phx.gbl. ..

Hi All
I get the following error while connecting to the oracle database using
ODBC. in my VB.NET application. Can any one help me out solving this
problem

server message (if any):
"ORA-12154:TNS:could not resolve service name

Thank in Advance
Mahesh.V

Nov 21 '05 #3

Similar topics

1386

Handle count leak when connecting to Oracle via ODBC on Windows

by: Kong Li | last post by:

Follow up to this thread, the latest Oracle 9i release 2 patchset (9.2.0.5) fixed the handle count leak problem. The problem is in Oracle client component. Thanks. Kong ----- From: Kong Li (likong@email.com)

Oracle Database

1956

Connecting to Oracle 9i

by: va | last post by:

I am trying to establish a connection to Oracle 9i from asp.net.(.net 2003) The code is Dim con As New ADODB.Connection con.ConnectionString = "PROVIDER=MSDASQL;DRIVER= {Microsoft ODBC for oracle};SERVER={server name};UID={user id};PWD={password};" con.Open()

.NET Framework

1751

difficulty connecting to networked oracle database

by: yahibble | last post by:

Now, I am no Python expert but I have dabbled and I have spent a couple of days with another engineer unsuccessfully installing oracle drivers for MS ODBC on the win XP machine. It looked to me like ODBC was the best way to get a (free) python module to upload data to an oracle database table. Aside from installing oracle clients to ODBC being a pain, I would like to consider other ways to connect. Has anyone had experiences with...

Python

7228

Javascript, ODBC, and Oracle functions returning cursors

by: Roger Redford | last post by:

Dear Experts, I'm attempting to marry a system to an Oracle 817 datbase. Oracle is my specialty, the back end mainly, so I don't know much about java or javascript. The system uses javascript to make ODBC calls to the db. The particular system I'm working with, will not work with an Oracle stored procedure I'm told. However, it

Javascript

1644

web app not connecting to oracle DB

by: msnesw.microsoft.com | last post by:

I developed a web application about a year ago that connects to the Oracle DB using MS ODBC for Oracle. But I had to move the whole application to a brand-new PC . When I try to run I get the error: "The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation..." I installed the Oracle client (v8i) and MDAC_TYP.EXE for any ODBC components. Then I added Microsoft.Data.Odbc as a...

C# / C Sharp

10770

Connecting to Oracle 9i Lite from VB.NET ODBC

by: Andrew McGregor | last post by:

Hi, I am trying to get a VB.NET application to connect to a local Oracle 9i Lite database. What is the correct form for a connect string? cn = New Microsoft.Data.Odbc.OdbcConnection("dsn=POLite;Trusted_Connection=yes;User Id=SYSTEM;Password=MANAGER")

Visual Basic .NET

3798

Connecting to ODBC DB at startup

by: RLN | last post by:

RE: Access 2003 using WinXP SP2 Problem: When I start up my app I double click either one of my two Oracle tables in the table list, it asks for an id and pass. I need them to be linked at startup automatically. The Oracle db contains two tables I need. I've already created an ODBC data source that contains the userid and pass to link to the Oracle DB. It works. When I go into linked table manager, I can link to them just fine

Microsoft Access / VBA

1626

Hard time connecting to Oracle database from Visual Web Developer 2005

by: antonyliu2002 | last post by:

I am having a hard time connecting to an oracle database from within Visual Web Developer (VWD) 2005 Express Edition. Check out the screen snap shot here: http://static.flickr.com/97/241874792_aebbadac2b_o.gif Here is the situation: 1. The oracle database runs on Machine A.

ASP.NET

2709

Connecting to an Oracle Database using ASP

by: piyushdabomb | last post by:

Hi Oracle Gurus!! Before I proceed, as per the moderators request, I would like to mention that I have already taken a look at the other threads pertaining to a similar issue which I am having and have not found a feasible answer. I would like to apologize if there is an answer out there (I've looked at quite a few threads). So here is the situation: Currently, I have been using Oracle Toad from Quest Software to connect to the...

Oracle Database

8168

Changing the language in Windows 10

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,...

Windows Server

8614

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

6107

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

5561

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

4075

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4167

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2603

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1780

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1474

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General