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
iPad recognizes my HP wireless printer but still nothing happens when I press print.  Why?If your using the option at the top next to the address bar to print, that the box with the arrow, that only looks for airPrint printers. That will not work on [More]
Hi, We are using Reports 10g (10.1.2) on Solaris Operating System (SPARC 32-bit). We wanted to print barcodes using Java bean method. It prints fine in windows, but giving below error when run on web using rwservlet. Actually we are using virtual dis [More]
I have written a plug-in for acrobat 9 and need to retreive the value stored in the "select output location" field from the default "edit batch sequence" dialog. How can I get a handle to the "edit batch sequence" dialog and [More]
Dear Folks, Customer requirement is to see subcriterion level scores of Vendor Evaluation according to material, Material group wise. But the datasource provided by SAP is providing the data according to Purchasing Organisation level and Vendor level [More]
I have just bought a new Mac. Everything in LR works fine on the new one, except I can't delete my photos. I flag them and hit cmd+delete, and it comes up with a box on the screen saying that the drive does not support trash, so I have to delete them [More]
I was walking and fell when my ipod touch 4gen was in my hand and i must of squeezed the screen because i fell in grass and the screen is shattered. I was wondering where i could take it/ send it in to get it fixed? the ipod still turns on and stuff [More]
Hello there, I'm in the process of working through a Unicode conversion on an ECC 6.0 system, and one of the steps is to run report TERM_DELETE_INCORRECT_CHARSET.  We are on a lower Support Pack level then when this report is delivered via OSS Note 1 [More]
I've just imported photographs taken with a new camera (Canon 7D). The photos look fine at first, whilst rendering the preview and the histogram is "calculating ...", but then change, becoming darker, with an orange cast. This is not happening t [More]
Cannot fully uninstall Reader 10.1.1 or instal 10.1.4 as same Microsoft error message comes up: "This patch package could not be opened. Verify that the patch package exists and you can access it, or contact the application vendor to verify that this [More]
I've put off installing 10.8 on my old (but not that old) Mac Pro. Bought a new hard drive, partitioned it, installed 10.6 on it, installed 10.6.8 on it, and then bought and downloaded Mountain Lion. The install seems to work, but then, rebooting, i [More]