Sitemap

Amicuk Programming Answers

Help with Access connecting to a Oracle DB on a Windows 7-64bit workstation

-0001-11-30   Views:1

Advertisement

Hello: Here's my configuration: OS: Windows 7-64bit Oracle DBMS: 11g I am trying to connect to a 11g DB from within Access. I launched the ODBC Administrator from c:\windows\syswow64 directory as an Administrator (which I undertstand is the 32-bit ve

Hello:
Here's my configuration:
OS: Windows 7-64bit
Oracle DBMS: 11g
I am trying to connect to a 11g DB from within Access.
I launched the ODBC Administrator from c:\windows\syswow64 directory as an Administrator (which I undertstand is the 32-bit version). When I tried to set up a new DSN, I encountered two problems:
1. The TNS Service Name dropdown has a slew of entries with funny characters. However, it did not include my TNS Entry.
2.  I manually entered my TNSName. It did ask me for the username and password. When I tested the connection, I got an error "ORA-12154"
Any help to resolve the issue will be much appreciated.
Venki

The replay answer
Advertisement
Senthil:
What should it point to?
Anyway, I re-installed both the 64-bit Oracle DB and the 32-bit client. There are two sets of TNSNames.Ora, Listener.Ora and SQLNet.ora, one for the 64-bit and one for the 32-bit in their respective folders.
I have no problem creating an ODBC DSN for the 64-bit version. The link connects fine to the DB
I have two TNS Listeners defined, one for the 64-bit and one for the 32-bit. While the 64-bit uses Port 1521, I am using Port 1522 for the 32-bit; I also made sure that Listener.ora refers to the same port. But when I use Oracle Net Configuration Assistant to configure Local Net Service Name Configuration to test the Service, it says "TNS:listener does not currently know of the service requested in connect descriptor.
I did check that both the TNS Listener services are running.
venki

Go to See the other 4 answers

Help with Access connecting to a Oracle DB on a Windows 7-64bit workstation

Category:DefaultRelease time:-0001-11-30Views:130

Hello: Here's my configuration: OS: Windows 7-64bit Oracle DBMS: 11g I am trying to connect to a 11g DB from within Access. I launched the ODBC Administrator from c:\windows\syswow64 directory as an Administrator (which I undertstand is the 32-bit ve[More]

Cannot connect properly to Oracle on Linux from Windows

Category:DefaultRelease time:2015-10-11Views:130

Good day all, I’ve got 2 virtual machines running on my Mac: -     Centos 5.4 with Oracle 11gR2 -     Windows 2003 server with Oracle 10gR2 From Linux box I have access to Oracle database on Windows box (both directly and via a database link), howeve[More]

Connect linux 4 oracle 10g client to window 2003 server oracle 10g server

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have my oracle 10g server installed on windows 2003 server. On another system i have oracle 10g client is installed having RedHad enterprise edition 4. I want to connect my client to the database server. I check using oracle universal installer[More]

Oracle 10.2 on Windows 2008R2 64bit

Category:DefaultRelease time:2015-10-11Views:130

Hello, I obtained IDES installation DVDs from SAP. I wanted to start installation, so first step was Oracle database. The problem is that SAP gave me DVD from 2006 with Oracle 10.2. There are three architectures available and noone wants to cooperate[More]

Oracle 11g client for Windows 8 - 64bit exists impromptu without error msg

Category:DefaultRelease time:-0001-11-30Views:130

HI all. I just got a new laptop and its running Windows 8 Pro 64 bit os. I downloaded Oracle Client 11g 64bit from the oracle website. After clicking the setup.exe installer a msg box pops up saying '[INS -13003] Environment does not meet the require[More]

Access denied ("java.util.PropertyPermission" "user.timezone" "write") [WINDOWS 7 64bit]

Category:DefaultRelease time:-0001-11-30Views:130

Hello, we got on several computers the error message access denied (java.util.PropertyPermission" "user.timezone" "write") when we try to open an internal website. Until today everything worked fine. An update on Java for windows[More]

Oracle client installation on windows 7 64bit

Category:DefaultRelease time:-0001-11-30Views:130

i am trying to install oracle client on win 7, during the installation it popup a message saying cannot copy the files to start menu or desktop. Already i logged in as administrator.Please find the last lines of the log file. INFO: instantiating 'G:\[More]

Unable to connect Toad for Oracle 9.6 to oracle 10g in a windows 7 64-bit

Category:DefaultRelease time:2015-10-11Views:130

Hey friends I am Unable to connect toad with oracle 10 in a windows 7 64 bit environment Please Help Any advice will be appreciatedread this one : Toad ORA-12154: TNS:could not resolve the connect identifier specifiedRead other 3 answers[More]

Access Connections - Many APs with same SSID (Again)

Category:DefaultRelease time:-0001-11-30Views:130

I have a W520 running Access Connections 6.11 (release December 2013) on Windows 7 Pro 64-bit.  Access Connections is still broken in regards to dealing with multiple Access Ponts having the same SSID.  It keeps hoping from one access point to anothe[More]

Connect from VBA 64 bit to Oracle from windows 7 64bit

Category:DefaultRelease time:-0001-11-30Views:130

Hi, We are trying to connect from Autocad VBA 64 bit to Oracle 10g server from windows 7 64bit OS. Toad can connect to Oracle without any issue. I installed 10g 32 bit client and 11g 64 bit client. Please help me in installing and configuring any 64[More]

Thinkvanta​ge Access Connection for Windows Vista 64

Category:DefaultRelease time:-0001-11-30Views:130

My T61 HD has a crash. Need to reinstall everything. Tried to install ThinkVantage Access Connection but it does not work on Windows Vista x64. Is this right?Hi, for the correct flow of Access Connection you should install following apps/driver is fo[More]

Hot
Hi everyone, I need some explanation on why the index is not being used in one of my queries. Here are the queries: SELECT COUNT (1) FROM (SELECT hdr.ALLOC_HDR_SEQ_NBR hdrnbr FROM sm_vda_allocation_header hdr INNER JOIN sm_vda_type vdatype ON hdr.vda [More]
is it possible to create a view from a from a table like this create view my_view as select id, col1, col2, result from <<my_latest_cacahe_table>>; the table in the from clause changes the name . I have another table which indicates the the la [More]
Please help!! I recently installed a new internal hard drive and my itunes library was installed on an external hard drive and when i rebooted my pc after the new drive was installed my drive letters changed and itunes could no longer locate my libra [More]
Hi all experts, I am new to the enhancement of CRM. So, all kind of helps will be greatly appreciated. For your info, I'm using CRM version 5.0 My requirement is to add extra field ID number at Identify Account Screen at Webclient. I have extended an [More]
When I connect my Roland Sound Canvas (external MIDI module connected to the Game/MIDI port) to the line in on the sound card (Audigy2 ZS) but I don't get any sound from the speakers when playing a MIDI file or when recording. When I use sound record [More]
If I install Waveburner (1.6.0 then update) from my original Logic Studio (v9) installation disc onto a my new Mac with Logic Pro X, will it work or does it need other components from Logic 9 or its installation disc? Will it interfere with Logic Pro [More]
i was at the Apple store to buy some USB cables.  i decided to use the apple store app to complete my purchase.  i pay for the cables and tell the person i bought them using the apple store app.  she says take care and i go home.  a little while late [More]
hi i'm trying to execute unix command through java simple shell command like "ls -l >test " but i'm not able to see the result. there are no error messages. Code is: import java.lang.Runtime.*; class ExecDemo      public static void main(Stri [More]
My skype account cannot link to the microsoft account(Before this, I already unlinked the original skype and microsoft) . When I logon the skype with my microsoft account, I found that there is an another skype account and this account is useless for [More]
hey, i'm using jdeveloper11g and I use a RichTable to display data of a ViewObject. The data associated with the view object changes and i need to update RichTable accordingly. However, as I update using Poll the scroll position of the table is chang [More]