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
I don't really mind either way, but will I have to buy my music all over again, or will I get the new product with my music already on it? To make this a bit simpler, my itunes account never correctly synced with the music I bought on my ipod. I had [More]
We purchased a hp officejet pro x476dw printer after alot of research and lengthy discussions with HP Canada to determine the best printer which would meet our needs.  We purchased it Oct 2014 and it quite working April 2015. We had not purchased the [More]
This morning I woke up and went to turn on my music. However, my list was empty! My beloved name-branded "podcasts" were all missing! Being a rational person I calmly tried to fix it myself being of some computer knowledge, but lo, I could not. [More]
I Have a 2008 MacBook with a broken screen, how can I access the hard drive?1. Connect an external monitor. If everything else is working fine on the MacBook, you'll have full access to your computer. Or 2. If the MacBook has a FireWire port, use Tar [More]
When I generate a "Standard Report" (to a printer or PDF) with the attached code, the output looks like this: If I instead use the same code to generate an HTML report, the output looks like this: Can anyone explain why the HTML output has had t [More]
the Facebook LIke button doesn't work on the mobile web version mde with adobe muse.....in the desktop version it works perfectly bbut in a tablet or smartphone it doesn't work you should fix thatI'm unable to reproduce the problem! FB Like button se [More]
Hi All,           What is the optimum time for inserting 1.5 million records to Oracle Staging Table? My scenario ECC to Oracle is taking 3 hours. With your previous experience, what do you think about this. Is there a scope of improvement? We have a [More]
Hi all! I have some problem when using the vga of the Tecra R840-111 with my external monitor/tv (LG M237WDP). The monitor continuosly restarts (it seems like to reboot). This behaviour doesn't happen with another external monitor or if I use another [More]
Trying to create this thing but no matter what I do I keep getting this ridiculous error: Cannot create a linked row and column template based on the selected rows. The grid needs to have at least one data row that is not part of a row and column tem [More]
Rather than sifting through this vast ocean of forums and discussion for an indirect solution to somebody elses' problem, I figured it's in my best interest to begin a new topic. So, while I was burning some cd's and whatnot, out of nowhere, my itune [More]