Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1369
  • Last Modified:

Trying to get ODBC set up for a windows 2008 r2 server to connect to a Oracle 92 server.

We are running A windows 2008 R2 server that is being used as a web server that uses .asp.  We are trying to set up an odbc to a server with Oracle 92 on it.

I have not had any luck getting the proper driver installed to get the odbc connection working.

Does anyone know where I can get the proper ODBC drivers and how to install them.

Also any help on how to set up the ODBC would be helpful.

Thank You
0
Greg Duffin
Asked:
Greg Duffin
  • 9
  • 6
  • 2
5 Solutions
 
slightwv (䄆 Netminder) Commented:
I suggest the Oracle Instant Client.  You can download it from:
http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

You first need the 'Basic' then the ODBC add on.

The problem you are going to have is 9i is no longer supported and is not available for download.  It's possible one of the newer versions will be compatible with your ASP code.

They should connect to the 9i database.

0
 
Aaron ShiloChief Database ArchitectCommented:
you need to install oracle client on the windows server
0
 
Greg DuffinAuthor Commented:
Ok I have downloaded the Instant Client, both Basic Lite and ODBC from Oracles site.  I have Unzipped them into a directory c:\oracle.  I added the c:oracle to the PATH variable in the environment variables.  I then ran then odbc_install.exe.  I see the drivers when I go to the ODBC  I set it up with the name the TNS service but when I test the connection it tells me

Unable to connect
SQLState-08004
[oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified.

Am I missing something in the install?
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
slightwv (䄆 Netminder) Commented:
The 'flaw' in the instant client is:  it does not create a tnsnames.ora file for you.

If you have one, manually create the following structure and copy it there:
c:\oracle\network\admin

If you don't have a tnsnames.ora file, use the stub below.  change the alias, host ip address, port and service name for your database.
# tnsnames.ora Network Configuration File: C:\Oracle\product\10.1.0\Client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

DBALIAS =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.4)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = SOMEDATABASE)
    )
  )

Open in new window

0
 
Greg DuffinAuthor Commented:
Are there any installation other than unzipping the files into a directory?  I have unzipped them into c:\oracle.  When I go to odbc Administrator it sees the driver.  When Unzipped the files when into another directory called instantclient_11_2.  I keep getting TNS could not be found.

I created a c:/oracle/network/admin/tnsnames.ora.  I also tried putting the the tnsnames.ora in c:/oracle/instantadmin_11_2/network/admin.   I am still get the same error.  When I select the drop down box in the odbc Admin forn TNS nothing shows up.

Still getting TNS name could not be found.

Just not sure if it I have it installed correctly.  Is there an install file or is it just unzip the file?  Could I be missing anything else?

Thanks for your help.
0
 
slightwv (䄆 Netminder) Commented:
>> there an install file or is it just unzip the file?

It's been a while since I had to install the instant client but vaguely remember some pieces have some setup/install to actually run that set's up the registry.  I know the ODAC piece does.  I can't remember if the ODBC piece does or not.

There should be a readme type file that has the 'install' instructions.


0
 
Greg DuffinAuthor Commented:
There is an install for the ODBC portion.  But for the basic client I do not see any install file.
0
 
Aaron ShiloChief Database ArchitectCommented:
hi

i think you should download the full client this allways works for me.
there you can use the NET configuration assistant.

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html
0
 
slightwv (䄆 Netminder) Commented:
>>But for the basic client I do not see any install file.

For the basic I don't remember one.

After running the installer from the instantadmin_11_2 directory is everything running as expeected?
0
 
slightwv (䄆 Netminder) Commented:
>>i think you should download the full client this allways works for me.

It will likely work but is unnecessary for just ODBC.
0
 
Greg DuffinAuthor Commented:
>>For the basic I don't remember one.

>>After running the installer from the instantadmin_11_2 directory is everything running as expeected?

No still getting that it cannot find TNS name.  
0
 
slightwv (䄆 Netminder) Commented:
Last resort:
set a system environment variable TNS_ADMIN=c:/oracle/instantadmin_11_2/network/admin
0
 
Greg DuffinAuthor Commented:
Still no luck getting it going.  I unistalled everything and started from scratch.  It just does not seem to find my tsnames.ora file.

I have added the TNS_ADMIN variable and still no luck.

I also tried to install from the full client download with no success.

Is there any step by step documentation out there for installing instant client and getting the ODBC up and running.

Thanks
0
 
slightwv (䄆 Netminder) Commented:
Oracle 'uninstalls' almost always leave junk around.  I always prefer the manual uninstall but that has risks.

After you've removed everything (nothing Oracle is supposed to be left), check the registry for \HKEY_LOCAL_MACHINE\SOFTWARE  see if there is still an ORACLE key.  As long as you are sure there is not supposed to be any Oracle still on the box, you can delete this key.

Since you are using the ODBC drivers, you might also check the ODBC registry info for left over Oracle items.  Sorry, I don't know exactly where all to look for the ODBC entries.

Do you have access to Oracle's support site (or does one of your DBAs)?

Check out:
Connecting Using Instant Client Fails With ORA-12154 [ID 290866.1]

Unfortunately I cannot post any of the content here.

There's a list of registry settings to look for but states a properly set TNS_ADMIN overrides them all.


>>Is there any step by step documentation out there

I would have to Google.  I'll leave that to you.

0
 
slightwv (䄆 Netminder) Commented:
I also want to clarify:
When installed in c:\oracle everything worked.  It's just when you tried to go to a different folder that it stops.  Correct?
0
 
Greg DuffinAuthor Commented:
>>I also want to clarify:
When installed in c:\oracle everything worked.  It's just when you tried to go to a different folder that it stops.  Correct?

No it has never worked.
0
 
slightwv (䄆 Netminder) Commented:
>>No it has never worked.

Thanks for that.  One of your previous posts confused me.

I'll wait for your feedback from the information provided in http:#a35029009
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 9
  • 6
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now