Analytics Software

It would be nice if someone could answer this question. I am having the same issue.

Regards,

Kelly

There is currently no Oracle software supported on Win7.

For Windows 7 support information refer to the following notes on My Oracle Support:

Statement of Direction: Oracle Database 10g Release 2 (10.2.0.5) Client on Microsoft Windows 7 and Microsoft Windows Server 2008 R2
Read My Oracle Support Note 1061272.1 to learn about Oracle Database Client 10.2.0.5 planned support for Windows 7 and Windows Server 2008 R2.

Statement of Direction: Oracle Database 11g Release 2 on Microsoft Windows 7 and Microsoft Windows Server 2008 R2
Read My Oracle Support Note 867040.1 to learn about Oracle Database's planned support for Windows 7 and Windows Server 2008 R2.


32 bit software requires 32 bit odbc driver and 32 bit client.
64 bit software requires 64 bit odbc driver and 64 bit client.
Office2010 comes in both 32 bit and 64 bit flavors as I understand it, so you'll need the right version of odbc/client depending on which you have installed.
Microsoft only makes a 32 bit ODBC driver for Oracle.

Hope it helps,
Greg

Edited by: gdarling on Mar 2, 2010 11:13 AM

Hi,

Do you have an ETA on the Win 7 oracle client with the ODBC dirver(Q1CY2010 is that end of march 2010)? 32 bit will do at this stage. I have many applications that depend on a working oracle ODBC dirver, MS Access, Intellij, Xcase, etc. Older versions of the oracle client fail to install on OS version checks.

Thx
Kevin

I've heard no new information other than what is in the statements of direction
Greg

Edited by: gdarling on Mar 2, 2010 11:14 AM

I have contacted Metalink. All they said is that it will be available soon but no specific date is available.

Kelly

Here's the solution.

My operating system is Windows 7 64-bit, using Office 2010 64-bit. Trying to connect to an ODBC data source through Excel. The data source is an Oracle9i 32-bit database on a Windows Server 2003 32-bit server. However, the database version or server operating system is arbitrary; it could be an 8i, 9i, 10g, or even an 11g 32-bit or 64-bit database on a UNIX or Windows server. If you're using Windows 7 64-bit and you want to connect to an ODBC data source through Excel to an Oracle database, you must use Office 2010 64-bit. You cannot use Office 2003 or 2007, for example.

Follow these steps on your Windows 7 64-bit PC to connect to your ODBC data source.

1. Through Oracle's web site, go to Instant Client Downloads for Microsoft Windows (x64). Currently, the address to that page is:
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winx64soft.html

2. Download the two following files, found under the version 11.1.0.7.0 heading:
Instant Client Package - Basic (instantclient-basic-win-x86-64-11.1.0.7.0.zip)
Instant Client Package - ODBC (instantclient-odbc-win-x86-64-11.1.0.7.0.zip)

3. Extract both zip files to the same directory (such as c:\oracle\instantclient_11_1).

4. Launch the Command Prompt (DOS command window) by running it as administrator. Go to Start > All Programs > Accessories, then right click Command Prompt and select Run as Administrator.

5. From within the Command Prompt, navigate to c:\oracle\instantclient_11_1, and run odbc_install.exe. You should receive a message saying Oracle ODBC Driver is installed successfully. The name of the new ODBC driver that was just installed is Oracle in instantclient11_1 -- use this driver when creating your ODBC connection.

6. Create a new system environment variable. Set the value of the variable name as TNS_ADMIN, and the value of the variable path as the directory that contains the tnsnames.ora and sqlnet.ora files. On my PC, I have another Oracle client already installed which has its own tnsnames.ora and sqlnet.ora files. Therefore, I set the value of variable path as c:\orant\net80\admin (the directory that contains my tnsnames.ora and sqlnet.ora files). If you don't have another Oracle client installed on your PC, create a new directory such as c:\oracle\instantclient_11_1\network\admin, and place the tnsnames.ora and sqlnet.ora files in that directory. Then, set c:\oracle\instantclient_11_1\network\admin as the value for the variable path.

7. To create the ODBC connection, go Start > Control Panel > Administrative Tools > Data Sources (ODBC). Alternatively, you can create the connection right from within Excel.

Hi,

I think this link makes these excellent details more clear: http://robertoschiabel.wordpress.com/2008/02/28/windows-x64-32bit-odbc-vs-64bit-odbc/

This describes how to verify 32/64 bit ODBC connections (because they are treated separately) on Win7 64-bit.

I downloaded both 32/64 bit Oracle clients + their ODBC driver to my computer, and I was able to register both ODBC driver successfully based on your explanation.

So now, I can use my Office 2007 with the 32bit Instantclient ODBC package, and probably I could use Office 2010 with the 64bit one (I don't have Office 2010 :) )

So don't forget. Setup 32bit ODBC connections with %WINDIR%\SysWOW64\odbcad32.exe
and use %WINDIR%\System32\odbcad32.exe for the 64bit driver.

Cheers

Hello,

I have to say I am pleased people are trying to help; however, I can not get this solution to work.

I followed Jam The Man's instructions completely. I am getting the following error:
TNS:lost contact

I am running Windows 7 64 bit OS.

user575710,

When you say, So don't forget. Setup 32bit ODBC connections with %WINDIR%\SysWOW64\odbcad32.exe
and use %WINDIR%\System32\odbcad32.exe for the 64bit driver. I simply don't know what you mean...

Any help is appreciated.

Kelly

Kelly,
I've implemented that solution for a number of clients of ours, so I know those steps work. The error you're getting, TNS:lost contact, may be indicative of another problem. What is the database (or data source) that you're trying to connect to? Can you connect to it from another machine, for example? Are you getting that error through the ODBC Administrator panel when trying to do a test connection, or were you getting that error through Excel? What is your connection to the network, I've seen issues when the client PC was on a wireless network trying to connect to an Oracle db?

The other question you had. On Windows 7 64-bit, there are two ODBC Administrator control panels. There's a 32-bit one, and a 64-bit one. 32-bit apps (like Office 2007) cannot use the 64-bit ODBC drivers. 64-bit apps (like Office 2010 64-bit) cannot use 32-bit ODBC drivers. So in Windows 7 64-bit, Microsoft created two ODBC Administrator consoles for setting up the appropriate drivers.

32-bit ODBC connections are setup in %WINDIR%\SysWOW64\odbcad32.exe - this you can launch from the Command Prompt
64-bit ODBC connections are setup in %WINDIR%\System32\odbcad32.exe - this is what launches when you go to Control Panel > Administrative Tools > Data Sources (ODBC)

user575710,
I tried using the standard 32-bit ODBC driver "Microsoft ODBC for Oracle" when I attempted to try to connect to an ODBC source through Excel 2007 (32-bit) or Office 2010 (32-bit), yet it was failing to connect (on Windows XP 32-bit or Windows 7 32-bit, that driver works). I did create the DSN through %WINDIR%\SysWOW64\odbcad32.exe. Since it didn't work, that lead me to believe that using a 32-bit ODBC driver on Windows 7 64-bit to connect to your data source through Office 2007 is not possible. Just to be clear, the 32-bit ODBC driver you used to connect through Office 2007 was the one installed by using the 32-bit Instant Client Basic and ODBC packages? If so, I'll give it a try and let you know.

Hi,

Thanks for steps. I am trying to create ODBC connection for windows 7 64 bit as per the steps you described but i am getting the error

"Unable to connect SQLState=08004 ORA-12154:TNS:could not resolve the connect identifier specified".

TNS Service Name in ODBC setup shows the junk character instead of my service name. May be I missed some configuration.

what i am doing wrong.

Thanks in advance.

Sumit Agarwal

Hello Jam,

I can connect to the database fine on another computer using the exact same tnsnames.ora file. I am getting the error through ODBC Administrator panel when trying to do a test connection. I'm on a wired network connection.


When i run %WINDIR%\System32\odbcad32.exe, the new driver is available, I just can't seem to connect. However, When I run %WINDIR%\SysWOW64\odbcad32.exe, the new driver is not an option in the list.

Best Regards,

Kelly

Hi Jam,

Yes, you are right, I downloaded Instant Client 11.1 (both 32 and 64 bit) onto my computer.
So my dir structure looks like:
C:\Oracle\Instantclient_11_1
C:\Oracle\Instantclient_11_1.x64

Of course I have only one TNSNAMES.ora file (under .x64 directory) and set the shell environment pointing to that folder.

To be able to register both (32 and 64 bit) clients with the appropriate ODBC admin console, and make them available for 32 and 64 bit applications, I had to run the odbc_install.exe from both directories (with admin rights!).

So now, I can reach database through InstallClient_11_1 - ODBC (32bit) connection from Excel 2007 and I suppose I could connect to database through InstallClient.x86 - ODBC (64bit) connection with Excel 2010 without problem.

Microsoft ODBC for Oracle has never worked for me.

Sorry, if I was not clear last time.

For us, at this time, we used this method to get it to work for us.

Uninstalled the 64bit Oracle client. (while we could get our vbscript to connect to oracle via a DSN, the oracle drivers will connect only 1 oracle version different database) (Microsoft ODBC for Oracle is the desired driver since it will connect to various oracle versions)

Installed 10203_vista_w2k8_x86_production_client (I did a custom install to include odbc and utilities)

Create a shortcut on the desktop to the 32bit odbc admin. (this is not required, since we prefer to use dsn-less connection strings) (well, thru that admin, we could see that the Microsoft ODBC for Oracle driver was listed)

For the server, we found these articles that referred to connecting to 32bit drivers.

http://serverfault.com/questions/98257/need-to-run-an-iis-website-in-32bit-mode-on-a-64bit-windows-server
http://learn.iis.net/page.aspx/201/32-bit-mode-worker-processes/

we set on the server:
aspnet_regiis -enable -i
cscript.exe adsutil.vbs set W3SVC/AppPools/Enable32BitAppOnWin64 true

The only downside appears to be:

http://serverfault.com/questions/38377/running-multiple-32-bit-application-pools-on-64-bit-windows-2008

I can't find it now, but there was a page that actually suggested to enable 32bit processes on 64bit windows.

Anyways... presently it appears to work. Our vbscript is using a dsn-less connection string specifying the Microsoft ODBC for Oracle driver to connect to our Oracle 8, 10 and 11 databases.


(personally, would like to see Oracle step up to the plate and release drivers for current client platforms within a reasonable timeframe of the OS release. Surely, Oracle had access to Server 2008/Windows 7 during the beta period)

Jam The Man's solution worked for me.
>
Here's the solution.

My operating system is Windows 7 64-bit, using Office 2010 64-bit. Trying to connect to an ODBC data source through Excel. The data source is an Oracle9i 32-bit database on a Windows Server 2003 32-bit server. However, the database version or server operating system is arbitrary; it could be an 8i, 9i, 10g, or even an 11g 32-bit or 64-bit database on a UNIX or Windows server. If you're using Windows 7 64-bit and you want to connect to an ODBC data source through Excel to an Oracle database, you must use Office 2010 64-bit. You cannot use Office 2003 or 2007, for example.

Follow these steps on your Windows 7 64-bit PC to connect to your ODBC data source.

1. Through Oracle's web site, go to Instant Client Downloads for Microsoft Windows (x64). Currently, the address to that page is:
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winx64soft.html

2. Download the two following files, found under the version 11.1.0.7.0 heading:
Instant Client Package - Basic (instantclient-basic-win-x86-64-11.1.0.7.0.zip)
Instant Client Package - ODBC (instantclient-odbc-win-x86-64-11.1.0.7.0.zip)

3. Extract both zip files to the same directory (such as c:\oracle\instantclient_11_1).

4. Launch the Command Prompt (DOS command window) by running it as administrator. Go to Start > All Programs > Accessories, then right click Command Prompt and select Run as Administrator.

5. From within the Command Prompt, navigate to c:\oracle\instantclient_11_1, and run odbc_install.exe. You should receive a message saying Oracle ODBC Driver is installed successfully. The name of the new ODBC driver that was just installed is Oracle in instantclient11_1 -- use this driver when creating your ODBC connection.

6. Create a new system environment variable. Set the value of the variable name as TNS_ADMIN, and the value of the variable path as the directory that contains the tnsnames.ora and sqlnet.ora files. On my PC, I have another Oracle client already installed which has its own tnsnames.ora and sqlnet.ora files. Therefore, I set the value of variable path as c:\orant\net80\admin (the directory that contains my tnsnames.ora and sqlnet.ora files). If you don't have another Oracle client installed on your PC, create a new directory such as c:\oracle\instantclient_11_1\network\admin, and place the tnsnames.ora and sqlnet.ora files in that directory. Then, set c:\oracle\instantclient_11_1\network\admin as the value for the variable path.

7. To create the ODBC connection, go Start > Control Panel > Administrative Tools > Data Sources (ODBC). Alternatively, you can create the connection right from within Excel.


Thanks man it worked for me.
My host environment is windows 7 x64 ultimate and I have my oracle 10g in centos installed in VMware.
Previously I had vista home premium x64 there instantclient 10.2 basic and odbc worked but in windows 7 it wasn't working.
Thanks again.

I have installed Oracle 11g on windows 7. In ODBC administrator I can see the driver for Oracle 11g(64bit) on drivers tab. But when I am trying export a table from MS access 2007(32bit), oracle 11g driver not visible in the display list of create new data source.

I have uninstalled MSOffice 2007 and installed 64bit version of MS Access data engine from Microsoft and reInstalled Msoffice 2007. But the Oracle driver did n't appear in list in MS Access2007.

I have created new data source for oracle 11g driver and configured, tested the connection using ODBC adminstrator.The connection is successfull. this time the newly created DSN appeared in MS access ODBC dialogbox. But when I am trying to use it, I am getting followin error message.:

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

Please help me.

Thanks in advance

You sir are a true gentleman and a scholar! This is the answer I have been looking for for two weeks now and it worked perfectly. Thank you so very much.

Hi... I am using windows7 home premium 64 bit..... having a problem working with oracle 10g....

I created a dsn and started working with java..tried to connect to oracle....when ever i run my java program i am getting an error as java.sql.sqlexception ...connection not open.....

can u plz give a solution for this....

Thank you! That pointer to the 32-bit ODBC driver control panel was just what I needed!

I was looking for help getting Excel 2007 ODBC on a Windows 7 64 bit system working into an Oracle On Demand site. I've followed the described steps and once I remembered to use my apps user ID and PW, instead of my VPN user, it worked perfectly. Thank you for your clear explanation.

S.

Worked like a charm! Thanks so much! I was lost trying to find a solution. I followed your instructions EXACTLY.

I have follow the procedure that "Jam The Man" and "users575710" posted and it seems to work well. My problem is when I open previously created Excel Report. I am getting this error (see below). These report where created using ODBC/MS Query. The ODBC driver use was MS ODBC for Oracle. The sytem was Windows XP 32bit and Office 2003.

The error I am getting is

The Oracle™ client and networking components were not found. These components are supplied by Oracle corp. and are part of the Oracle Version 7.3 (or greater) client software installation. You will be unable to use this driver until these components have been installed.

Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

This error also occur when I use MS ODBC for Oracle in my WIndows 7 64 bit system using Office 2003. If I use "Oracle in Instantclient 11_2" (ODBC driver), I have no problem creating the report.

Likewise, report created in Win 7 64bit office 2003, I can't open it in Windows XP office 2003. The error is ,

MS ODBC Driver Manager, Data source name not found and no default driver specified

From my limited knowledge in this, It seems it has to do with the ODBC driver.

Any idea? Appreciate the help on this.

I am trying to follow up on the previous post I did.

Does anybody has any idea on this?

Thanks
Tony

Hi Xperts, I have deployed a new server with Server 2008 R2. I tried the steps mentioned using administrator login and was able to connect using Excel 2007 to Oracle database, But I have a problem.

I created a local user (say X) and wanted the odbc to be available for this user also as I have Remote Desktop Service (formerly Terminal Server) enabled. When I login using X, I am not able to see the odbc connection. TNSPING works fine but odbc gives "ORA-12154: TNS:could not resolve the connect identified specificied Driver's SQLSetConnectATTR Failed". Can anyone help me or provide me some suggestions.

Thanks

Hi everyone
I am trying to connect to oracle database 10g rel2 64-bit running on solaris 10 from .net framework 4.0(2010) which is installed on windows 2008 64-bit server. I have installed oracle 11g 64-bit client on windows 2008, and additionally i have downloaded and extrated ODAC for .net 4.0 and set the path variable for ODAC and client and my tnsnames entry is working fine. But when iam trying to use assembly Oracle.Dataaccess.client its getting referenced but it fails to connect to database, by giving warning that assembly is not registered please somebody help me out i have stuck in between...

Hi all,
I am running Excel 2003 on Windows 7 Home Premium.

I also have Oracle XE installed.

Do I have any chance of being able to get Excel 2003 to connect to Oracle XE using ODBC ?

If not, what are my options ?

Jeff,

I saw a number of posts, but I just had a similar problem. If your client app is 32 bit, read on. If your app and OS are both 64, skip this message (but be careful, sometimes apps run as 32 bit apps even when you expect them to run as 64 bit....)

If your client app is 32 bit and you install the 64 bit drivers, it won't work.

If you install the 32 bit drivers, the Windows ODBC manager you see is the 64 bit version and won't work. Find the one in the syswow64 folder (C:\Windows\SysWOW64\odbcad32.exe) and use that.

It wasn't until I removed the 64 bit Oracle, installed the 32 bit Oracle, and then used the syswow64 version of ODBC before I was able to get things working.

And this worked much better than the instant client, which gave me all kinds of fits (but probably works as well - once you learn the secrets.)

Take care,

JustMe

If client app is 32 bit - do you mean Excel 2003. I assume it is even though its installed on Windows 7.

How do I tell if my version of Oracle XE is 64 bit and not 32 bit ?

Gailimh,

Any app that was developed and released before Windows Vista is most likely a 32 bit app. And most apps released after Vista came out are still 32 bit apps unless you purchased the 64 bit version.

I don't believe there even was a 64 bit version of Office 2003.

Remember that a 32 bit app that is running on a 64 bit OS is still a 32 bit app - so it will still need the 32 bit drivers (yes, it can get confusing..)

Also, remember that some apps can run in either 32 or 64 bit mode. When running those on a 64 bit machine, they usually run as 64 bit apps, but if they make calls to 32 bit libraries, Win 7 might make them run as 32 bit. What fun....

Take care,

JustMe

user12203844 - I ran into a problem with 64-bit oracle client on Solaris still needing at 32-bit link lib to get sqlplus to connect to the 64-bit database. You might be running into a similar problem. Can you see if the 32-bit client on windows will work for you?


BTW, thank you to everyone else here. The information in this thread is very helpful and solved my issues.

Hi,
Can any one help me with the information, If the Oracle 9i ODBC drivers supported on Windows 7 Enterprise 32 bit, Access 2007 as the front end and Oracle 9i database as the backend.
If the 9i drivers are not supported on Windows 7 Enterprise 32 bit which version is the supported version.

Thanks
Srini

Srini,

Posting the same question in multiple threads just makes things confusing when people do searches. Please see the answer I gave you in the Re: ODBC driver doesn't appear in ODBC data source thread (9443531

JustMe

Hi all,

I have win 7 64 bits and excel 2007 32 bits installed. I have followed the instruction from "Jam The Man" to install oracle client in my local and everything was running fine till I can look for the ODBC connection to my oracle server. But, when I tried to connect the ODBC via Excel 2007, I have encountered the error of "The specified DSN contains an architecture mismatch between the driver and application". If I tried to do the connection again, from the data connection wizard, I have select ODBC DSN, and the screen will give me list of ODBC data sources that I have created previously from the C:\Windows\SysWOW64\odbcad32 but once I have selected, the screen has prompt another error message "Unable to connect to data source. Reason: Access denied. You either made a mistake typing in your user id and/ or password, or you do not have permission to access the database server."

Which step am I went wrong ? As I can connect to the server from control panel but was unable to connect to the server via excel 2007. Any one can help me please!

Thanks

Lim

Lim,

The reason you are having trouble is that his instructions apply to the 64 bit Win 7 AND the 64 bit Office. You have the 32 bit office.

My approach would be:
1) Open the 32 bit version of ODBC administrator and remove any entries you have created. The 32 bit version is C:\Windows\SysWOW64\odbcad32.exe. If you just run the link that say ODBC Administrator, you are usually running the 64 bit version.
2) Remember that the 64 bit version of the ODBC Administrator can't see 32 bit ODBC drivers and vice versa
3) Go to http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.htm and download the 32 bit drivers
4) During install, choose the custom option and, at a minimum, check SQL*Plus, Oracle Net, and Oracle ODBC Driver. You can choose other options if you know you also need those features, but these 3 are all you need for most ODBC situations.
5) Now run the Oracle Net Manager to set up the TNSNames.ora file per whatever settings you need. You should be able to run a test from here as well (provided you have a login name/pw)
6) Now run the 32 bit version of ODBC Manager and setup the ODBC drivers.

Take care,

JustMe

I was unable to access the link that you provided. http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.htm


Please resend again. Thanks.

Regards,
Lim

Sorry for the expired link. Here is the main link to the downloads:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
From there, choose either 32 or 64 bit and click on see all
Then choose the "Oracle Database 11g Release 2 Client (11.x.x.x.x) for Microsoft Windows (xx-bit)"

I wish that Oracle wouldn't just delete the download page but instead redirect them to the index.... Oh well.

Take care,

JustMe

No, I was couldn't managed to connect from excel via 32 or 64 bits to my 64 bits PC.

My last choice to make it work is by installing 64 bits of office 2010 and it solve my problem right a way rather than spending week but with no result.

Still could not find out why others are able to connect their office 2007 ( 32 bits ) with 64 bits machine.




Regards,
Lim

Lim,

Not sure why you couldn't get 32 bit to work, but as long as the 64 bit is working for you, I guess it doesn't matter much.

Thanks for the update.

JustMe

Hi Guys,

I'm having the same problem on my Access 2007. I'm fairly new to Oracle and I need help to make an odbc connection to a remote server.

I've installed the client and basic lite into my C:\Oracle but everything else that people are talking about, like tnsnames.ora or configuration tools etc, is non-existent in my folder. I'm at lost since I don't know where to put the IP address or username and password. I'm guessing it is because I don't really have an Oracle database installed on my machine. My Oracle Home only exists because I have installed the Oracle Jdeveloper 11g.

Do I need to install the Oracle Database 11g to be able to set up an instant client? I figured that since it is just a client set up that I wouldn't need the whole package.

Any help would be appreciated. thanks

It's best to open a new thread rather than piggybacking on a thread as long as this.

To configure a DSN, open the ODBC administrator, click the System DSN tab, click Add, select the Oracle ODBC driver. In the dialogue that follows, give the DSN a name, fill in your username, and for TNS Service Name fill in //host:port/service_name where
host = the name of the machine the db is on
port = the port the listener is on
service_name = the servicename of the identifier.

//host:port/servicename is the form of the connect string where you enter the information directly and avoid needing tnsnames.
Your dba should be able to give you the info for those three things if you dont already have it.

Hope it helps,
Greg