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
So about 5 days ago this problem started. I've tried everything, uninstalling, reinstalling, installing older versions of Firefox, everything in the help file about this, going into about:config to set scanning to false, uninstalling my virus program [More]
I bought a 23" used HD Cinema display the other day along with the ADC-DVI and DVI-Mini Display adapters. I had it hooked up and it was working perfectly for 3 days. Today my wife tried to connect her Macbook accidentally via the USB that is part of [More]
Hey guys! I am trying to follow the Arch Linux Beginners Guide, but I seem to be stuck at one thing. When making my partitions manually, which of the four sda partitions do I make bootable? I can't seem to write on the partitions unless I make one bo [More]
My issue is this: I have a reportserver on an intranet which users have been using quite happily under IE 8, beacuse of legacy systems we are far from early adopters. I now have some users who have moved to IE 9, however they can now no longer export [More]
Hi, I am working on a video with some green screen. The chroma keyer effect was working great, but then it stopped. All of a sudden it wont key out anything. I change the settings and nothing changes? It is just someone in front of a green screen? I [More]
Hello, in the mySAP ERP 2004, Master Guide", chapter "Technical Overview" it is said that "ERP und BW in the same system ... can only be supported on a project basis". This is difficult to understand for customers who are told tha [More]
Someone already posted an answer how to make the spin tool default here http://forums.adobe.com/message/1146944#1146944 but my problem is I have absolutely no idea whatsoever to run a script. I tried a few things but they didn't work. Can someone exp [More]
I've had two issues recently with my Lombard. 1: The backlight occasionally flickers off on boot - makes a sort of hissing sound. If I wait until it gets to the login screen, then I can fix it by closing the display (putting the 'book to sleep), and [More]
Can I create another icloud/me account including email address? Is there a charge for this service? Thank you.Yes, but it requires creating not simply the iCloud account, but a new AppleID. Your previous purchases will not be assocaited with it. And [More]
Hi Just started working in SOA suite 11g. Need help in figuring out the possiblity of using OSB along with the use of the other SOA components. Taking a simple example requirement of LoanFlowApplication; if the loan application requests an amount gre [More]